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

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

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:

Error

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.

Cause

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