Yearly Archives: 2021

ORACLE EBS 12.1.3 JDBC CONNECTION LEAK ISSUE

Issue: This homepage feature got a new bug with 12.1.3. This bug only affects EBS 12.1.2 and 12.1.3 customers who have OAMainMenuRESTHandler.class version 120.0.12010000.18. $ strings -a $JAVA_TOP/oracle/apps/fnd/framework/webui/rest/OAMainMenuRESTHandler.class|grep Header [$Header:…

Read More

Missing Archive log error in Golden gate integrated capture.

Scenario: There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate. Error : ERROR OGG-00868 Error code 1291,…

Read More

DB Node Crashes after upgrading to 19c

Scenario: DB node Crashes after upgrading from 12.0 to 19c. Error: 2021-02-04T12:00:15.450521+00:00 Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc: ORA-00600: internal error code, arguments: [3732], [33], [2], [], [], [], [], [], [],…

Read More

12.2 E-Business Suite FS_CLONE / ADPRECLONE.PL Fails With Error ‘CLONE-20435 Some of the Oracle Homes are excluded during copy operation’

ERROR: SEVERE : Sep 8, 2021 16:51:36 – ERROR – CLONE-20435 Some of the Oracle Homes are excluded during copy operation. SEVERE : Sep 8, 2021 16:51:36 – CAUSE –…

Read More

Tally Integration

Tally Data Integration & Data Migration Tally Integration : Comprehensive and medium-scale organizations use different applications to maintain their business and one of the important areas involved in these applications…

Read More

Configuring Physical Standby Database Using Data Guard

Configuring Physical Standby Database Using Data Guard Primary Database - Dhee Standby Database - Dheedr STEP 1: Check the Primary DB is in archive log mode or not.If it is…

Read More

AP Invoice To GL Link Query with additional attribute values

This query to Trace an AP Invoice to the GL. There is an Invoice in AP which is correctly Validated, Accounted, Approved etc. This will useful To find the GL…

Read More

AP Bank details query with additional attributes values

The supplier (or External) bank account information are stored in the table called ce_bank_accounts. The bank and bank branches information are stored in CE_BANK_BRANCHES_V This script used to get bank…

Read More

Workflow Script Deassign user from role

Oracle Workflow delivers a complete workflow management system that supports business process based integration. Its technology enables modeling, automation, and continuous improvement of business processes, routing information of any type…

Read More

GL Flexi ield Query with additional details

GL module used to maintain credit and Debit details in oracle. Gl code combinations are used maintain details of company with respect to legal entity level. This script used to…

Read More