EAP: Voucher Approval using AWE (1) Inserts blank row into VCHR_AF_XREF and (2) Issue running 2 Request Voucher Batches at the same time (Doc ID 1603434.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

Voucher Approval using AWE has 2 issues:

ISSUE 1
When running 2 different Voucher Approval Framework (VCHR_APPRV_AF) processes at the same time, able to submit a Voucher for approval through the Approval Framework - Vouchers page even though this voucher is still being processed by Voucher Approval Framework (VCHR_APPRV_AF). As a result, a row is inserted into the PS_VCHR_AF_XREF table with a blank BUSINESS_UNIT and VOUCHER_ID, which is incorrect. If this same Voucher is displayed through the Regular Entry page, an error occurs.

ERROR
This voucher is currently in use by a Payables batch process. (7030,236).

Both the Approval Framework - Vouchers page and Regular Entry page should behave the same way. Should not be able to submit the voucher for approval through the Approval Framework - Vouchers page since unable to submit it for approval through the Regular Entry page.

ISSUE 2
Problem when running 2 Request Voucher Batch / Voucher Approval Workflow (VCHR_APPRV_AF) processes at the same time.  One of the processes will sometimes abend at Step VCHR_APRV_AF.MAIN.Step03 with an error.

ERROR
Could not update the record for Thread id 83. (1081,1003) EOAW_CORE.ENGINE.Thread.OnExecute Name:Update PCPC:13028 Statement 193 Called from EOAW_CORE.ENGINE.Thread.OnExecute

STEPS -- ISSUE 1
1. For Business Unit = US003, Payables Options > Vouchering Options 1 page setup with Voucher Approval = Approval Framework
2. Navigate to Procurment Contracts > Add/Update Contracts
3. Create 900 Vouchers with Contract Process Option = Recurring Vouchers
Vendor ID = USA0000030
Maximum Amount = 9,000.00
Invoice Number = genuine_awe
AP Business Unit = US003
Gross Amount = 10.00
Merchandise Amount = 10.00
4. Navigate to Procurement Contracts > Create Contract Releases page Display the Control ID from Step 3
Internal = Daily
Every = 1
Times = 900
5. Click Populate
6. Release Template = 900
7. Click Stage
8. Click OK to message received
9. Click the Review Staged Releases hyperlink
10. Review Staged Releases page / Staged Contract Releases = 900
11. Run Voucher Build
Process Option = Process Vendor
Business Unit = US003
Vendor ID = USA0000030
Voucher Build Interfaces = Contracts
Contract Voucher Action = Build Voucher
12. Navigate to Accounts Payable > Vouchers > Approve > Approval Framework - Vouchers
13. Invoice Number = gen
14. Vouchers are created with Approval Status = Pending
15. Run 2 different Request Voucher Batch / Voucher Approval Workflow (VCHR_APPRV_AF)processes at the same time
16. 2nd process Run Status = Success already but 1st process is still Processing
17. While 1st process is still running, try to display a Voucher through the Regular Entry page
18. Display Voucher ID = 0000000862
19. Receive the message: This voucher is currently in use by a Payables batch process. (7030,236)
20. While 1st process is still running, try to display a Voucher through the Approval Framework - Vouchers page
21. Display Voucher ID = 0000000862
22. Able to display Voucher = 0000000862 successfully without receiving any errors / Approval Status = Pending
23. Click the Submit button
24. Voucher Approval Stage 1 is Pending since Voucher now submitted for Approval
25. Through SQL, check the VCHR_AF_XREF table for any rows were BUSINESS_UNIT is blank and VOUCHER_ID is blank
26. 1 row is displayed
27. When sorting by EOAWPARENT_THREAD, VOUCHER_ID = 0000000862 is not displaying even though EOAWPARENT_THREAD and VOUCHER_ID are displaying in sequential order
28. Where VOUCHER_ID = 0000000862 should be appearing, EOAWPARENT_THREAD = 971, which is appearing correctly in sequential order by EOAWPARENT_THREAD but the BUSINESS_UNIT and VOUCHER_ID are blank, which should not be occurring
29. When sorting by VOUCHER_ID, VOUCHER_ID = 0000000862 is displaying
30. However, notice that the EOAWPARENT_THREAD = 103 where as the EOAWPARENT_THREAD for the previous Voucher and next Voucher is 970 and 972, respectively.

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