EAP: _NVS__AP_VOUCHER_ACCTG_DRILL Query Not Returning Correct Results (Doc ID 2251326.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Symptoms

The _NVS__AP_VOUCHER_ACCTG_DRILL Query is not returning the same results from the VCHR_ACCTG_LINE. There are two APA - Accounts Payable entries
missing. Unable to determine which are missing: ACCRUAL, PAYMENT, CANCEL, or CLOSURE

STEPS:
1. Add Voucher FU1 > Invoice Date 1-1-2017 > Accounting Date 11-17-2016
2. Post Voucher > Accounting Date 11-17-2016
3. Pay Voucher using Accounting Date 11-29-2016 > Post Payment
4. Cancel Payment with Void-Close Liability > Accounting Date 11-29-2016
5. Post Payment and Voucher
6. VCHR_ACCTG_LINE has 8 entries / 2 ea: ACCRUAL, CANCEL, CLOSURE, PAYMENT
7. Journal Generate > GL_DISTRIB_STATUS = D for all entries
8. Run _NVS__AP_VOUCHER_ACCTG_DRILL Query > Criteria: VOUCHER_ID = FU1
9. Query returns 6 entries...2 APA Accounts Payables entries missing...unable to determine which are missing: ACCRUAL, PAYMENT, CANCEL, or CLOSURE

Cause

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