ORA-20100

ORA-20100: ERROR: FND_FILE FAILURE. Unable to Create File when Creating Payment Batch [ID 979364.1]

Applies to:

Oracle Payables - Version: 12.0.0 to 12.0.6 - Release: 12.0 to 12.0
Information in this document applies to any platform.

Symptoms

When creating a Payment Batch Template or Payment Process Request, the system throws the following error message:
 "You have encountered an unexpected error. Please contact the System Administrator for assistance.
   JAVA.SQL.SQLEXCEPTION: ORA-20100: ERROR: FND_FILE FAILURE. UNABLE TO

   CREATE FILE"

Cause

IBY_XML_TEMP is set to the database-tier temporary directory, when it should be the middle-tier
directory:

Autoconfig : IBY_XML_TEMP refers to middle tier directory.

Detailed information is provided in the following bug:
unpublished Bug 6808244 AUTOCONFIG IBY_XML_TEMP TO REFER TO MIDDLE-TIER DIRECTORY

The issue is fixed in ibywebprf.sql  120.8.12000000.2 or higher version.

Solution

Please execute the following steps in 12.0.X:

1. Download and review the readme and pre-requisites for the Patch 11792656:R12.IBY.A
Please contact Oracle Support to get the password.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

admin/template/ibywebprf.sql 120.8.12000000.9

You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'

OR

Please execute the following steps in 12.1.X:

1. Download and review the readme and pre-requisites for the Patch 11792656:R12.IBY.B
Please contact Oracle Support to get the password.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

admin/template/ibywebprf.sql 120.8.12010000.8

You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'