Import Purchase Agreements Completes Successfully But An Exception JBO-29000 Is Listed In The Log File. Contract Purchase Agreement (CPA) Is Not Imported
(Doc ID 2207785.1)
Last updated on FEBRUARY 05, 2019
Applies to:
Oracle Fusion Purchasing - Version 11.1.11.1.0 and laterOracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
Symptoms
Import Contract Agreements completes successfully but an exception: JOB-29000 is listed in the log file.
Import Contract Agreements program complete successfully but the Contract Purchase Agreement (CPA) Is not imported.
Log file shows exception. Due to this issue, users cannot load agreements.
Error
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20001: po.db.plsql.PO_PDOI_MAINPROC_PVT..process.10
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_MAINPROC_PVT", line 209
ORA-20001: po.db.plsql.PO_PDOI_MAINPROC_PVT..process_org_assigns.50
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_MAINPROC_PVT", line 3138
ORA-20001: po.db.plsql.PO_PDOI_ORG_ASSIGN_PROCESS_PVT..default_org_assigns.50
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_ORG_ASSIGN_PROCESS_PVT", line 787
ORA-20001: po.db.plsql.PO_PDOI_ORG_ASSIGN_PROCESS_PVT..default_billto_loc_from_fsp.10
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_ORG_ASSIGN_PROCESS_PVT", line 1723
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 1
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_MAINPROC_PVT", line 209
ORA-20001: po.db.plsql.PO_PDOI_MAINPROC_PVT..process_org_assigns.50
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_MAINPROC_PVT", line 3138
ORA-20001: po.db.plsql.PO_PDOI_ORG_ASSIGN_PROCESS_PVT..default_org_assigns.50
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_ORG_ASSIGN_PROCESS_PVT", line 787
ORA-20001: po.db.plsql.PO_PDOI_ORG_ASSIGN_PROCESS_PVT..default_billto_loc_from_fsp.10
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_ORG_ASSIGN_PROCESS_PVT", line 1723
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 1
Steps To Reproduce
1. Run Import Contract Agreements program.
2. Completes successfully.
3. Observe that CPA not imported and find reported exception in log file.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |