Excuse me for trying to brief the Issue in such manner which may not be apt. or appear stupid to many Experts. But I am newbie to Oracle Apps !
After registering the EBS R12.1 Vision, DB version 220.127.116.11.0 with OID 18.104.22.168 successfully with $FND_TOP/bin/txkrun.pl Before that Registered EBS Instance with OID
as part of Integrating EBS R12 with OAM-OID 11g according to (ID :1309013.1)
Once i updated these profile options i.e "Applications SSO Type" profile option to “SSWA w/SSO” and“Applications SSO Login Types” profile option to BOTH , AND
Applications SSO Auto Link User profile option to “Enabled” And “Applications SSO Enable OID Identity Add Event” profile option to “Enabled”.
And than it requyire the EBS tier to be restarted Once i restarted it Than the following Issues Occured.
1. As i specified the provisiontype value to 1 which means that the user that's got created in OID should be populated in fnd_user table in EBS But this is not happening
as the User that i 've created with the ODSM is not propagated to fnd_user table when i verified it with the following query
select USER_NAME, CREATION_DATE from fnd_user where creation_date > (SYSDATE - 1);
The Output : no rows selected
2. The EBS Login page become inaccessible that is the Login Page goes blank
3. opmn managed are running fine But when i checked the status of adcmctl got the following error,
You are running adcmctl.sh version 120.17.12010000.5
ORACLE error 6502 in afpodbinit
Cause: afpodbinit failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.FND_GLOBAL", line 1939
ORA-06512: at "APPS.FND_GLOBAL", line 2309
ORA-06512: at "APPS.FND_GLOBAL", line 2447
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; and was executed from the file &ERRFILE.
Internal Concurrent Manager status could not be determined.
adcmctl.sh: exiting with status 0
adopmnctl.sh status give the following output.
You are running adopmnctl.sh version 120.6.12010000.5
Checking status of OPMN managed processes...
Processes in Instance: VIS_ebs.ebs.oracle.com
ias-component | process-type | pid | status
OC4JGroup:default_group | OC4J:oafm | 100242 | Alive
OC4JGroup:default_group | OC4J:forms | 100173 | Alive
OC4JGroup:default_group | OC4J:oacore | 100021 | Alive
HTTP_Server | HTTP_Server | 99964 | Alive
4. when i run the autoconfig it got Failed with these error
AutoConfig is exiting with status 1
also the following i observed in the adconfig log file.
AutoConfig could not successfully execute the following scripts:
Directory: /oracle/VIS/apps/tech_st/10.1.3/perl/bin/perl -I /oracle/VIS/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /oracle/VIS/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /oracle/VIS/apps/apps_st/appl/au/12.0.0/perl -I /oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /oracle/VIS/inst/apps/VIS_ebs/admin/scripts/adexecsql.pl sqlfile=/oracle/VIS/inst/apps/VIS_ebs/admin/install
Could you please suggest whats could be Issue here. Also posting the contents of /etc/hosts file Although these is no Issue with the Apps & DB listener.
[root@l]# cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
192.168.12.6 iam.oracle.com iam (WHICH IS THE EBS node)
192.168.12.13 OAM.oracle.com OAM (which is the OAM node)
Thanks & Regards