Patch 6678700 : 12.1.1 Upgrade Driver : Views IGS_TR_STEP_V and IGS_PE_PERSON_V hung on the create s
Hi Gail,Welcome to the new EBS Patching community.
This thread will address your issue on the hung views - Uploaded all the docs from the SR.
The definition of the view IGS_TR_STEP_V is incorrect.
The view text is incorrectly defined as:
SELECT trst.rowid, trst.tracking_id, trst.tracking_step_id,
trst.tracking_step_number, trst.description, trst.completion_dt,
trst.action_days, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id,
...
Correct it with the statements:
Setting events to create views without compilation ...
Done setting events to create views without compilation.
Start time for statement below is: Fri Jun 29 2012 12:15:32
This thread will address your issue on the hung views - Uploaded all the docs from the SR.
The definition of the view IGS_TR_STEP_V is incorrect.
The view text is incorrectly defined as:
SELECT trst.rowid, trst.tracking_id, trst.tracking_step_id,
trst.tracking_step_number, trst.description, trst.completion_dt,
trst.action_days, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id,
...
Correct it with the statements:
Setting events to create views without compilation ...
Done setting events to create views without compilation.
Start time for statement below is: Fri Jun 29 2012 12:15:32
Tagged:
0