E1: 43: Voucher Match Automation UBE for Automation Rule 02 (R4304020) is Not Matching By Receipt Number (DOC) and Receipt Line (NLIN) (Doc ID 2876293.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Symptoms

The client is attempting to Match a 4-line Invoice to a Purchase Order with 108 receipt lines from 27 Partial Receipt Documents based upon 4 specific combinations of Receipt Document Number  (DOC) and Receipt Line Number (NLIN) populated in the Voucher Transactions Batch Upload - Voucher Match Automation Tag File (F0411Z1T).

The Match is successful but the invoice lines are not matched to the receipt lines the client wants. See the example below:

Voucher Transactions Batch Upload - Voucher Match Automation Tag File (F0411Z1T) is populated as follows:

• Receipt Document Number 22061473, Receipt Line Number 3 to be matched to Order Line 1
• Receipt Document Number 22061474, Receipt Line Number 4 to be matched to Order Line 2
• Receipt Document Number 22061473, Receipt Line Number 3 to be matched to Order Line 3
• Receipt Document Number 22061474, Receipt Line Number 4 to be matched to Order Line 4

Voucher Match Automation UBE for Automation Rule 02 (R4304020) matches the lines to receipts and receipt lines as follows:

• Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 1
• Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 2
• Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 3
• Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 4

Steps to duplicate:

1. Create a 4-line Purchase Order with Quantity 35 on each line and a different item number on every line
2. Using a custom staging program insert VMA invoice data into a staging table and populate specific Receipt Document Numbers (F0411Z1T.DOC) and Receipt Document Line Numbers (F0411Z1T.NLIN) to match to the PO Receiver (F41021) table as follows:
   1. Receipt Document Number 22061473, Receipt Line Number 3 to be matched to Order Line 1
   2. Receipt Document Number 22061474, Receipt Line Number 4 to be matched to Order Line 2
   3. Receipt Document Number 22061473, Receipt Line Number 3 to be matched to Order Line 3
   4. Receipt Document Number 22061474, Receipt Line Number 4 to be matched to Order Line 4
3. When Voucher Match Automation Rule 2 Processor (R4304020) is run, it ignores the custom input data and matches the Invoice Lines to PO Lines and Receipt Lines as follows:
   1. Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 1
   2. Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 2
   3. Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 3
   4. Receipt Document Number 22061472, Receipt Line Number 2, was matched to Order Line 4

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.