Tuesday, June 30, 2020

How to migrate HSDL templates from one environment to another environment using FSM/Configuration Package in Oracle HCM Cloud environment

How to migrate HSDL templates from one environment to another environment using FSM/Configuration Package

Migrating HSDL templates using FSM has 3 parts.
      1>    Create an Implementation Project.
      2>    Create Configuration Package using the same Implementation Project.
      3>    Migrate the Configuration Package in the target environment.

Part 1:
Step 1: In the source environment navigate to 
Setup and maintenance à Tasks àManage Implementation Projects

Screen shot: 1











Step 2: Now click on the below “+” button and create an Implementation Project.
Put the details as per screen shot 3 and click on the “Save and Open Project” button

Screen shot: 2


Screen shot: 3









Step 3: Now click on the below “+” button. A popup window will open.
From the dropdown select the option “Tasks” and search for the task “Manage Spreadsheet Templates”. Select the task and click on Done as per below Screen shot 5

Screen shot: 4








Screen shot: 5

Step 4: Once the task is added in the Implementation Project, please click on the Done button in the Implementation Project creation screen (Screen shot 4). Then it will navigate again to the main Implementation Project Page. Please click on the Done button in the Implementation Project Main Page (Screen shot 2).





Part 2:

Step 5: Navigate to Setup and Maintenance à Tasks à Manage Configuration Packages

Screen shot: 6








Step 6: Click on the “+” button as below and create a new Configuration Package.

Screen shot: 7




Step 7: In the create Configuration Package page, select the Implementation Project name from the dropdown as below and click on OK if any warnings appears. Then click Next.

Screen shot: 8









Step 8: In the create Configuration “Select Objects for Export” page, click on the “+” button as below to select the HSDL template name which we want to migrate to the target environment.
Put the name of the HSDL template in the Name field as per Screen shot 10. Click on the search button. Once you get the HSDL template, select the template and click on Save and Close button. Then Click on Next.

Screen shot: 9


Screen shot: 10


Step 9: Click on the Submit button.

Screen shot: 11


Step 10: Once the Configuration Package creation process is submitted, please check the status in the Export and Import Processes section. Click on the refresh button several times and check if the status of the process changes to “Completed Successfully”.

Screen shot: 12






Step 11: Once the process is completed successfully, please click on the “Download” button as below and Download the Configuration Package. Please check Screen shot 13.

Screen shot: 13











Part 3:

Step 12: Now login to target environment and navigate to Setup and Maintenance à Tasks à Manage Configuration Packages

Screen shot: 14





Step 13: In the target environment, Manage Configuration Packages page, click on the upload button and upload the Configuration Package which has been downloaded from source system.
Once the Configuration Package has been uploaded, please click on the Submit button.
Then check in the Export and Import Processes section whether the upload has been completed successfully or not.

Screen shot: 15








Screen shot: 16



Screen shot: 17




Step 14: Once the upload has been completed successfully, please click on the Import Setup Data button as per Screen shot 17.



Step 15: In the Import Setup Data details page, please click on Next. Then Click on Next again in the Select Pauses for External Import page. At last in the Schedule and Notifications page click on the Submit button.

Screen shot: 18






Screen shot: 19


Screen shot: 20







Step 16: Now in the Export and Import Processes section please click on the refresh button several times and check whether the process gets completed successfully or not.

Screen shot: 21







Screen shot: 22







Step 17: Now in the target environment navigate to

Home à My Clients Group à Data Exchange à Spreadsheet Templates and search for the template which we were trying to migrate.


Wednesday, June 17, 2020

SQL for getting the active user details in Oracle HCM Cloud environment

Sample SQL Query (You can modify as required):
-----------------------------------

SELECT P.PERSON_NUMBER
,U,USERNAME
,U.ACTIVE_FLAG
,U.SUSPENDED
FROM PER_USERS U, PER_ALL_PEOPLE_F P
WHERE U.PERSON_ID = P.PERSON_ID
AND U.ACTIVE_FLAG = 'Y'
AND U.SUSPENDED = 'N'

AND TRUNC(SYSDATE) BETWEEN TRUNC(P.EFFECTIVE_START_DATE) AND TRUNC(P.EFFECTIVE_END_DATE)

Monday, June 8, 2020

Some Useful Document ids or urls for Oracle HCM Cloud



Oracle Document Ids and urls below :

1> How to Submit ESS Process Using Web Services in Fusion Applications? (Doc ID 2261832.1)

https://support.oracle.com/cloud/faces/SearchDocDisplay?_adf.ctrl-state=yu9kcqjz7_79&_afrLoop=120723940535233

 

2> PurgeDataLoaderHistoryJob Esswebservice Error (Doc ID 2411597.1)

https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=132861752990903&_afrWindowMode=0&id=2411597.1&_adf.ctrl-state=fptw1o3b_179#REF

 

3> Implementing Applications (20A)

https://docs.oracle.com/en/cloud/saas/applications-common/20a/facia/external-integration.html#FACIA1967370

 

4> How Date Track Works (Doc ID 177733.1)

https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=120817467211210&_afrWindowMode=0&id=177733.1&_adf.ctrl-state=yu9kcqjz7_395

 

5> How Do I Load Chinese Geographies? (Doc ID 1466218.1)

https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=121045619481087&_afrWindowMode=0&id=1466218.1&_adf.ctrl-state=yu9kcqjz7_565

 

6> Oracle HCM Cloud Common Features Release 13 Transaction Console (Doc ID 2430452.1)

https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=121190452686767&_afrWindowMode=0&id=2430452.1&_adf.ctrl-state=yu9kcqjz7_640

 

7> Fusion Applications BI Publisher : How to control BI Publisher Data Model time out (Doc ID 1921393.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=218733236739399&id=1921393.1&_afrWindowMode=0&_adf.ctrl-state=g5nn9p97j_80

 

8> Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-A916185B-B23E-4549-9B1E-5934E6643594.htm#BIPRD3375

 

9> Access HCM cloud flex fields over REST API

https://www.ateam-oracle.com/access-hcm-cloud-flex-fields-over-rest-api

 

10> R13.19A OTBI Direct Database Query Privilege Change

https://cloudcustomerconnect.oracle.com/posts/793de86ab3?commentId=228430&lang=en_US&opentoken=QXBpS2V5PTkyZDk4OTQ3ZDkyMjY1MjAmcF9jaWQ9MTc3ODE0JnBfZW1haWwuYWRkcj1zb3VyYW1heiU0MGluLmlibS5jb20mcF9uYW1lLmZpcnN0PVNvdXJhdiZwX25hbWUubGFzdD1NYXp1bWRlciZTaWduYXR1cmVWZXJzaW9uPTImU2lnbmF0dXJlPWdnMkRCcEhISWFaV1RleExPUUNiUVpnSUlNZyUzRCZwX3Nlc3Npb25pZD1WalNIZUtRbyZwX3RpbWVzdGFtcD0xNTk3NzIyMDI5

 

11> Fusion Apps, BI Publisher, How To Report On Employee Photos ? If They Have an Photo Uploaded as Profile Photo (Doc ID 2078841.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=319821029613674&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2078841.1&_afrWindowMode=0&_adf.ctrl-state=17x2d58gu2_4


12> Set profile photo for FUSE homepage (Doc ID 2011869.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=321405910229117&id=2011869.1&_afrWindowMode=0&_adf.ctrl-state=17x2d58gu2_372


13> Displaying User's Photo on Fusion Application's Welcome Page Social Panel (Doc ID 2322712.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=321408817761183&id=2322712.1&displayIndex=3&_afrWindowMode=0&_adf.ctrl-state=17x2d58gu2_421#REF





How to create a Custom Role only having access to Setup and Maintenance

  To create a Custom Role only to have access in Setup and Maintenance, we need the below privileges: Please follow the below instructions t...