Sql
Script to find details of Data Definition, Template, File Name of a Concurrent Program
Script: Provide Concurrent Program Short Name, Application Name (Eg. General Ledger) to the following script. It gets Data Definition information…
Learn More »
Sql
Query to get profile options details from backend
SELECT fpov.profile_option_name , fpov.user_profile_option_name, DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002…
Learn More »
Sql
Oracle Triggers
What are Triggers in Oracle? Oracle Triggers are similar to PL/SQL Stored procedures that can be stored…
Learn More »
Sql
Query to get concurrent request set details for parent request set id.
Query to get concurrent request details for parent request set id. SELECT fcr1.request_id , fcp1.user_concurrent_program_name , DECODE…
Learn More »
Sql
Query for Oracle Period status for AP and AR applications
Query for Oracle Period status for AP and AR applications query to check Period status for AP and AR application SELECT GLS.NAME LEDGER_NAM…
Learn More »
Sql
Oracle apps Valueset details Query
Oracle apps Valueset details Query SELECT ffvs.flex_value_set_id, ffvs.flex_value_set_name, ffvs.description set_description, …
Learn More »
Sql
AR and OM link in oracle apps / AR transaction and Sales Order join query
AR and OM link in oracle apps / AR transaction and Sales Order join query SELECT rcta.customer_trx_id, rcta.trx_number, rcta.trx…
Learn More »
Sql
Query to find Invalid Objects with Error in oracle apps
Query to find Invalid Objects with Error in oracle apps SELECT a.object_name, decode(a.object_type, 'PACKAGE', 'Package Spec'…
Learn More »
Sql
Query to find XML OPP Log file
Query to find XML OPP Log file SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name FROM fnd_conc_pp_actions fcpp, …
Learn More »
Sql
Query for AP Interface Errors Details
Query for AP Interface Errors Details: SELECT aii.invoice_num, aii.gl_date, aii.invoice_date, air.Reject_Lookup_Code, aii.Request_…
Learn More »
Sql
To find specific responsibility having by which users
SELECT fu.user_name "User Name", fu.description, frt.responsibility_name "Responsibility Name", furg.start_date "Start…
Learn More »
Sql
Convert Comma Separated Values into Table
The query can come quite handy when you have comma separated data string that you need to convert into table so that you can use other SQL queries …
Learn More »
Sql
Sql
Changing current schema
Yet another query to change the current schema. Useful when your script is expected to run under certain user but is actually executed by other use…
Learn More »
Sql
Showing the table structure
This query gives you the DDL statement for any table. Notice we have pass ‘TABLE’ as first parameter. This query can be generalized to get DDL stat…
Learn More »
Sql
Merge Statement
The MERGE statement is optimized for merging sets of data, rather than single rows, as shown in the example below. Create the following test tab…
Learn More »
