My Oracle Support Banner

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 14, 2018

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

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