Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hey team I want to create an OTBI report
which could pull up the additional info column details from payroll relationship. I have a screenshot showing three fields, and I need to populate their values along with the corresponding employee numbers, but only for rows where those fields have data. I've been searching for a relevant subject area that includes these columns but haven't been successful.
Can anyone assist in identifying the subject area that contains these columns? Alternatively, does anyone have a SQL query that can retrieve this information?
Thanks
Navigation: Person management → payroll relationship
Answers
-
Hello
If it is additional information and you have it in the Flex type, first make sure that the checkbox that allows viewing it on the OTBI side is selected, otherwise no subject area will be able to display it to the user.
JJ.
1 -
Can you check if you can see this information in PAY_PAY_RELATIONSHIPS_F table? If no, will you be able to provide the exact DFF name used to define these attributes?
Oracle Application's Blog: Query to get payroll name in oracle fusion
I don't see any particular subject area to get the additional DFF details of payroll relationship. You can get basic details of payroll relationship from multiple subject areas but not the DFF details.
Workforce Management-Assignment Real time subject area can also be used to get the details like worker payroll name , time card required, payroll start date etc.
So, as per my knowledge you may need to go ahead with custom BIP report only. Let us wait to get some more inputs from others.
Thanks.
0
