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.
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;
Problem: I want to create a custom concurrent program based on a SQL script, but do not know how to pass date parameters to the concurrent program.
Solution: Use ‘&1’, ‘&2’ etc. and format it using ‘yyyy-mm-dd hh24:mi:ss’ in the SQL program (i.e. to_date(‘&1’, ‘yyyy-mm-dd hh24:mi:ss’). In the Concurrent Program parameter setup, set the Value Set as FND_STANDARD_DATE.
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.
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.
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;
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.
Problem: We opened an SR with Oracle and they want us to run a diagnostics test for a payment process request. How do I run a diagnostics test in E-Business Suite?
Solution: Diagnostic tests in EBS are run from the Application Diagnostics responsibility.
Recent Comments