ERROR: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database 12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database CloneContext_***.log Shows the Message: Exception occurred: java.sql.SQLException:…
Read MoreError: Autoconfig could not process the following files: Directory: $ORA_CONFIG_HOME/10.1.3/Apache/Apache/bin .apachectl BINCPY .apachectl BINCPY AutoConfig is exiting with status 2 Solution: Change owner for apachectl in below mentioned locations, cd…
Read MoreUnlink a FND_USER user account in Oracle EBusiness Suite that is linked to an SSO Account as follows, $ cd $FND_TOP/patch/115/sql/ $ ls -ltr fndssouu.sql $ sqlplus apps/apps_password @fndssouu.sql ROCHERK
Read MoreSteps to add second node to an Application Tier in R12.2. 1. Start the admin server in the run file system of the applications first node and execute txkManageDBConnectionPool.pl script…
Read Moreadcfgclone.pl failed in the application tier with no linkxlc error as follows, no linkxlC in BASE_PATH/apps/apps_st/comn/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oracle/bin /usr/bin/X11 /sbin . Solution: Check if linkxlC is installed…
Read MoreCost Manager concurrent request failed with the following errors, APP-FND-01564: ORACLE error 60 in cmlacm() Cause: cmlacm() failed due to ORA-00060: deadlock detected while waiting for resource Solution: – Adding…
Read MoreIn EBS R12.1.3 the “Control Purchasing Period” was not opening for users and the following error was noticed, oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.InvalidObjAccessException: JBO-25036: An…
Read MoreTo set audit: AUDIT [option] [BY user|SESSION|ACCESS] [WHENEVER {NOT} SUCCESSFUL] For example: SQL > audit select on dba_users by access whenever not successful; Audit Succeeded. How to check what object…
Read MoreGet data to be modified from customer and load it into a staging table. Use this table in the below script to update Preparer/ Requester for PO Requisitions. DECLARE l_msg_data…
Read MoreSELECT papf.employee_number employee_number , aps.vendor_name payee_name , ieba.bank_account_num bank_account_number ,…
Read More