My Oracle Support Banner

Option Specific Sourcing ATO Model Not Trigger Import Price Catalog Program (Doc ID 2443773.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Configure to Order - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Configuration Process

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 = 210000049114
3. Error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error


Changes

 

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
References


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