Get Started with Redwood for Oracle Cloud HCM Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Is it possible to present the data from first table as shown in second table using BI Report?

Apr 8, 2024 11:27AM in Reporting and Analytics for HCM 4 comments

Summary:

This is the sample data we have and need to present as shown n Table 2

****_ID	ACTION_CODE	REASON_CODE	PERSON_ID	EMP_TYPE	****_SEQ	EFF_DATE	PRIMARY_FLAG	STATUS	LAT_CHN
300000016033156	LEAVE_BEGIN	BENEFITS	100000000152363	E	2	11/20/2021	Y	ACTIVE	Y
300000016033156	LEAVE_RET	BENEFITS	100000000152363	E	2	12/16/2021	Y	ACTIVE	Y
300000016033156	LEAVE_BEGIN	BENEFITS	100000000152363	E	2	10/9/2023	Y	ACTIVE	Y
300000016033156	LEAVE_RET	BENEFITS	100000000152363	E	2	11/10/2023	Y	ACTIVE	Y

Table2:

****_ID	ACTION_CODE	REASON_CODE	EFF_DATE	ACTION_CODE	REASON_CODE	EFF_DATE	ACTION_CODE	REASON_CODE	EFF_DATE	ACTION_CODE	REASON_CODE	EFF_DATE
300000016033156	LEAVE_BEGIN	BENEFITS	11/20/2021	LEAVE_RET	BENEFITS	12/16/2021	LEAVE_BEGIN	BENEFITS	10/9/2023	LEAVE_RET

Tagged:

0

Howdy, Stranger!

To view full details, sign in.

Don't have an account? Click here to get started!