Import BPA by PDOI Error

(Doc ID 2047553.1)

Last updated on AUGUST 24, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Purchase Order

When attempting to run PDOI to import BPA, got error in the debug log:

ERROR
-----------------------
po.plsql.PO_PDOI_MAINPROC_PVT..process_create_lines_in_group.70.EXCEPTION 4 ORA-01403: no data found in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_create_lines_in_group.70;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_MAINPROC_PVT..process_lines_sync.80.EXCEPTION 4 ORA-01403: no data found in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_sync.80;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_MAINPROC_PVT..process_lines.40.EXCEPTION 4 ORA-01403: no data found in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.40;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_MAINPROC_PVT..process.30.EXCEPTION 4 ORA-01403: no data found in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.30;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_PVT.set_draft_errors.BEGIN 2 Start of subprogram.
po.plsql.PO_PDOI_PVT.set_draft_errors.END 2 End of subprogram.
po.plsql.PO_PDOI_PVT..start_process.110.EXCEPTION 4 ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = ORA-01403: no data found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populated data into interface.
2. Run Import Price Catalogs Process to update BPA, got above error message.

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