My Oracle Support Banner

EPC: PC_POADJUST Process Is Creating CRV Rows That Do Not Take Into Account the VIN Amount From Accounts Payable When More Than One Voucher Is Paid Against One PO (Doc ID 2341977.1)

Last updated on JANUARY 29, 2021

Applies to:

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

Symptoms

PC_POADJUST App Engine is creating PO commitment reversal rows (CRV analysis type) which do not take into account the VIN (VAT non recoverable) amount from Accounts Payable when more than one voucher is paid against one PO.


Steps to reproduce the issue:
1. Create new PC project and add 4 activities.
2. Create ePro requisition: quantity 5 EA and price of 100.
3. From distribution icon, drill down VAT schedule icon. Expand all and set Use Type and VAT code and Transaction type. Click Adjust Affected VAT Defaults then Return to Schedule Page.
4. Drill down on the Distribution icon. Update Distribution GL Unit, Account, PC BU, Project & Activity created above and Save.
5. Go to the details tab. Click on the VAT icon. Expand all and note the recovery amount is calculated - 39.00.
6. Return to the Requisition main page and save. Click budget check. Budget status should go to valid.
7. Run PC_PO_TO_PC.
8. Add a new PO copied from requisition.
9. Click the Sched Use/Sales Tax icon. Set the tax ability to exempt – there’s not sales & use tax. Click OK.
10. Click on the VAT override icon. Update Use Type and VAT code. Click Adjust Affected VAT Defaults button. Return to Schedules page.
11. Go to the Matching page for the PO. Set the match action to No Match and click Ok.
12. Turn off receiving on the PO Receiving tab. Click the Calculate button. Save the PO.
13. Click the Calculate button and confirm tax is calculated. Save. Budget check the PO, then dispatch.
14. Run PC_PO_TO_PC and PC_POADJUST for RRV creation.
15. Create 1st voucher by copying the PO. Enter a VAT amount of 13.00 (13%). Reduce qty to 1. Update the invoice total and click calculate to confirm the difference is zero. Click on the VAT Summary link. Recovery and non recoverable amounts are present. Go back to Invoice and save.
16. Create the 2nd voucher by copying the PO. Reduce qty to 2. Enter a VAT amount of 26.00 (13%). Update the invoice total and click calculate to confirm the difference is zero.
17. Click on the VAT Summary link. Recovery and non recoverable amounts are present. Go back to Invoice and save.
18. Budget check and post 2nd voucher.
19. Run PC_AP_TO_PC and PC_POADJUST for CRV creation.
20. Rerun PC_POADJUST to validate the CRV was not adjusted.
21. Create a 3rd voucher on the same PO/Project to see how the CRV row would update the PROJ_RESOURCE table.
22. Click on the VAT summary link to view the Non Recoverable tax.
23. Budget check and post voucher.
24. Run PC_AP_TO_PC and PC_POADJUST to update CRV.
25. Newly created CRV amount is excluding VIN amounts.
26. Re run PC_POADJUST to see if this would update the CRV amount but the CRV amount remained unchanged.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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