Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 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
Link Payroll Run Results Real Time and Payroll Flows Real Time for Processed Date from Payroll Flows

Summary:
We have a supplemental payroll cycle that runs weekly. During the Payroll Flow set up the Payroll staff uses the "Override" date on the flow parameters in order to pay this period every Thursday.
While generating reports using the Payroll Run Results Real Time, the "Date Paid", "Date Earned" , "Payslip Date" all state either the 15th or last day of month. This is due to us being on a Semi-Monthly schedule. I did find an "Override Date" but this date is not correct either.
I am pulling the Payroll Process Flow Name from the Payroll Run Results Real Time. My idea was to "link" the Payroll Process Flow Name with the Flow Name from Payroll Flows Real Time. The Payroll Flows Real Time subject area has a field called Processed Date and this date does contain the desired check date.
However, when I add the Payroll Flows Real Time subject area, I don't appear to have enough common folders for it to run correctly.
Has anyone else ever linked these 2 subject areas successfully. Any assistance is certainly appreciated.
Content (required):
Link Payroll Run Results Real Time and Payroll Flows Real Time for the Processed Date from Payroll Flows Real Time
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi @Heather Schultz ,
I tried combining both subject areas and it is bringing data for me. We need to make sure that we select both Dim & Fact Entry from both SAs.
Here is an example XML & corresponding data that I'm receiving.
Please let me know in case you are facing a specific issue while combining both SAs.
Cheers,
0 -
Many thanks @Bhaskar Konar
0