Best Practices For Migrating Oracle Database To Oracle’s Database Cloud Service By: Edgar Haren Principal Product Marketing Director Today, I’m pleased to have a guest blogger, Senior Principal Product Manager,  Brian Spendolini.  …

Check BI Publisher’s Health with BIP Analyzer for E-Business Suite By: Steven Chan| Senior Director In addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free …

Can Nologging Be Enabled for EBS 12.2? By: Steven Chan | Senior Director The nologging Oracle database feature is used to enhance performance in certain areas of Oracle E-Business Suite. For example, it …

Compiling Objects Manually Through SQL Commands First find the Invalid Objects in the Database by below given query. SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’; For a more detailed …

SELECT Count(*)  FROM   v$backup_async_io  WHERE  status = ‘IN PROGRESS’; 

This Query Calculate the Datafile Growth on a Yearly Basis

  SELECT   ood.organization_code Warehouse_code,   ood.organization_name Warehouse,   ood.operating_unit OU_ID,   hou.name OU_Name,   hle.name Legal_entity,   hle.set_of_books_id,   gsob.name SOB FROM   org_organization_definitions ood,   hr_operating_units hou,   hr_legal_entities hle,   gl_sets_of_books gsob WHERE …

Syntax: fnd_user_pkg.addresp(username => v_user_name ,resp_app => ‘SYSADMIN’ ,resp_key => ‘SYSTEM_ADMINISTRATOR’ ,security_group => ‘STANDARD’ ,description => ‘Auto Assignment’ ,start_date => SYSDATE – 10 ,end_date => SYSDATE + 1000);   Usage: BEGIN …

Step 1. Setup the profile value at user level with the following value Profile name: “Initialization SQL Statement – Custom” User: [%User Name from which Concurrent program Runs%] Profile value: …

ERROR Oracle EBS 12.2.4 application tier autoconfig fails with following error.