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 JUNE 14, 2017

Applies to:

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

Symptoms

ISSUE:

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.

REPLICATION STEPS:

     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.

ACTUAL RESULT:

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.

EXPECTED BEHAVIOR:

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

 

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