Working with India localization after upgrade to R12
What are the patches required for indian Localization in
Release 12?
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.
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.
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%’;
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.
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:
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:
then do the following:
Post R12 upgrade Oracle Financials for India triggers will
be created in a disabled state.
be created in a disabled state.
Once the upgrade is completed run adpatch providing the
driver as jai5188052.drv
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.
triggers will be automatically created and enabled on completion of upgrade steps. Hence no
manual post-upgrade steps are required for these customers.
Responses