Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

AppsDBA Scripts

August 1, 2017 Find the Org and Organization mappings

AppsDBA ScriptsScripts

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,…

August 1, 2017 How to add System administrator responsibility from backend

APPS DBAAppsDBA ScriptsOracle APPS DBAScripts

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…

July 1, 2017 Query to find workflow services are up and running?

APPS DBAAppsDBA ScriptsScripts

Query to find workflow services are up and running?

July 1, 2017 How to check online FND_USERS in Oracle Apps

AppsDBA ScriptsScripts

How to check online FND_USERS in Oracle EBS R12