To resolve the issue, an SR was opened with Oracle who, after verifying that the symptoms were a match via an OWC, provided the datafix in the form of two SQL UPDATE statements. The SQL statement in the above MOS document, when run, returned two rows, which were the error records. I checked the “ AUD: Supplier Costs Interface Audit” output and it showed: An ORACLE error has caused Transaction Import to abortĬhecking My Oracle Support for the above error, I got a hit on “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)” When “PRC: Interface Supplier Costs” is run, it spawns another concurrent job “ AUD: Supplier Costs Interface Audit“. I noticed that when individual projects were submitted in “PRC: Interface Supplier Costs” (using the Next, I checked to see if the APPS.PA_TRX_IMPORT and APPS.PAAPIMP_PKG packages were invalid. the session seemed to be blocking itself. This showed that the ‘blocker’ and ‘waiter’ process was the same i.e. UPDATE PA_BC_PACKETS SET STATUS_CODE = 'T', RESULT_CODE = 'F140' WHERE STATUS_CODE = 'P' AND REĤ3ef83e88 11259 package body APPS.PA_TRX_IMPORTĤ3ef83e88 9201 package body APPS.PA_TRX_IMPORTĤ3ef83e88 9316 package body APPS.PA_TRX_IMPORTģcceb9750 1226 package body APPS.PAAPIMP_PKGģcceb9750 4666 package body APPS.PAAPIMP_PKGģcceb9750 243 package body APPS.PAAPIMP_PKG Current SQL Statement for this session (sql_id=arwwdkxfugbcb). End of information for the OTHER waiting sessions. Information for the OTHER waiting sessions. Session 2178: obj - rowid = 0001E7CE - AAAefOAAnAAAaDyAAA Resource Name process session holds waits process session holds waits
Information may aid in determining the deadlock: It is aĭeadlock due to user error in the design of an application The following deadlock is not an ORACLE error. More info in file /u01/oradata/prod/prod/db/tech_st/11.2.0/admin/PROD_apple/diag/rdbms/prod/PROD/trace/PROD_ora_c.Ĭhecking the /u01/oradata/prod/prod/db/tech_st/11.2.0/admin/PROD_apple/diag/rdbms/prod/PROD/trace/PROD_ora_c showed the following: *** 21:09:39.489 Because the error was a database error (it started with ORA-), the alert log was checked. To troubleshoot this issue, first the “PRC: Interface Supplier Costs” concurrent job was run from the Cost Management responsibility with the default parameters (Interface Supplier Invoices: Yes, Interface Receipt Accruals: No, Interface AP Discounts: No). Open an SR to get a datafix for the issue. 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)”. The output log shows the following error: ORA-20003: import1_prog:ORA-00060: deadlock detected while waiting for resource Problem: Running the PRC: Interface Supplier Costs completes in error.
0 kommentar(er)
