Error : ORA-04062: Signature of package APPS.JA_SH_GUI_UTILS has been changed error on completing AR invoice (Doc ID 2740864.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Reported Issue
-----------------
On entering AR invoice for Taiwan country an error is observed when trying to complete it. 
This is observed only on R12.2 and above releases. 

Error
-----
ORA-04062: Signature of package APPS.JA_SH_GUI_UTILS has been changed

Error
------
(On trying to recompile the JA.pll , error as below is observed )

ERROR generating library "resource/JA.plx" from input file
/u01/app/fsb1/fs2/EBSapps/appl/au/12.0.0/resource/JA.pll

Results of library generation:
(from file /u01/app/fsb1/fs2/EBSapps/appl/au/12.0.0/resource/JA.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on ARXTWMAI_TW_UTILS:
PL/SQL ERROR 306 at line 118, column 24
wrong number or types of arguments in call to 'VAL_TRX_NUM'
PL/SQL ERROR 0 at line 118, column 7
Statement ignored
PL/SQL ERROR 306 at line 161, column 27
wrong number or types of arguments in call to 'VAL_TRX_NUM'
PL/SQL ERROR 0 at line 161, column 10
Statement ignored
PL/SQL ERROR 306 at line 323, column 19
wrong number or types of arguments in call to 'GET_SEQ_NAME'
PL/SQL ERROR 0 at line 323, column 5
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.


Steps to reproduce 
---------------------
The issue can be reproduced at will with the following steps:
1. Enter AR transactions for Taiwan country.
2. On completing, error is observed.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete transactions

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.