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 DECEMBER 18, 2017

Applies to:

Oracle Fusion Purchasing - Version 11.1.11.1.0 and later
Oracle 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




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.


 


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms