Oracle Apps Technical Stuff
Saturday, September 13, 2014
Script To register the Custom Table In Oracle Application using AD_DD_REGISTER_TABLE
›
SET SERVEROUTPUT ON; DECLARE l_appl_short_name VARCHAR2(40) := 'XXSSN'; l_tab_name ...
Tuesday, September 9, 2014
Script to Explode the DBA_DEPENDENCIES Hierachy till Nth Level
›
SELECT DISTINCT referenced_name , referenced_type , LEVEL , LPAD( ' ',...
Tuesday, August 26, 2014
How to Handle the Date Parameter for Value set (FND_STANDARD_DATETIME) in Oracle R12
›
1. Define the Concurrent Program With Parameter as Date and attach the FND_STANDARD_DATETIME and in the PLSQL Block pass the Parameter to t...
Saturday, August 23, 2014
Script to Compile Invalid Objects in a Schema
›
This procedure recompile invalid objects in a given schema or all invalid objects in the database. Parameter : schema (IN) - Schem...
Tuesday, August 19, 2014
How to use comma separated string build dynamically and pass to IN clause of select statement
›
In some cases, we get a comma separated string as output (say from another select statement) that we would need to pass to the IN claus...
‹
›
Home
View web version