POXPDOI: Import Catalog Quotation Fails - Fdpstp Failed Due to Ora-06510: Pl/sql: Unhandled User-defined Exception (Doc ID 2211168.1)

Last updated on JULY 26, 2017

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


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

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