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 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.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

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)

Applies to:

Symptoms

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!