R12.2 Jl8469071b.sql Running For 27 Hours During Upgrade
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Financials for the Americas - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Latin Am. Glob. (General)
Performance issue running the upgrade.
Expect to be able to finish the upgrade.
The issue can be reproduced at will with the following steps:
1. jl8469071b.sql is running for 27 hours during R12.2 Upgrade.
You are in the process of upgrading 220.127.116.11 system to R12.2 and currently 12.2.0 driver is running.
In that, jl8469071b.sql is running for more than 27 hours and its simply stuck on below mentioned update.
You set the parameter, for the SLA pre-upgrade program, to pick only 6 months data; However, you see the 2000 year records are being processed.
Details : - jl8469071b.sql
Status Flags: ACTIVE DEDICATED USER
Tran Active : 000000234EEB1FB0
Login Time : Wed 12:46:29
Last Call : Wed 12:46:29 - 1562.7 min
Lock/ Latch : NONE/ NONE
Latch Spin : NONE
Current SQL statement:
UPDATE XLA_AE_HEADERS XLAH SET XLAH.CREATED_BY = 2, XLAH.LAST_UP
DATED_BY = 2 WHERE (XLAH.APPLICATION_ID, XLAH.ENTITY_ID) IN (SEL
ECT /*+ ROWID(xte) */ XTE.APPLICATION_ID, XTE.ENTITY_ID FROM XLA
_TRANSACTION_ENTITIES XTE WHERE XTE.ENTITY_CODE = 'JL_BR_AR_COLL
_DOC_OCCS' AND XTE.ROWID BETWEEN :B2 AND :B1 ) AND XLAH.CREATED_
BY = -2005 AND XLAH.LAST_UPDATED_BY = -2005
Please skip the jobs for the problematic sql files from these 4 SQLs.
Once the UAT upgrade is finished, you can manually execute the latest file versions of the skipped files.
jl8469071a.sql patch/115/sql 120.3.12020000.2
jl8469071b.sql patch/115/sql 120.2.12020000.2
jl8469071c.sql patch/115/sql 120.2.12020000.2
jl8469071d.sql patch/115/sql 120.2
The latest files have been uploaded to SR.
Now another SQL armc120recpl.sql which is running for long time which is inserting records into XLA_AE_LINES.
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