SQL Developer is not showing view outputs

SQL Developer is not showing org_organization_definitions view output

Cause: SQL developer default NLS setting taken from client Language settings. If client language setting is not matched with database language setting, language specified view will not show any outputs in SQL Developer

Solution: Skip NLS setting in SQL Developer
 Tools à Preferences à Database à NLS

R12 Cloning issues

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management

------Appstier cloning------
Beginning application tier Apply - Tue Dec 21 20:20:14 2010

/12i/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /12i/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/12i/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/12i/apps/apps_st/comn/clone/jlib/java:/12i/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/12i/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/12i/apps/apps_st/comn/clone/jlib/oui/share.jar:/12i/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/12i//apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /12i/inst/apps/inst_machine//appl/admin/inst_machine.xml -stage /12i/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /12i/inst/apps/inst_machine/admin/log/ApplyAppsTier_12212020.log

3% completed

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.

Restored the Context file in :
/12i/inst/apps/inst_machine/appl/admin/inst_machine.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed

- 78% completed

Completed Apply...
Tue Dec 21 20:30:42 2010

If you ignore this error, cloning will be completed sucessfully

How to find the financial year starting date based on tansaction date

Example : Financial period April to March


select '01-APR-'|| decode (to_char (to_date (:transaction_date), 'MM'), '01', to_char (to_number (to_char (to_date (:transaction_date), 'YYYY')) - 1), '02', to_char (to_number (to_char (to_date (:transaction_date), 'YYYY')) - 1), '03', to_char (to_number (to_char (to_date (:transaction_date), 'YYYY')) - 1), to_char (to_number (to_char (to_date (:transaction_date), 'YYYY'))))yearfrom dual

Transaction date : 31-DEC-2009
Result : 01-APR-2009


Transaction date : 01-MAR-2010
Result : 01-APR-2009