-
Get Version number for Oracle apps, Database, Workflow, XML, OS
— Oracle Database version along with hostname and instance name SELECT instance_name, host_name, version, status, database_status FROM v$instance; — Database version along with operating system platform SELECT name, DB_UNIQUE_NAME, platform_name FROM v$database; — Oracle Apps version SELECT release_name, applications_system_name, aru_release_name FROM FND_PRODUCT_GROUPS; — Database Version, PLSQL Version, TNS Version SELECT * FROM v$version; — Oracle…
-
DBMS_XMLSTORE: Insert, Update, Delete XML data
Overview: DBMS_XMLSTORE API / Package enables DML operations to be performed on relational tables using XML data. Steps to use DBMS_XMLSTORE: 1. Create a context handle by calling function DBMS_XMLSTORE.newContext and supplying it with the table name to use for the DML operations. For case sensitivity, double-quote (“) the string that is passed to the…
-
Concurrent requests / programs executed by a specific user
Get details of concurrent requests / programs that are executed by a specific user from a specific responsibility between certain dates. SELECT fcp.user_concurrent_program_name, fcr.request_id, fcr.request_date, fu.user_name Requested_By , fr.responsibility_name FROM fnd_concurrent_requests fcr , fnd_concurrent_programs_tl fcp , fnd_user fu , fnd_responsibility_tl fr WHERE 1 =1 AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.requested_by = fu.user_id AND fcr.responsibility_id =…
-
Internal Requsition and Internal Sales Order Link
Use this query / script to find the link between a internal requisition and internal sales order. Please note that a internal sales order which is created from internal requisition may not always have sales order type as “INTERNAL” or “INTERCOMPANY”. Sales order type can also me “MIXED” or any other custom type so do…