Compilation Error 'G_FLIP_ORDER' in CSXSRISR.fmx and CSXSRTSK.fmx After Applying a Service Patch
(Doc ID 2467801.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Teleservice - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
The following compilation errors appear after applying one of the latest Service Cumulative Patches (i.e. Patch 28431872:R12.CS.B - 12.1.3:BUG FIXES FOR CS:SEP'18).
Errors:
* For CSXSRISR.fmb:
Compiling WHEN-MOUSE-CLICK trigger on COST_R item in SCRSLT data block...
Compilation error on WHEN-MOUSE-CLICK trigger on COST_R item in SCRSLT data block:
PL/SQL ERROR 302 at line 4, column 24
component 'G_FLIP_ORDER' must be declared
PL/SQL ERROR 0 at line 4, column 3
Statement ignored
PL/SQL ERROR 302 at line 46, column 21
component 'G_FLIP_ORDER' must be declared
PL/SQL ERROR 0 at line 46, column 3
Statement ignored
PL/SQL ERROR 302 at line 52, column 21
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 52, column 3
Statement ignored
PL/SQL ERROR 302 at line 55, column 21
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 55, column 3
Statement ignored
Compiling WHEN-MOUSE-CLICK trigger on RESOURCE_PROMPT item in SCRSLT data block...
Compilation error on WHEN-MOUSE-CLICK trigger on RESOURCE_PROMPT item in SCRSLT data block:
PL/SQL ERROR 302 at line 4, column 24
component 'G_FLIP_ORDER' must be declared
PL/SQL ERROR 0 at line 4, column 3
Statement ignored
PL/SQL ERROR 302 at line 47, column 21
component 'G_FLIP_ORDER' must be declared
PL/SQL ERROR 0 at line 47, column 3
Statement ignored
PL/SQL ERROR 302 at line 52, column 20
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 52, column 2
Statement ignored
PL/SQL ERROR 302 at line 54, column 21
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 54, column 3
Statement ignored
[...]
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 54, column 1
Statement ignored
* For CSXSRTSK.fmb:
Compiling WHEN-MOUSE-CLICK trigger on COST_R item in SCRSLT data block...
Compilation error on WHEN-MOUSE-CLICK trigger on COST_R item in SCRSLT data block:
PL/SQL ERROR 302 at line 4, column 24
component 'G_FLIP_ORDER' must be declared
PL/SQL ERROR 0 at line 4, column 3
Statement ignored
PL/SQL ERROR 302 at line 46, column 21
component 'G_FLIP_ORDER' must be declared
PL/SQL ERROR 0 at line 46, column 3
Statement ignored
PL/SQL ERROR 302 at line 52, column 21
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 52, column 3
Statement ignored
PL/SQL ERROR 302 at line 55, column 21
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 55, column 3
Statement ignored
[...]
component 'SORT_RESULTS' must be declared
PL/SQL ERROR 0 at line 54, column 1
Statement ignored
Steps:
1. Download and apply a Service cumulative patch.
2. Run autopatch (adpatch) for the downloaded patch
=> Observe the above error in the Patch Log.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |