Package CSM_HTML5_PKG Invalid After Applying CSM Patches To Fix The MFS Deferred Transactions Summary Page
(Doc ID 3060124.1)
Last updated on NOVEMBER 21, 2024
Applies to:
Oracle Mobile Field Service - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
After applying Patch.23075064:R12.CSM.C and Patch.34268997:R12.CSM.C to fix the Deferred Transactions Summary Page in Mobile Field Service, the package CSM_HTML5_PKG becomes invalid. The errors below are seen in the worker logs.
Errors
CSM_HTML5_PKG PACKAGE BODY APPS
SQL> show error;
Errors for PACKAGE BODY CSM_HTML5_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
10/11 PLS-00323: subprogram or cursor 'QUERY_VALIDATE_USER' is
declared in a package specification and must be defined in the
package body
104/10 PLS-00323: subprogram or cursor 'GET_APP_UPG_INFO' is declared
in a package specification and must be defined in the package
body
1991/3 PL/SQL: SQL Statement ignored
1991/41 PL/SQL: ORA-00904: "OWNER_FLAG": invalid identifier
2453/5 PL/SQL: SQL Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
2453/43 PL/SQL: ORA-00904: "OWNER_FLAG": invalid identifier
5799/2 PL/SQL: SQL Statement ignored
5799/9 PL/SQL: ORA-00942: table or view does not exist
5810/2 PL/SQL: SQL Statement ignored
5810/14 PL/SQL: ORA-00942: table or view does not exist
SQL>
CSM_HTML5_PKG PACKAGE BODY APPS
SQL> show error;
Errors for PACKAGE BODY CSM_HTML5_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
10/11 PLS-00323: subprogram or cursor 'QUERY_VALIDATE_USER' is
declared in a package specification and must be defined in the
package body
104/10 PLS-00323: subprogram or cursor 'GET_APP_UPG_INFO' is declared
in a package specification and must be defined in the package
body
1991/3 PL/SQL: SQL Statement ignored
1991/41 PL/SQL: ORA-00904: "OWNER_FLAG": invalid identifier
2453/5 PL/SQL: SQL Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
2453/43 PL/SQL: ORA-00904: "OWNER_FLAG": invalid identifier
5799/2 PL/SQL: SQL Statement ignored
5799/9 PL/SQL: ORA-00942: table or view does not exist
5810/2 PL/SQL: SQL Statement ignored
5810/14 PL/SQL: ORA-00942: table or view does not exist
SQL>
Steps
Apply <Patch.23075064:R12.CSM.C> and <Patch.34268997:R12.CSM.C>
Recompile all objects
The errors above are displayed in the logs.
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 |
| References |