While Updating Price & Quantity in Purchase Order (Localized) Error "APP-PO-14142: update_line: ORA-20001: APP--20110: Encountered the error in trigger JAI_PO_LLA_ARIUD_T1ORA-06502: PL/SQL: numeric" (Doc ID 885672.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Financials for India - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Oracle Application - India Localization - Version: 12.1.1


Symptoms

Problem Statement:

When attempting to Update the Approved Purchase order Price & Quantity in India Local Purchase Order it is getting errored out.

ERROR:

APP-PO-14142: update_line: ORA-20001: APP--20110:
Encountered the error in trigger
JAI_PO_LLA_ARIUD_T1ORA-06502: PL/SQL: numeric or value
error: character to number conversion error
ORA-06512: at"APPS.APP_EXECUTION",line 72
ORA-06512: at"APPS.JAI_PO_LLA_ARIUD_T1:,

STEPS TO REPRODUCE:

1. Create a PO
2. Approve the PO
3. Try updating the Price and Quantity

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