EeS: Payment Terms on XML Invoice is not coming from the Agreement configuration (Doc ID 2242751.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Symptoms

After loading an Invoice from a cXML file using SendMaster, the PYMNT_TERMS_CD field has an incorrect value on the VCHR_HDR_QV table.

The PYMNT_TERMS_CD value is coming from the table, EM_AGMT_PAY_TBL, instead of the PO even though under Payment Terms Options, Use Payment Terms = Purchase Order on the eSettlements > Supplier Information > Review Agreement Details > Supplier page.

STEPS
1. Navigate to eSettlements > Supplier Information > Review Agreement Details
2. Display the Buyer and Supplier which is specified on the Invoice in the cXML file
3. Access the Supplier page
4. Use Payment Terms From = Purchase Order
5. Check EM_AGMT_PAY_TBL for the Supplier and Buyer
6. PYMNT_TERMS_CD = 00
7. Create a PO with the same PO ID referenced in the cXML file
8. Change the Terms to 2D, which is different than what is stored in the table, EM_AGMT_PAY_TBL
9. Load the cXML file through SendMaster
10. Invoice is loaded into in Review Invoice page, with Build Status = Build Voucher
11. Through SQL, check the VCHR_HDR_QV table
12. PYMNT_TERMS_CD = 00 instead of 2D

Changes

Cause

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