Scripts

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 …

General Ledger Interface Tables GL_BUDGET_INTERFACE GL_DAILY_RATES_INTERFACE GL_DRM_HIERARCHY_INTERFACE  GL_DRM_SEGVALUES_INTERFACE GL_IMP_COA_ERR_INTERFACE GL_IMP_COA_NORM_HIER_INTERFACE GL_IMP_COA_SEG_VAL_INTERFACE GL_IEA_INTERFACE GL_INTERFACE GL_INTERFACE_CONTROL GL_INTERFACE_HISTORY GL_REPORT_INTERFACE GL_XFR_INTERFACE   Account Payables (AP) Interface Tables AP_INTERFACE_CONTROLS AP_INTERFACE_REJECTIONS AP_INVOICE_INTERFACE AP_INVOICE_LINES_INTERFACE OIE_POL_RATES_INTERFACE   Account …

Query to find workflow services are up and running?

How to check online FND_USERS in Oracle EBS R12

QUERY TO FIND information of PRIMARY OR STANDBY DATABASE