Skip to main content

Posts

Showing posts from October, 2014

R12 Check Writer XML process failed.

Issue: When attempting to run the Check Writer XML process, the following error occurs. stat_low = 86 stat_high = 0 emsg:was terminated by signal 6 /test/appltest/apps/apps_ st/appl/pay/12.0.0/bin/PYUGEN Program exited with status -1 Cause: This issue is generally encountered after cloning. Main reason for this is wrong value of the DBC_FILE parameter in View "PAY_ACTION_PARAMETERS". Use the following SQL Query to find the Value: select length(parameter_value), Length(trim(parameter_value)), parameter_value from pay_action_parameters where parameter_name = 'DBC_FILE'; Solution: 1.  Run the following query to confirm the extra space(s) in the DBC file parameter value Query:   select length(parameter_value), Length(trim(parameter_value)), parameter_value from pay_action_parameters where parameter_name = 'DBC_FILE'; 2. Modify the DBC file parameter value in PAY_ACTION_PARAMETERS. Query:   UPDATE "APPS...

Oracle R12 Forms Not Opening In Browser

Issue: When trying to open forms in R12, following error is coming Solution: 1. Go to Start ==> Control Panel  2. Click on Java Control Panel and select tab "security" and make Security Level "Medium" 3. Also, add URL in the Exception Site List. For e.g http://xyz.erp.com:8000 and apply it.

OID: unable to locate message file: ldap.msb

Issue: [oidtest@oidtest1 bin]$ ldapadd -h oidtest1 -p 3060 -D "cn=orcladmin" -w "Welcome123" unable to locate message file: ldap<language>.msb Cause: Basic cause of this error is, ORACLE_HOME is not set properly. Solution: To use most Oracle Internet Directory command-line utilities and Database client utilities like sqlplus,  you must set the following environmental variables: 1. ORACLE_HOME:  The location of non-writable files in your Oracle Identity Management installation. ORACLE_HOME=<Path of Middleware>/Oracle_IDM1 2. ORACLE_INSTANCE:  The location of writable files in your Oracle Identity Management installation. ORACLE_HOME=<Path of Middleware>/Oracle_IDM1/asinst_1 3. TNS_ADMIN:   The directory where the database connect string is defined in the tnsnames.ora file. By default it is the $ORACLE_INSTANCE/config directory. The database connect alias as defined in tnsnames.ora is OIDDB by default. 4. PATH: It should conta...