Reports
Discussion List
-
How we can schedule report to a shared folder.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Abhishek.Sachdeva 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Randomization of employee list(from different BU/Department) for every runSummary: Report to fetch Random list employees for every run Content (please ensure you mask any confidential information): I need the report to fetch randomized list of…Raksha Govindaraj 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
HR Dashboard - Headcount Tab - Where to find data, how to change colors, and how to change filters?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know the reason the colors are different for the same categories and if they can be…Jay_Brannan 3 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
Custom BI Publisher reports takes a long time to completeSummary: I created a custom BI Report. When I run the report it takes about 23 seconds to complete. When my client runs the report it takes almost 10 minutes to complete…Consultant Ian 55 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
BIP Report Citibank PaycheckHello everyone, I would like to ask if you have or if there are any existing RTFs that follow the specifications for Citibank Paycheck. Thank you.CAMIL_Q 1 view 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How can I create multiple records in a single payload from Postman?Hi, I can create them one by one as follows, but I get the following error when creating more than one record in a single payload. Can you correct my mistake? Thanks { "…Cansel Karasoy 11 views 2 comments 0 points Most recent by Bianca Culea-Oracle Reporting and Analytics for HCM -
Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Email bounce back notification fusion hcmSummary: Client have a requirement where in a recipient try to reply to "sender email address" an email bounce back notification to be sent to recipient. for example: De…Shiva Prasad M 11 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…Manoharan 61 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
All Active employees that receives no pay or $0 gross pay for any pay periodSummary: There is a requirement where client need a report having list employees receiving no pay or 0$ Gross pay based on previous 26 pay periods. We have a bi-weekly P…Rahul Saini 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…Afrid_3R3AE 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
-
Display only Learning Initiative data from the WLF_EVENT_ASSIGNMENTS_F tableSummary: We noticed that data belonging to both Learning Assignments and Learning Initiatives is being stored in the same table: WLF_EVENT_ASSIGNMENTS_F. According to th…upanshu avi-Oracle 51 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
-
expedited element entries querySummary: Hi, We have a report about the expedited element entries but not for HCM Extracts. Do you have any sample query about how to get this report?
-
How to Restrict BIP report data based on the AORsSummary: Hi All, @Mandeep Gupta --> If you have faced any such type issues kindly help me with this. I have a requirement to build a BIP report in such a way that If emp…Dasari Dileep 402 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Parag Hiremath 1 view 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…Parag Hiremath 22 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to print a prompted date selectionSummary: I have an analysis with a date range prompt on the field Work Relationship Start Date. I would like to display in the report the range that the user selected. W…
-
Aaron Reynolds 11 views 1 comment 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
How to extract LEGAL_ENTITY_IDENTIFIER?I need a SQL query for a BI report to extract the LEGAL_ENTITY_IDENTIFIER, starting from a department.Gian Luca Triglia 95 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Compensation Salary History Details Real Time not showing data for leaversSummary: Hi all I have built a report in OTBI using the Compensation - Salary History Details Real Time. I noticed I am missing data for employees who have left the orga…NusratB 71 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Redwood Help Desk - Departmental StructureHi all, Does anyone have any suggestions on how to report on the department of the individuals available (Affected Party, Contact, Agent, etc) within the Redwood Help De…
-
OTBI Termination Date Filter Syntax QuerySummary: Hiya, I am trying to filter out any records where the Termination Date is before the current date. If the termination date is after the current date then the re…Kevin Robertson 21 views 2 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Workforce Structures > Job Detail Screen - Can You Report a History of Changes?Summary: Is there a way to write an OTBI report that shows old and new values, field name and date of change entered on the Job Detail screen (Workforce Structures/Job D…
-
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
Need to find Entry Grade against Position in OTBISummary: Position Entry Grade reporting in OTBI Content (please ensure you mask any confidential information): Having issues with posting that I believe may be due to mi…Stephen Prentice 64 views 6 comments 0 points Most recent by Stephen Prentice Reporting and Analytics for HCM
-
How to report on data from Workforce Assignment Event Real Time and Workforce Assignment Real TimeSummary: We have a requirement to report historical employee headcount based off values stored in an Assignment DFF. We get accurate historical data only when an action …David Boudreau 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Schedule report to run based on Last Run DateSummary: Is there a way to schedule a report to run starting from last run date? Content (please ensure you mask any confidential information): Version (include the vers…THawkins_LGI 32 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM