Option Specific Sourcing (OSS) on ATO Model Not Triggering Import Price Catalog Program (Doc ID 2443773.1)

Last updated on JANUARY 28, 2020

Applies to:

Symptoms

When attempting to process a Non-OSS ATO Model and with the same steps above,
the Import price catalog program is triggered which in turn triggers the Generate
Sourcing rule and ASL program and the the following error occurs.

ERROR
Rollup_purchase_price: Rollup_purchase_price::others::50
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
Create_Purchasing_Doc: Unexpected error in rollup_purchase_price procedure
PROCESS_PURCHASE_PRICE:: unexp error::60User-Defined Exception
query_wf_activity_status: exception in CTO_WORKFLOW_API_PK.query_wf_activity_status
ORA-01403: no data found

STEPS
1. Responsibility: Order Management Super User
2. Order Organizer > Query Sales Order #
3. Error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Changes

Cause

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