ORA-06512: At "APPS.FND_LDAP_WRAPPER"
Sign in

ORA-06512: at "APPS.FND_LDAP_WRAPPER"

ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.FND_OID_PLUG", line 1137
ORA-06512: at line 1
ORA-06512: at "APPS.FND_LDAP_WRAPPER", line 1491
ORA-06512: at "APPS.FND_SSO_MANAGER", line 244
ORA-06512: at "APPS.FND_USER_PKG", line 2490
ORA-06512: at "APPS.FND_USER_PKG_WRP", line 76

--------------------------------------------------------------
FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-06503.

Solution and steps to troubleshoot above issues.

1. Check for the EBS Database and OID database alert logfile.

2. Check the oid log file on 10gAS (OID) node.

cd $ORACLE_HOME/ldap/log/

ls -altr oid*.log

3. On oid node check for the sport and port (ldap).

ps -ef | grep oid

(For example u got the port 13060 and 13130).

4. Check for the policies against thse from EBS application node to oid node.

Telnet (oid_node_ip> 13060.

5. Check for the oid db port, say if it is 1521.

6. Login to the EBS database node and check for the policies for this port from DB to OID node.

telnet <oid_node> 1521

telnet <oid_node> 13130

telnet <oid_node> 13060

 

(Note: In the above steps, it has been assumed the OPMN and OID db is on the same node. You can also monitor the db events on EBS node, you may notice DBMS_LDAP% , and this session would be running code containing get_realm_dn)

 

Thanks

Happy DBA'ing.

start_blog_img