OPM Query to identify In Transit Transactions
OPM Query to identify In Transit Transactions Introduction: This blog shares the query to identify In Transit Transactions. Cause of the Issue: This blog shares the query to identify In…
Read MoreOPM Query to identify DCOGS Transactions
Introduction: This blog shares the query to identify DCOGS Transactions. Cause of the Issue: This blog shares the query to identify DCOGS Transactions. This would help in simplifying OPM Period…
Read MoreScripts related to TEMP TABLESPACE
Posted by Abishek Kathiresan Introduction: Hi All, Here we will discuss Scripts related to TEMP TABLESPACE. To check instance-wise total allocated, total used TEMP for both rac and non-rac set…
Read MoreOracle SQL to get the Menu and Submenu list against a responsibility
SELECT FRV.responsibility_name, fm.menu_name, FMEV.ENTRY_SEQUENCE, FMEV.PROMPT, FMEV.DESCRIPTION, SUB_MENU_FMEV.USER_MENU_NAME SUB_MENU_NAME, SUB_MENU_FMEV.DESCRIPTION SUB_MENU_DESCRIPTION, FFFT.USER_FUNCTION_NAME, FMEV.GRANT_FLAG FROM apps.FND_MENU_ENTRIES_VL FMEV, apps.FND_MENUS_TL SUB_MENU_FMEV, APPS.FND_FORM_FUNCTIONS_TL FFFT, …
Read More