Error Description

PO-14142: INSERT_ROW-013: ORA-06502: PL/SQL: numeric or value error, character string buffer too small
ORA-06512: at "APPS.ADS_UTIL_PKG", line 21
ORA-06512: at "APPS.ADS_PO_REQUISITION_LINES_TRG1", line 70
ORA-01403: no data found
ORA-04088: error during execution

Error in firing ADS Trigger ADS_PO_REQUISITION_LINES_TRG1

Steps to Reproduce

1. Go to iProcurement responsibility > Create a new Contractor Request for Rate Based Temp Labor > Continue to next form

2. Give preferred Supplier, Supplier Site, Rate, Amount, Expense Amount and hit 'Add To Card'

3. Error appears

Impact of Error

1. Unable to proceed for requisition creation

2. Iprocurement does not display ASL and existing GBPA / BPA does not gets applied to Requisition

Resolution

1. The Trigger ADS_PO_REQUISITION_LINES_TRG1 is for Oracle ADS related environments only. Disable this trigger by the following commands on SQL Prompt:

alter trigger ADS_PO_REQUISITION_LINES_TRG1 disable;

2. Retest the issue and the error will not appear now.

Environment

• Oracle EBS R12.1.3+

References

MOS Note ID 1395509.1