OraChat – Oracle DBAs

Here are some capsules for Oracle E-Business Suite 11i to R12 knowledge transition. Tech Stack Client Sun 1.5 Plug-in Middle Tier Application Server 10.1.3 Application Server 10.1.2 $ORACLE_HOME version (prev 8.0.6): /orachat/product/tech_st/10.1.2 $ORACLE_HOME version (prev 8.1.7): /orachat/product/tech_st/10.1.3 RDBMS Tier Oracle 10g R2 XDK XDB Scripts Also you can refer my previous post @ onlineappsdba …….. […]

After running Gather Schema Statistics concurrent request with (LASTRUN) option to save only the history for last run, then run the concurrent request again for 2 times after that found that (FND_STATS_HIST) tables contains the history for all the 3 requests and it is not cleaned up to keep only last run. Sample steps to […]

If you conducted an import or export of an Oracle10g Release 2 or 11g Release 1 database prior to September 11, 2009, you should follow the instructions in My Oracle Support Knowledge Document 1055539.1 to verify the privileges in your database. This is because a missing step in several OracleMetaLink notes published before 11 September […]

FNDLOAD – One of handy apps utility, especially when we are working in oracle application implementation projects. A good companion for data migration, code migration across various implementations. FNDLOAD assists us to download data from application entity to an editable text file, we can do the necessary changes and upload to another database. Say for […]