My Oracle Support Banner

EAR 9.2: Record PS_VAT_SUMM_AR_WS Keeps Sometimes Leftover Data That Should Be Cleaned Up After Pending Group On VAT BU Is Saved (Doc ID 2276929.1)

Last updated on APRIL 11, 2019

Applies to:

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



When testing the entry of Pending Item Groups for a VAT enabled Business Unit, never the first Item in the Group gets populated in this Record, and even the second Items only get populated when a specific series of steps are taken in a precise order. Items with similar conditions created later on this Group are also not populated automatically.

This leads to suspect that maybe the data on Record PS_VAT_SUMM_AR_WS is only supposed to be temporary for some calculations, and that upon saving the Pending Item Group, the data should be deleted.


     1.- Log into the FSCM Online Application as a Payables User
     2.- Navigate to: Accounts Receivable > Pending Items > Online Items > Group Entry
     3.- Enter a brand new Pending Item Group for a VAT enabled Business Unit, such as GBR01
     4.- At the Group Control tab, set a Count of 2, a Control Amount of 2,225.00 GBP
     5.- At the Pending Item 1 tab, create one first Item for Customer ID GBR01, and Amount of 1,175.00 GBP
     6.- At the VAT Control Totals section, set VAT Transaction Amount to 1,000.00, and VAT Amount at 175.00
     7.- Save the changes
     8.- Query Record PS_VAT_SUMM_AR_WS, and confirm that it is empty
     9.- Click on the + sign, to add a second Item, again for Customer ID GBR01, and Amount of 1,050.00 GBP
     10.- At the VAT Control Totals section, set VAT Transaction Amount to 1,000.00, and VAT Amount at 50.00
     11.- Click on the VAT Summary link on this second Item
     12.- Continue by clicking on the VAT Lines icon available
     13.- Expand all sections, an in the VAT Details one, modify the VAT Code to UK2
     14.- Click on the Adjust Affected VAT Defaults button
     15.- Click on the Group Entry available link
     16.- At the VAT Summary Information page, click on the Group Entry available link
     17.- Save the changes
     18.- Query Record PS_VAT_SUMM_AR_WS once again, and confirm that this time the Table contains one row for the Group's second Item, but not the first one

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


Record PS_VAT_SUMM_AR_WS contains left over transaction data that should not be there, as this table is being used as a work/derived record to be used when performing VAT calculations when the User is accessing the VAT Summary page, but once gone from this page, this should be emptied.


Record PS_VAT_SUMM_AR_WS should only contain transaction data while the User is at the VAT Summary page (GROUP_ENTRY_VATS).


NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.





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

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