HRMS Full Install to shared Mode
Please follw Thw MEtalink ID:
1)Please folle these Steps
The output of this script will verify whether legislations have or have not been installed against your instance. SQL> select substr(application_short_name,1,4) app2 , rpad(decode3 (Legislation_code,null,'GLOBAL',Legislation_code),7,' ') LE_CODE4 , rpad(status,14,' ') "Install Status"5 , rpad(action,15,' ') "DataInst Action"6 , last_update_date7 from hr_legislation_installations8 where application_short_name in ('PER','PAY')9 order by LE_CODE,app;
Your Query Output shows that none of the Legislations is in Status Installed. Please go ahead and perform the step 2 of the note. Please confirm once again , none of the legislations are in status I. it should be Null.
2. If it is found from running the script that you have never run the hrglobal.drv script (legislations ARE NOT installed against your instance), then changing this instance from FULL HR Install to SHARED HR Install is quite simple. Just run the following script to flip the flag in table FND_PRODUCT_INSTALLATIONS from Installed(I) to Shared Installed(S): update FND_PRODUCT_INSTALLATIONS set STATUS = 'S' where APPLICATION_ID = 800; Note that you should verify the installation for ALL Oracle HRMS related products at this point, and alter the installation STATUS for these products as needed: application_id = 453 = HRi = Human Resources Intelligence application_id = 800 = PER = Human Resources application_id = 801 = PAY = Payroll application_id = 804 = SSP = SSP application_id = 805 = BEN = Advanced Benefits application_id = 808 = HXT = Time and Labor application_id = 809 = HXC = Time and Labor Engine application_id = 810 = OTA = Learning Management application_id = 8301 = GHR = US Federal Human Resources application_id = 8302 = PQH = Public Sector HR application_id = 8303 = PQP = Public Sector Payroll application_id = 8403 = LD = Labor Distribution The following script will display your current Installation STATUS for each of the above named Oracle HRMS related products: 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 b.application_id IN (453,800,801,804,805,808,809,810,8301,8302,8303,8403) ORDER BY a.application_id; Based on your output of the above script, the 'update FND_PRODUCT_INSTALLATIONS' script can be altered as needed. EXAMPLE: If both PER and PAY were fully installed, and the hrglobal.drv script has never been run, then the 'update FND_PRODUCT_INSTALLATIONS' script would be altered as follows: update FND_PRODUCT_INSTALLATIONS set STATUS = 'S' where APPLICATION_ID IN (800,801); Once the flag has been flipped from Installed (I) to Shared Installed (S), then from this point forward the Shared HR forms should be available to you from within your other installed Oracle Applications, such as Payables, Purchasing, etc. Note that as a SHARED HR Installed instance you should check to see if you now also have the 'HR Foundation' responsibility available to assign to users. This responsibility availablity is dependent upon your Oracle Applications release version. You can verify your changes by running the following script once again: 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 b.application_id IN (453,800,801,804,805,808,809,810,8301,8302,8303,8403)
2. If it is found from running the script that you have never run the hrglobal.drv script (legislations ARE NOT installed against your instance), then changing this instance from FULL HR Install to SHARED HR Install is quite simple. Just run the following script to flip the flag in table FND_PRODUCT_INSTALLATIONS from Installed(I) to Shared Installed(S): update FND_PRODUCT_INSTALLATIONS set STATUS = 'S' where APPLICATION_ID = 800; Note that you should verify the installation for ALL Oracle HRMS related products at this point, and alter the installation STATUS for these products as needed: application_id = 453 = HRi = Human Resources Intelligence application_id = 800 = PER = Human Resources application_id = 801 = PAY = Payroll application_id = 804 = SSP = SSP application_id = 805 = BEN = Advanced Benefits application_id = 808 = HXT = Time and Labor application_id = 809 = HXC = Time and Labor Engine application_id = 810 = OTA = Learning Management application_id = 8301 = GHR = US Federal Human Resources application_id = 8302 = PQH = Public Sector HR application_id = 8303 = PQP = Public Sector Payroll application_id = 8403 = LD = Labor Distribution The following script will display your current Installation STATUS for each of the above named Oracle HRMS related products: 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 b.application_id IN (453,800,801,804,805,808,809,810,8301,8302,8303,8403) ORDER BY a.application_id; Based on your output of the above script, the 'update FND_PRODUCT_INSTALLATIONS' script can be altered as needed. EXAMPLE: If both PER and PAY were fully installed, and the hrglobal.drv script has never been run, then the 'update FND_PRODUCT_INSTALLATIONS' script would be altered as follows: update FND_PRODUCT_INSTALLATIONS set STATUS = 'S' where APPLICATION_ID IN (800,801); Once the flag has been flipped from Installed (I) to Shared Installed (S), then from this point forward the Shared HR forms should be available to you from within your other installed Oracle Applications, such as Payables, Purchasing, etc. Note that as a SHARED HR Installed instance you should check to see if you now also have the 'HR Foundation' responsibility available to assign to users. This responsibility availablity is dependent upon your Oracle Applications release version. You can verify your changes by running the following script once again: 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 b.application_id IN (453,800,801,804,805,808,809,810,8301,8302,8303,8403) SQL> update FND_PRODUCT_INSTALLATIONSset STATUS = 'S'where APPLICATION_ID = 800; 2 31 row updated.SQL> col a.application_name for a40SQL> col a.application_short_name for a4SQL> col b.status for a1SQL> SELECT a.application_name,2 a.application_id,3 application_short_name,4 DECODE(b.status,'I','I',5 DECODE(b.status,'S','S',6 DECODE(b.status,'N','N',b.status)))7 FROM fnd_application_vl a, fnd_product_installations b8 WHERE a.application_id = b.application_id9 AND b.application_id IN (453,800,801,804,805,808,809,810,8301,8302,8303,8403)10 ORDER BY a.application_id;APPLICATION_NAME--------------------------------------------------------------------------------APPLICATION_ID APPLICATION_SHORT_NAME D-------------- -------------------------------------------------- -Human Resources Intelligence453 HRI SHuman Resources800 PER SPayroll801 PAY SAPPLICATION_NAME--------------------------------------------------------------------------------APPLICATION_ID APPLICATION_SHORT_NAME D-------------- -------------------------------------------------- -SSP804 SSP SAdvanced Benefits805 BEN STime and Labor808 HXT NAPPLICATION_NAME--------------------------------------------------------------------------------APPLICATION_ID APPLICATION_SHORT_NAME D-------------- -------------------------------------------------- -Time and Labor Engine809 HXC NLearning Management810 OTA NUS Federal Human Resources8301 GHR SAPPLICATION_NAME--------------------------------------------------------------------------------APPLICATION_ID APPLICATION_SHORT_NAME D-------------- -------------------------------------------------- -Public Sector HR8302 PQH SPublic Sector Payroll8303 PQP NLabor Distribution8403 PSP S12 rows selected.
Now your instance is share HR instance. Check with your functionaly guys, if they are able to open the people form on SHared Instance?
The Employee Form under the Purchasing Super user Responsibility is the correct form for Shared HR instance. you will not be able to open this form, if you have a full installation of HR.
I am entered the Name in People form in Purchasing and IndiaHRMS Manger
If it is success HRMS is in Shared Mode
No comments:
Post a Comment