How to get profile Images in OTBI Report

How to get profile Images in OTBI Report:

1.Take Person Real Time Subject Area in analysis.
2. Take two columns i.e one Person Number and other Person Id.
3. In person Id column click in options (settings button) and click on edit formula.

In the formula paste the below one:

'<img src="https://dtyoot.fa.ap1.oraclecloud.com/hcmUI/personImage?personId='||CAST("Worker"."Person ID" AS char)||'">'

Note: In the formula which is in red color there replace with your instance.

After that save the report and open the report then we will get the images of the employees.

Follow the below screenshots while doing this:

Disadvantage: When we export the report the we won't get the images in the export files.

It may helpful for you. please visit blog for more information and share your ideas.

Thanks,
Sainath

Delivered Label Name Changing in Oracle Cloud HCM

Delivered Label Name Changing in Oracle Cloud HCM

Throughout the Application if we need to change the delivered Label Name.

Example :

Changing the National ID to PAN Number.

Steps to do this:

1. Create sandbox
2. In Navigator go to User Interface Text
3. Click on search and Replace. Search for the word and give the replace name.
4. Click on preview page. save and close.
5. Check in the Application the word is replaced or not.
6. If replaced it correctly then publish the sandbox.

Follow the screenshots to do this:

It may helpful for you. please visit blog for more information and share your ideas.

Thanks,
Sainath

ENABLE AUDIT FOR HCM DATA LOADER AND HCM SPREADSHEET DATA LOADER

ENABLE AUDIT OF DATA LOADED:

From new releases 18C we can audit the changes made to objects, that we loaded using HCM Data loader or HCM spread sheet data loader.

In Configure HCM Data Loader, we can set the Enable Audit Data parameter on the HCM Data Loader parameters tab.

By default, this parameter is No, we need to override to Yes.

Or

We can pass below line in .dat file

SET ENABLE_AUDIT_DATA Y

Similarly, for HCM spread sheet data loader:

In Configure HCM Data Loader, we can set the Enable Audit Data parameter on the HCM spread sheet data loader parameters tab.

By default, this parameter is No, we need to override to Yes.

Or

We can enable it directly in relevant spreadsheet templates to Yes.

We can audit of data loaded in bulk. To do that:

 In Manage Audit Policies task à Enable auditing level. And we can audit to attributes level in configure Business object attributes.

Creation, update, and deletion of objects are audited when audit is enabled.

Audit of data loaded in bulk has negative impact on performance.

We can purge the audit data for any object by using SET PURGE_AUDIT_DATA Y instruction in .dat files or by using the Set the Purge Audit Data parameter to Yes in spreadsheet templates.

By default, the purging of audit data is set to No in enterprise level we can’t override this parameter.

We cannot enable and purge the audit at a time by using below instructions: (HDL and HCM Spreadsheet data loader)

SET PURGE_AUDIT_DATA Y

SET ENABLE_AUDIT_DATA Y

While purging of audit data to Yes in a .dat file or spreadsheet template, we must disable the audit at that time. SET ENABLE_AUDIT_DATA N

If SET ENABLE_AUDIT_DATA Y for a particular object, the we can't correct load errors for it on the HCM Data Loader Object Errors.

It may helpful for you. please visit blog for more information and share your ideas.

Thanks,

Sainath

HDL Automation using Oracle delivered JAR file

HDL Automation using Oracle delivered JAR file:

Steps:
1. Prepare any business object i.e .dat (Example : Worker.dat) file and zip that file. Example: Worker.zip
2. Then load that zip file in to content server using below java command.

Save the below script with .bat extension :
------------------------------------------------------------------------------------------------------------------------
Java -classpath "C:\My Data\HDLAutomation\oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client.UploadTool url="https://htyup-test.fa.ap1.oraclecloud.com/cs/idcplg" username="Admin" password="Admin1234" primaryFile="C:\My Data\HDLAutomation\Worker.zip" dDocTitle="Worker" dDocName="UCMFA000180556"   dDocAccount="hcm/dataloader/import" http.proxyHost="proxyhost.com" http.proxyPort="8080" log_file_name="C:\My Data\HDLAutomation\Log.out"
-------------------------------------------------------------------------------------------------------------------------

Explanation of above command:

java -classpath

"C:\My Data\HDLAutomation \oracle.ucm.fa_client_11.1.1.jar"   --> jar file location in our local system

oracle.ucm.client.UploadTool url="https://htyup-test.fa.ap1.oraclecloud.com/cs/idcplg" --> Instance Url concate with /cs/idcplg

username="Admin"  --> UserName

password="Admin1234"   --> password

primaryFile="C:\My Data\HDLAutomation\Worker.zip"  --> zip file location in our local system

dDocTitle="Worker"  --> we can give any Name

dDocName="UCMFA000180556"   --> we can give any value but it should be unique and use prefix - UCMFA

dDocAccount="hcm/dataloader/import" http.proxyHost="proxyhost.com"  --> Constant value

http.proxyPort="8080" log_file_name="C:\My Data\HDLAutomation\Log.out"  --> Log File location

To download Jar file of UCM : 
https://blogs.oracle.com/fusionhcmcoe/installing-oracle-webcenter-content-document-transfer-utility

After command successfully ran the we can see the file in content server as shown below:

Example: https://htyup-test.fa.ap1.oraclecloud.com/cs    (URL concatenated with /cs)

3. Then schedule a process in Oracle cloud HCM  using schedule process to import and load that file in to fusion main tables. 

schedule process Name: Import and Load HCM Data File

Note: Run this process by giving the content Id.

After that go to Data Exchange --> Tasks --> Import and Load --> search with the content Id.

 To download oracle.ucm.fa_client_11.1.1.jar file please refer below link:
https://blogs.oracle.com/fusionhcmcoe/installing-oracle-webcenter-content-document-transfer-utility

 It may helpful for you. please visit blog for more information and share your ideas.

Thanks,

Sainath

Welcome Oracle cloud HCM

Welcome Oracle cloud HCM.........