POXPDOI: Import Catalog Quotation Fails - Fdpstp Failed Due to Ora-06510: Pl/sql: Unhandled User-defined Exception
(Doc ID 2211168.1)
Last updated on OCTOBER 02, 2023
Applies to:
Oracle Purchasing - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
POXPDOI: Import Price Catalogs errors with the following:
ERROR:
This error is noted in the PDOI Concurrent Request Log:
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 392
ORA-06512: at line 1
The errors below were noted in the FND Debug taken for the concurrent request:
po.plsql.PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id.RETURN Return value = 3048
po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT.default_locs_for_spo.20 default line loc = 3048
po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT..default_locs_for_spo.20.EXCEPTION ORA-01403: no data found in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure default_locs_for_spo.20;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT..default_line_locs.10.EXCEPTION ORA-01403: no data found in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure default_line_locs.10;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_MAINPROC_PVT..process_line_locations.50.EXCEPTION ORA-01403: no data found in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_line_locations.50;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_MAINPROC_PVT..process.50.EXCEPTION ORA-01403: no data found in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.50;SQLERRM = ORA-01403: no data found
po.plsql.PO_PDOI_PVT.set_draft_errors.BEGIN Start of subprogram.
po.plsql.PO_PDOI_PVT.set_draft_errors.END End of subprogram.
po.plsql.PO_PDOI_PVT..start_process.110.EXCEPTION ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = ORA-01403: no data found
Error procedure default_locs_for_spo
STEPS TO REPRODUCE:
1. Populate interface tables to update expiration from \ to dates for quotation
2. Run the "Import Price Catalog"
Changes
Upgrade from 12.2.3 to 12.2.6
or
Apply patch 20787806 - In Oracle Purchasing, the autocreated PO takes receipt required flag from finance option
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 |
Changes |
Cause |
Solution |
R12.1.3 |
R12.2.6 |
References |