EAP9.2: VAT_DISTRIB_STATUS Not Getting Updated To D While Running Transaction Loader For Un-Posted Voucher Entry When Corresponding Voucher Line Is Deleted

(Doc ID 2353635.1)

Last updated on JANUARY 26, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

VAT_DISTRIB_STATUS not getting updated to D while running Transaction Loader for un-posted Voucher entry when corresponding Voucher line is deleted.

Steps
1. Navigate to Accounts Payable> Voucher > Add/Update > Regular Entry
Add a new Voucher. BU: GBR01.
Save the page. Voucher id created.
2. Budget check the voucher.
3. Post the voucher.
4. Run VAT Transaction loader process.
5. Un-post the voucher. Post Status = “Unposted”
6. Open Voucher and delete voucher line number 2 and save the voucher.
7. Budget check the voucher again.
8. Post the voucher again. Post Status = “Posted”
9. Run VAT transaction loader process.
Vat distrib status for voucher line number 2 in unpost seq 1 remains as ‘R’, also no data is inserted into PS_VAT_XREF_VCHR for voucher line number 2 , unpost seq 1

Actual Results
VAT_DISTRIB_STATUS is not getting updated to D on running transaction loader process FS_VATUPDFS for un-posted voucher entry when corresponding voucher line is deleted.

Expected Results
VAT_DISTRIB_STATUS should be updated to D while running transaction loader process FS_VATUPDFS for un-posted voucher entry when corresponding voucher line is deleted and data should be inserted into PS_VAT_XREF_VCHR for voucher line number 2, unpost seq 1.

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps containing the complete configuration and the replication steps necessary to reproduce the issue.

Cause

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 hundreds of Community platforms