My Oracle Support Banner

R12: Incorrect Reitainage Rate Defaulted on Stadard Purchase Orders (Doc ID 1394354.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
Form:POXBWVRP.FMB - AutoCreate Documents GUI


If the supplier from a Standard Purchase Order (PO), created from Non-Catalog Request using createdoc workflow or autocreate form, has set a value for Retainage Rate (%), this will default on the PO.
Because of this when trying to match the invoice with purchase order an error occurs:


APP-SQLAP-10000: ORA-01400: cannot insert NULL
Create Retainage Distribution

Value of retainage rate saved on lines level cannot be accessed for standard PO's even by PO Entry Form or Buyer Work Center (BWC).
Retainage rate as per designed needs to be set only for Complex PO's.

Steps to reproduce

1. Set supplier with Retainage Rate (%) in Key Payment Setups tab from supplier definition.
2. Create Non-Catalog Request with this supplier.
3. Save and approve Non-Catalog Request.
4. Create the PO using createdoc workflow or use autocreate form.
5. PO will have retainage_rate field populated in po_lines_all table with value defaulted from supplier definition.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.