Last updated on AUGUST 18, 2015
Applies to:Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.
This issue has multiple symptoms.
Symptom 1: Import Standard Purchase Order Program fails with Vendor Site that has Retainage Rate value defined, This is happening for a non Complex Purchase Orders.
Symptom 2: Autocreate creates the standard PO lines with incorrect retainage rate. This later causes AP invoice matching errors
For case 1, the table PO_INTERFACE_ERRORS shows the error message :
Retainage Rate is not allowed, as Retainage is not enabled for this style (STYLE_ID = 1)
For case 2, When matching the invoice in AP to the invoice with retainage rate, user gets:
APP-SQLAP-10000: ORA-01400: cannot insert NULL into
("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID") occured in
with parameters (Match Mode = STD-PS, Invoice ID = 4391921,
Invoice Line Number = , Shipment ID = 5844234, Rcv
Transaction ID = 17179088, Match amount = 1584, Match
quantity = 12, PO UOM = Each, Frieght Amount = , Frieght
Description = , Misc Amount = , Misc Description = )
while performing the following operation:
Create Retainage Distributions
Case 1, the issue can be reproduced at will with the following steps:
1. Populate data of Standard Purchase Order into Purchase Order Interface tables (Ex. PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, etc..)
2. Submit Import Standard Purchase Order
Program failed to create the Standard PO due to below error
"Retainage Rate is not allowed, as Retainage is not enabled for this style (STYLE_ID = 1)".
Case 2, try to match against PO that has Retainage Rate
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms