Import Standard Purchase Order Program fails With "Retainage Rate Is Not Allowed, As Retainage Is Not Enabled For This Style (STYLE_ID = 1)" (Doc ID 1948205.1)

Last updated on AUGUST 18, 2015

Applies to:

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

Symptoms

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  

Error:

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
AP_MATCHING_PKG.base_credit_rcv_match<-APXRMTCH
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




Replication Steps:
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

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