IN ORACLE MILIEU …

Problem Statement Error Messages: CSTPACIN.COST_INV_TXN: (70): ORA-20100: File o0086078.tmp creation for FND_FILE failed. You will find more information on the cause of the error in request logSolution In this case we need to check following 3 things 1) Check the UTL file parameter in DB side. Compare it with the APPLPTMP parameter on application side. [...]

Some time we come across the issue when trying to connect with database from the application side using apps as a user. This basically requires the listener to be up to make connection with database. We get error similar to Cannot login to sqlplus using following userid/passwd. sqlplus apps/apps@dbname. Gives error ERROR: ORA-12547: TNS:lost contact [...]