EBS Troubleshooting

OATM Migration Not Completed 100% Errors With: Io exception: invalid arguments in call

  OATM Migration Not Completed 100% Errors With: Io exception: invalid arguments in call The issue can be reproduced at will with the following steps: 1. Run the OATM migration.…

Read More

Running OATM Migration Utility Fails With “sh: syntax error at line 1: `(‘ unexpected “

   Running OATM Migration Utility Fails With “sh: syntax error at line 1: `(‘ unexpected “  SYMPTOMS When attempting to run OATM migration utility to Generate Migration Commands options, by…

Read More

XML-20201: (Fatal Error) Expected name instead of .

Error : ——- Output post processor failed with below error processing report output Caused by: org.xml.sax.SAXParseException: <Line 17018, Column 25>: XML-20201: (Fatal Error) Expected name instead of  . Concurrent Log file…

Read More

Error while running autoconfig in DB Tier

                                        Error while running autoconfig in DB Tier Error: UnsatisfiedLinkError exception…

Read More

REP-56055 exceeded max connections allowed Oracle Reports Erro

ERROR: REP-56055 exceeded max connections allowed Oracle Reports Error SOLUTION: 1. Find the file $DOMAIN_HOME/reports/conf/repservername.confwhere $DOMAIN_HOME is your applications (not infrastructure) home, and repservername is your reports server name, i.e. rep_markr. 2. Find the line <connection maxConnect=”20″ idleTimeOut=”15″> 3. Change the maxConnect value to something like “100” 4. Restart your reports server, i.e. nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS

Read More

OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress?

               OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress? The Oracle Applications Tablespace Model was another long awaited feature that…

Read More

Manual Method to generate Output files(PDF,EXCEL,TXT,HTML) Using BI-Publisher Desktop in EBS When OPP fails or not able to generate Out for some Concurrent Programs.

Manual Method to generate Output files(PDF,EXCEL,TXT,HTML) Using BI-Publisher Desktop in EBS When OPP fails or not able to generate Out for some Concurrent Programs. 1)      Download the Oracle BI Publisher…

Read More

Find whether user is active or Inactive in EBS

Query to Find whether user is active or Inactive in EBS SQL : SELECT ‘Active’, valid.*  FROM fnd_user valid WHERE valid.user_id IN  (SELECT user_id FROM fnd_user WHERE NVL (end_date, SYSDATE) >= SYSDATE) UNION…

Read More

Error Oracle – 20001

Error Oracle – 20001 When trying  to assign responsibility to a user, the following error occurs. ERROR Error Oracle – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE(USERNAME=AKUMAE) (ROLENAME=FND_RESP|INV|XXFM_ROUTIN_VIEW|STANDARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT…

Read More

Patch Wizard Configuration and Patch Analysis without accessing the Internet

Patch Wizard Configuration and Patch Analysis without accessing the Internet (Without Providing Metalink Credentials) in EBS R12 1.     We can run patch wizard without accessing internet connection by downloading the…

Read More