August 2017 Update to E-Business Suite Technology Codelevel Checker (ETCC) By: Steven Chan| Senior Director The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches …

Can Oracle Label Security be Used with EBS 12.2? By: Steven Chan | Senior Director Yes, Oracle Label Security (OLS) can be used with EBS 12.2.  It can also be used for earlier EBS releases …

What’s the E-Business Suite Roadmap for Java? By: Steven Chan | Senior Director Oracle E-Business Suite uses Java.  When discussing EBS’s use of Java, it is important to distinguish between server-side vs. client-side …

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