How to get a employee images using BI report

To get a employee images using BI report:

create data model:
Using the below query:

SELECT A.PERSON_NUMBER,
B.DISPLAY_NAME,
C.IMAGE
FROM PER_ALL_PEOPLE_F A,
PER_PERSON_NAMES_F B,
PER_IMAGES C
WHERE A.PERSON_ID = B.PERSON_ID
AND B.NAME_TYPE='GLOBAL'
AND A.PERSON_ID = C.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE
AND C.PRIMARY_FLAG='Y'
AND A.PERSON_NUMBER IN (DECODE(:pn,'',A.PERSON_NUMBER,:pn))

For parameter use list of values:

SELECT DISTINCT A.PERSON_NUMBER FROM PER_ALL_PEOPLE_F A,PER_IMAGES C where A.PERSON_ID = C.PERSON_ID AND C.IMAGE IS NOT NULL ORDER BY PERSON_NUMBER

Create rtf template:

For image filed use the below tag:
<fo:instream-foreign-object content-type="image/jpg" height="3 in" width="4 in">
<xsl:value-of select="IMAGE"/>
</fo:instream-foreign-object>

Note:Above the IMAGE in red color is the filed name.

The output looks like below:

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

Calculate Accruals and Balances process batch parameters: change the max errors default value 3

How to change max errors and threads for Absence Process :

My clients --> Absences

Click Tasks

Click Configure Absence Batch Parameters

Here change the Max Error number , Total Threads number 

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

Change the start date / hire date / effective start date of Worker with HDL

Change hire date of Worker using HDL :

The start date of a work relationship means the Hire Date. To change the Hire Date we need to use the NewStartDate in work relationship Metadata.

only work relationship is sufficient to change the hire date of an employee.

Worker.dat:

SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonNumber|LegalEmployerName|NewStartDate
MERGE|WorkRelationship|FUSION|100000895467|1234|TEST_LE|2017/07/24


To get source system Id:


SELECT PERSON_ID FROM fusion.PER_ALL_PEOPLE_F WHERE PERSON_NUMBER ='1234'

SELECT PERIOD_OF_SERVICE_ID FROM fusion.PER_PERIODS_OF_SERVICE WHERE PERSON_ID =123456788964

SELECT SURROGATE_ID FROM fusion.HRC_INTEGRATION_KEY_MAP

WHERE SURROGATE_ID = 100000895467
  --(SURROGATE_ID =PERIOD_OF_SERVICE_ID )

Note:
Currently Oracle's Fusion Application doesn't support "changing Start Date of Work Relationship created because of global transfer". This is neither supported from HDL(HCM Data Loader) nor from Fusion User Interface.
When a Fusion user perform the global transfer, it will terminate old WorkRelationship(WR)  and create new one. NewStartDate in HDL is to change the hire date of first work relationship of a person and can not be used to change Global transfer new WR start date.

For changing the start date of the Work Relationship created because of global transfer, you have to cancel that Work Relationship and you have to perform global transfer again with correct date.

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

Thanks,
Sainath

SYSDATE as header in E-TEXT template

We can get the dynamic header in e-text:

Example:

If we need a SYSDATE as header and the person numbers are values for that header.

create a data model with two data sets :

1. Sysdate  : SELECT SYSDATE FROM DUAL
2. PersonNumbers : select person_number from per_all_people_f

The XML file for the above data sets will generate like below:

<?xml version = '1.0' encoding = 'utf-8'?>
<DATA_DS>
<G_1>
<SYSDATE>2019-03-04T06:20:02.000+00:00</SYSDATE>
</G_1>
<G_2>
<PERSON_NUMBER>5678</PERSON_NUMBER>
</G_2>
<G_2>
<PERSON_NUMBER>7799</PERSON_NUMBER>
</G_2>
<G_2>
<PERSON_NUMBER>7769</PERSON_NUMBER>
</G_2>
<G_2>
<PERSON_NUMBER>3557</PERSON_NUMBER>
</G_2>
<G_2>
<PERSON_NUMBER>6436</PERSON_NUMBER>
</G_2>
</DATA_DS>

create a e-text like below:

Format Setup:

<TEMPLATE TYPE>	DELIMITER_BASED
<OUTPUT CHARACTER SET>	UTF-8
<NEW RECORD CHARACTER>	Carriage Return

Format Data Records:

<LEVEL>

DATA_DS

<LEVEL>

G_1

<MAXIMUM LENGTH>	<FORMAT>	<PAD>	<DATA>	<COMMENTS>
<NEW RECORD>		Line
1000000	ALPHA		TO_CHAR(SYSDATE,’YYMMDD’)	SYSDATE

<END LEVEL>

G_1

<LEVEL>

G_2

<MAXIMUM LENGTH>	<FORMAT>	<PAD>	<DATA>	<COMMENTS>
<NEW RECORD>		Line
1000000	ALPHA		PERSON_NUMBER	PERSON_NUMBER

<END LEVEL>

G_2

<END LEVEL>

DATA_DS

 The output will come like below:

190304

5678

7799

7769

3557

6436

In the above output the header is SYSDATE and the remaining values are Person Numbers.

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

Thanks,
Sainath

Correct Legal Employer Name for Employees

Correct Legal Employer For Employee:

HR Administrator selects an Incorrect Legal Employer while hiring. We can correct this legal Employer:

Legal Employer can be changed by cancelling the current work relationship hiring the employee again in the correct legal employer. The existing record will be found when attempting to create a New Person with the correct Legal Employer.

Steps:

1. Hired worker in wrong LE

2. Steps to Cancel Work Relationship

      Navigator > Person Management > Search for Person

3. Select person

    Manage Work Relationship

    Actions > Cancel Work Relationship

    Navigator > New Person > Hire an Employee

4. Enter person details to include correct LE

    Select Person > Continue

    Navigator > Person Management  > Search for Person By including Termination check box >Only One record found.

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

Thanks,
Sainath

How to make a user Read only in Oracle cloud HCM

How to make a user Read only in Oracle cloud HCM:

We can make a user to read only in oracle cloud HCM. If that user tries to update any thing then that user gets error.

Error: You have only read-only access to all applications. You cannot perform updates. (FND-3319)

1.  Setup and Maintenance à Manage administrator profile Values
2.  Search profile Option Code: FND_READ_ONLY_MODE
3. Click add (+) and set :

             Profile level: User

             User Name: HCM_Read_Only

             Profile Value: ENABLED

To rollback this read only option set the Profile Value: Enabled

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

Thanks,
Sainath

Introduction to SandBox:

Sandbox:

1. Sandbox is the tool used to manage customization or edit pages. 

2. Sandbox provides an independent development environment so that we can fully test our changes before merging them with the main application and making them available to end users. 

3. Anyone who makes sandbox active can see the changes that are made in that sandbox. When a sandbox is published the changes that are made in that sandbox are visible to all users who have the permissions to view the affected pages and fields.

4. We cannot delete the active sandbox. The good thing to do is delete the sandboxes that are not required. We can create any number of sandboxes, there is no limit.

5. Role required to create sandbox: Application Implementation Admin 

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

Thanks,
Sainath