EBS

EBS Weblogic Admin Console When Not Accessible After CPU Patching

By applying recent CPU patches on Oracle E-Business suite R12.2, many customers faced issues while accessing weblogic admin console from browser. This security enhancement started with the April 2019 CPU…

Read More

adcfgclone issue – ORA-28040: No matching authentication protocol

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 More

.apachectl issue after cloning

Error: 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 More

Unlink a FND_USER user account that is linked to an SSO Account

Unlink 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 More

Add node in R12.2

Steps 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 More

adcfgclone failed with no linkxlc error

adcfgclone.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 More

Cost Manager Concurrent request failed

Cost 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 More

Control Purchasing Period (India Local Purchasing)form was not opening.

In 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 More

How to Audit particular table in database?

To 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 More

Script to Update Preparer/ Requester in Requisitions using API

Get 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 More