In Supplier Screen The Payment Terms LOV Displays Supplier Payment Terms Using TERMS_CODE Instead of TERMS from TERMS_HEAD_TL Table

(Doc ID 2308113.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

Supplier Payment Terms is using TERMS_CODE instead of TERMS. In Supplier Site screen, Payment Terms is expected to show TERMS_CODE and TERMS_DESC.

However, when saving to SUPS table, it should be the TERMS not the TERMS_CODE.

Since terms is being used, down the line it is causing integrity constraint (sup_tmh_fk) violated error when saving a new supplier.


Steps to Reproduce
-----------------------------

  1. Ensure that TERMS, TERMS_CODE and TERMS_DESC of TERMS_HEAD_TL table have different values, i.e., TERMS <> TERMS_CODE.
  2. Login to RMS then select Tasks > Foundation  Data > Suppliers and Partner> Manage Suppliers.
  3. Search a supplier site. Observe that search results shows terms. Click on edit.
  4. When the supplier site maintenance screen opens up, observe that terms is shown instead of terms_code.
  5. Go to Payment Terms LOV.
  6. Select one from the drop down list.
  7. Now, it shows correctly as terms_code and terms_desc.
  8. Save.
  9. Observe the error - ora-02291: integrity constraint (sup_tmh_fk) violated when saving a new supplier.

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