My Oracle Support Banner

Mismatch Between Header Amount and Detail Amount in EBS Accounts Payable for Consignment Invoices (Doc ID 1612752.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Retail Invoice Matching - Version to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


In Oracle Retail Invoice Matching (ReIM) , consignment items posting is failing in E-Business Suite (EBS) due to an additional VCT line, different from zero, that is added to the invoice amount and not subtracted.

Steps to Reproduce:

  1. Log in to Retail Merchandising System (RMS) application.
  2. Create a consignment item.  Perform a sales transaction for the consignment item in RMS.
  3. Run saexprms (Sales Audit Export to RMS) batch to get POSU file.
  4. Upload POSU file (with included consignment item).   Check for TRAN_DATA posting.
  5. Generate a purchase order (PO) and verify entries in INVC_HEAD and INVC_DETAIL tables.
  6. Run EDIDLINV (EDI Invoice Download) batch to download the invoice.
  7. Run EDIUpload Batch to upload the invoice in ReIM.
  8. Verify that the invoice is created successfully in 'Matched' status.
  9. Run Financial Posting batch to post the invoice.
  10. Notice that consignment items posting is failing in EBS because an additional VCT line that is different from zero is added to the invoice amount.




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.