Monthly Archives: December 2014

RC-20200: Fatal: Could not find Unzip When Installing EBS R12

Problem: While installing EBS R12.1 on Linux x86-64, the following error appears:

"Processing Disk1....

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...

Cannot execute Install for database ORACLE_HOME

RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running Database Install Driver for TEST instance"

Solution: As root user, rename the default unzip (/usr/bin/unzip) to a temporary filename (e.g. /usr/bin/unzip-ver6), perform the installation, and then rename unzip-ver6 to the original name when complete.

# mv /usr/bin/unzip /usr/bin/unzip-ver6

Reference: R12 Rapid Install Failing With “RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.” (Doc ID 1455077.1)


Running PO Approval Analyzer Diagnostic as Concurrent Request

Problem: How do I set Approval Analyzer Diagnostic so that it can be run as a concurrent request?

Solution: Refer to My Oracle Support article “R12: Approval Analyzer Diagnostic Script (Doc ID 1525670.1)”.

Read more »

Resolving Stuck Selected For Payment Cheques

Problem: A number of cheques were printed and then spoilt as the wrong starting number was entered. AP tried to run the payment again, then realized that the invoices were not able to be pulled. The info on the payments showed that the cheques were still selected for payments.

Solution: Refer to R12 Generic Data Fix (GDF) Patch for Payment stuck when Invoices On “Spoiled Checks” remain in “Selected For Payment” Status (Doc ID 1367272.1). Apply patch 16216890, then run scripts $IBY_TOP/patch/115/sql/iby_splt_pmts_sel.sql and $IBY_TOP/patch/115/sql/iby_splt_pmts_fix.sql.

Read more »

Troubleshooting PRC: Interface Supplier Costs Issue

Problem: Running the PRC: Interface Supplier Costs completes in error. The output log shows the following error:

ORA-20003: import1_prog:ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "APPS.PA_TRX_IMPORT", line 11279
ORA-06512: at "APPS.PA_TRX_IMPORT", line 9201
ORA-01400: cannot insert NU

Solution: Refer to “PAAPIMP – PRC: Interface Supplier Costs fails with Error ORA-01400: cannot insert NULL into (“PA”.”PA_EXPENDITURE_ITEMS_ALL”.”BILLABLE_FLAG”) (Doc ID 1265338.1)”. This issue was caused by a data error. Open an SR to get a datafix for the issue.

Read more »

Monitoring Users in EBS

Problem: How do I determine who is logged on to EBS?

Solution: There are two ways you can do this: check the Monitor Users form, or run the Signon Audit Users report.

Read more »