My Oracle Support Banner

EGL.9.2.VAT Transaction Loader Process - FS_VATUPDFS - Shows Performance Issues When It is Run For Single Business Unit on MS SQL Server While Loading Data from Multiple Years (Doc ID 2749046.1)

Last updated on FEBRUARY 02, 2021

Applies to:

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

Symptoms

While testing the VAT Transaction Loader process for a single Business Unit, there is a major performance issue with step FS_VATUPDFS.Seq0-a.DJ100-A2. It has been on the same step now for approx 48+ hours.

The process seems to be stuck at :

update PS_VAT_XREFBI_TAO set VAT_DCMNT_ID = @0 , LINE_NBR = ( select COUNT ( * ) from PS_VAT_XREFBI_TAO B where PROCESS_INSTANCE = B . PROCESS_INSTANCE and PS_VAT_XREFBI_TAO . BUSINESS_UNIT = B . BUSINESS_UNIT and PS_VAT_XREFBI_TAO . INVOICE = B . INVOICE and PS_VAT_XREFBI_TAO . LINE_SEQ_NUM > = B . LINE_SEQ_NUM ) where PROCESS_INSTANCE = @1 and BUSINESS_UNIT = @2 and INVOICE = @3 and VAT_DCMNT_ID = @4

When making a  count of records from the temporary table: SELECT count(*) FROM PS_VAT_XREFBI_TAO , there are  1,999,632 rows  for this process instance.

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
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.