EGL: 'Performing Data Conversion Concurrently' - Can the Update SQLs On Tables With Large Volume Of Data Be Run Manually (Doc ID 2262586.1)

Last updated on MAY 21, 2017

Applies to:

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

Goal

While performing the application upgrade to 9.2 in Change Assistant there's a step called "Performing Data Conversion Concurrently".

For this step, there are update SQLs on records that have larger volume of data like PS_JRNL_LN, PS_JRNL_HEADER, PS_LEDGER, PS_JRNL_CF_BAL_TBL which could take a lot of time depending on the data volume.

Can these update statements be tweaked by adding some hint to  run in database manually and corresponding steps in AE program be inactivated ?

Solution

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