Category Archives: Solaris

Changing Employee’s Start Date

Problem: How do I change the effective start date for an employee after it has been entered into EBS?

Solution: Use the hr_change_start_date_api.update_start_date procedure.

Read more »

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 »

Troubleshooting Cost Manager Issue

Problem: The Cost Manager concurrent job stopped running a few weeks ago. It now remains on the Pending phase. The Actual Cost Worker, which usually runs every five minutes, has not run since.

Solution: An error occurred while the Actual Cost Worker was running (tablespace ran out of space) and so the process completed in error. The errored process must be resubmitted, so that it completes successfully. After this, the Cost Manager and Actual Cost Worker began running once more.

Read more »

Resolving ORA-01653, ORA-01658 for tablespace APPS_TS_TX_DATA

Problem: Users are getting ORA-01653 or ORA-01658 for tablespace APPS_TS_TX_DATA.

Solution: Add another datafile to the APPS_TS_TX_DATA tablespace using the alter tablespace add datafile command:

alter tablespace APPS_TS_TX_DATA add datafile
 '/path/to/data/files/db/apps_st/data/a_txn_data0x.dbf' size 1950M;

Read more »

Invoices Stuck After PPR Terminated

Problem: After incorrect PPR (Payment Process Request) is terminated, the invoices cannot be selected for payment.

Solution:

Refer to R12: Generic Data Fix (GDF) patch for “stuck” invoices after PPR is terminated or completed (Doc ID 874862.1). Apply patch 19717441, then run the scripts $AP_TOP/patch/115/sql/ap_Rel_Inv_frm_TermPPR_sel.sql and ap_Rel_Inv_frm_TermPPR_fix.sql.

Read more »

Resolving ORA-1652 for tablespace TEMP1

Problem: Workflow has generated an error:

Event Error Name: WFE_DISPATCH_GEN_ERR
Event Error Message: 3835: Error '-1652 - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.
Event Error Stack: 
Wf_Event.setMessage(oracle.apps.wf.notification.send, 470315, WF_XML.Generate)
Wf_Event.dispatch_internal()

Solution: Turn on autoextend on the tempfile in the TEMP1 tablespace, or add another tempfile.

Read more »

Resolving ORA-01691 for tablespace APPS_TS_MEDIA

Problem: When uploading attachments to EBS, the following error appears:

ORA-01691: unable to extend lob segment APPLSYS.SYS_LOB000000000000000123043$$ 
by 16 in tablespace APPS_TS_MEDIA

Solution: Add another datafile to the APPS_TS_MEDIA tablespace using the command:

alter tablespace APPS_TS_MEDIA add datafile
 '/path/to/data/files/db/apps_st/data/a_mediaxx.dbf' size 4096M;

Read more »

Resolving ORA-01427 Error

Problem: A custom developed XML report for EBS is returning an “ORA-01427: single-row subquery returns more than one row” error when run.

Solution: For this report, include the predicate “AND rownum = 1” in the WHERE clause of the SQL SELECT statement.

Read more »