Search This Blog

Thursday, February 18, 2021

The web services URL for XML Gateway it is returning a 404.

 
ISSUE:
the web services URL for XML Gateway it is returning a 404.  

STEP1: Set profile Applications SSO Login Types  (APPS_SSO_LOCAL_LOGIN) for ASADMIN user to 'Local'.

STEP2: Change the ASADMIN password from User Management as follows
a) Log in using sysadmin/<sysadmin_pw>
b) Choose responsibility 'User Management'
c) Find user ASADMIN
d) Reset Password (‘ASADMIN’)
e) Remove Active To date if set.
f) Apply

STEP3: Confirm the definition for ASADMIN user in $INST_TOP/ora/10.1.3/j2ee/oafm/application-deployments/oafm/data-sources.xml is defined correctly:
user="ASADMIN"
password="->ASADMIN"

STEP4: Change password for ASADMIN user in $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml to be !<New ASADMIN Password> (! in front is mandatory)
Mention: ! in front of password is mandatory and this sign means that password will be encrypted

STEP5: Shutdown and restart the OAFM container and re-test:
sh $ADMIN_SCRIPTS_HOME/adoafmctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adoafmctl.sh start

References: 
Verify that ASADMIN EBS User for ISG and XML Gateway JDBC Connections to the Database is Correctly Implemented. (Doc ID 1089197.1)
Cannot Start OXTA After Upgrade To R12.1.x (Doc ID 1087499.1)
OXTA Does Not Start after upgrading database to 12.x (Doc ID 2005459.1)


No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...