HOME > > Working with India localization after upgrade to R12

Working with India localization after upgrade to R12

Anup - Monday, January 30, 2012

What are the patches required for indian Localization in Release 12?

In Release 12, India Localization functionality is included in Base rollup patches itself (For example RUP04, RUP05 etc.,). Hence there is no need to apply separate patches for India Localization as in Release 11i.

As an DBA, We need to Enable all the localisation triggers. By default all will be in disabled stage after upgrade.

How to find out the disabled localization triggers?

SQL>

select owner,trigger_name,status from dba_triggers where trigger_name like 'JA%';

How to enable localization trigger?

Method: 1

1. You enable all the disabled trigger starting with JAI_
2. stop the application. if any scheduled request runs and the trigger fires it will end up in some other issue.
3. Login to database as "apps" user and execute bellow command for all triggers:

ALTER TRIGGER JAI_INV_MMT_ARIUD_T1 ENABLE;

you have to repeat for all the the disabled triggers.

Method: 2

Take the applications down and put it in maintenance mode then do the following:

Post R12 upgrade Oracle Financials for India triggers will be created in a disabled state.
Once the upgrade is completed run adpatch providing the driver as jai5188052.drv

Driver present in JA_TOP/patch/115/driver

This will enable Oracle Financials for India triggers.

For existing Oracle Financials for India customers, the triggers will be automatically created and enabled on completion of upgrade steps. Hence no manual post-upgrade steps are required for these customers.

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me