ORACLE EBS PRO(for Oracle EBS Professionals)
A Forum for Oracle E-business suite, Fusion professionals. It is an effort to make my blog a Knowledge repository and Solution Center which provides unique technical and functional solutions for EBS professionals.
Thursday, July 16, 2020
EAM SQL Statement to fetch the Short Term attached text for a particular EAM Work Order
Sunday, June 22, 2014
SQL Statement to fetch AME Rules based on a condition across different transaction types
---------------------------------------------------------------------
--SQL Statement to get AME Rules based on a condition across transaction types
-- Parameter:P_AME_CONDITION -- Input condition name(partial-match works)
---------------------------------------------------------------------
Cloned date of Oracle application and Version
Select statement to derive all the POs, Reqs delegated by user/s with WF Admin privileges in Oracle EBS
Saturday, May 24, 2014
How to fetch Oracle AME Rule details based on Condition for across transaction types(SQL QUERY)
-------------------------------------------------------------------------
--SQL Statement to get AME Rules based on a condition across transaction types
-- Parameter:P_AME_CONDITION -- Input condition name(partial-match works)
-------------------------------------------------------------------------
How to remove Scientific Notation for a numeric value in Toad for Oracle
View/Toad Options/Data Grids/Data
Uncheck "Display large numbers in Scientific Notation" checkbox as mentioned below:-