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