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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.