ATP Processing Error: ORA-06502 at MSC_ATP_FUNC.get_supplier_name (Doc ID 2754706.1)

Last updated on MARCH 02, 2021

Applies to:

Symptoms

Problem Statement:

When customer name is in Thai language and it is long, ATP inquiry gives the below mentioned error:

Error:

"ATP DETAILS ERROR: ORA-01403: NO DATA FOUND "
ATP Processing Error ORA-06502 at MSC_ATP_FUNC.get_supplier_name

Steps:

a) Login to Oracle Apps.
b) R)ASCP -> ATP Inquiry -> get the above mentioned error.
c) R) Oracle Order Management -> Query for a Sales order
d) Click the lines tab and do 'ATP Check', the above mentioned error is displayed.

So, When checking ATP for specific Finished Good (by both ATP check at SO line and ATP Inquiry in ASCP) it results with ATP Processing 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.