Oracle Apps Technical Stuff
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...
Thursday, July 24, 2014
ORA-22160: element at index [9] does not exist
›
ORA-22160 Error For FORALL We have been just amazed at how much better our programs perform when we use FORALL to do our inserts and u...
Friday, July 11, 2014
TCA API: Sample Code to Create AR Customer & Site from AP Supplier & Supplier Site using same Party
›
Doc ID 1447883.1 We will use following sql to find out Party details from Supplier tables SELECT DISTINCT a.party_number, ps.party_sit...
‹
›
Home
View web version