Monday, 22 September 2014

Enable License Product from Licensed to shared in EBS R12

Please find the step by step process how to change the product License from Licensed to Shared.

Step: 1
  
First connect to sqlplus by apps schema to check the current status of the product.
$sqlplus apps/apps

SQL>col a.application_name for a40
col a.application_short_name for a4
col b.status for a1
SELECT a.application_name,
a.application_id,
application_short_name,
DECODE(b.status,'I','I',
DECODE(b.status,'S','S',
DECODE(b.status,'N','N',b.status)))
FROM fnd_application_vl a, fnd_product_installations b
WHERE a.application_id = b.application_id and application_short_name='INV'
ORDER BY a.application_id;

Output:

Application_Id   Application_Name     Application_Short_Name     Status
    401                          Inventory                        INV                                 I               

Solution:SQL> update FND_PRODUCT_INSTALLATIONS
  2  set STATUS = 'S'
  3  where APPLICATION_ID=401;

1 row updated.

SQL> commit;
Commit complete.

Step: 3

SQL>col a.application_name for a40
col a.application_short_name for a4
col b.status for a1
SELECT a.application_name,
a.application_id,
application_short_name,
DECODE(b.status,'I','I',
DECODE(b.status,'S','S',
DECODE(b.status,'N','N',b.status)))
FROM fnd_application_vl a, fnd_product_installations b
WHERE a.application_id = b.application_id and application_short_name='INV'
ORDER BY a.application_id;

Outut:-
Application_Id Application_Name, Application_Short_Name,     Status
    401    Inventory        INV            S

Once done the above.Check the updated status on the application level.

1 comment:

  1. this is a very clear instruction to help us address some issue. question: any other impact/issue for this simple switch ?

    ReplyDelete

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...