When switching Responsibility, forms gave error:
Oracle error -6550: ORA-06550 : line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'INIT'
ORA-06550 : line 1, column 7:
PL/SQL: Statement ignored
has been detected in fnd_global.initialize[fnd_init_sql].
I checked profile 'Initialization SQL Statement - Custom' as suggested by Doc ID 577753.1 and did see anything on Site level. But when I ran below code, I sew one at Application level (by ID 10002).
SQL> select PROFILE_OPTION_ID, LEVEL_ID, LEVEL_VALUE, PROFILE_OPTION_VALUE
from apps.fnd_profile_option_values
where profile_option_id = (
select profile_option_id from apps.fnd_profile_options
where profile_option_name = 'FND_INIT_SQL' );
PROFILE_OPTION_ID LEVEL_ID LEVEL_VALUE PROFILE_OPTION_VALUE
--------------------------- --------------- -------------------- --------------------------------
3157 10002 20004 begin my_global.init; end;
I ran a script in check R12 profile options to got the custom Application name. After I changed profile 'Initialization SQL Statement - Custom' on that Application level to null, which deletes that row from table apps.fnd_profile_option_values, the Oracle errors on forms were fixed.
No comments:
Post a Comment