My Oracle Support Banner

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 AUGUST 05, 2020

Applies to:

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


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 Recreate:

  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 Retail Merchandising System (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.




To view full details, 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 a vibrant support community of peers and Oracle experts.