Need To Create An OTBI Analysis With Superannuation Details In It (Doc ID 2515484.1)

Last updated on FEBRUARY 09, 2020

Applies to:

Goal

On : 11.13.18.10.0 version, Technology Management - Reports/Analytics

Need to create an OTBI analysis with Superannuation details in it

BI Publisher Report SQL :
SELECT DIR_INFORMATION_CHAR1,DIR_INFORMATION_NUMBER3
FROM fusion.PAY_DIR_COMP_DETAILS_F
WHERE
DIR_INFORMATION_CATEGORY = 'CATEGORY_NAME' And
dir_card_comp_id IN
(
SELECT dir_card_comp_id
FROM fusion.pay_dir_card_components_f
WHERE dir_card_id IN
(
SELECT dir_card_id
FROM fusion.pay_dir_cards_f
WHERE payroll_relationship_id IN
(
SELECT payroll_relationship_id
FROM fusion.PAY_PAY_RELATIONSHIPS_dn
WHERE person_id IN
(
SELECT person_id FROM fusion.per_all_people_f WHERE person_number = 'PERSON_NUMBER'
)
)
)
);
 

This SQL query represents what is needed to be pulled by the OTBI analysis.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.