Reports
Discussion List
-
Unable to get the OldValue and NewValue by using per_bipntf_utilitySummary: Unable to get the OldValue and NewValue if any change on the Employeement level by using per_bipntf_utility Content (required): We did few changes on the Emplom… -
Layer filters?Summary: Looking to be able to layer filters. An example would be that I want to only pull department names that start with a specific sequence of numbers AND have/don't…Jessica D 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Ethnicity values question in Recruiting Subject AreaSummary: Asking for assistance in understanding the difference between 2 Ethnicity fields Content (required): Hello. Can anyone advise on the difference between the 2 fi… -
OTBI - Calculate Tenure using Presentation VariableSummary: I need show Tenure calculation by subtracting the Work Relation Start Date of a person from the Date passed by the user against the presentation variable (Promp…Harpreet Shergill Oracle 101 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Does oracle has any table that give us Users Signin and signout details for the past few weeksFor auditing purpose we want a report to extract the users who login and logout in the past 7 days login datetime logout datetime if any table or pre-build tables please…Chandra Thangavelu 71 views 5 comments 0 points Most recent by Chandra Thangavelu BI Publisher Learning Center
-
Delegation Approval Query /TableSummary Delegation Approval Query /TableContent HI , i have a requirement to create BI/OTBI report for delegation approvals. Can any one please share the table/query whi…
-
How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system. I want to see all rows of "Payab… -
To avoid Oracle Repository external accessHi team, I need your precious support! Cause of notifying the candidate, we created a BI report adding a "link" to make the recipient able to download a .zip file. We us…tommasodicesare 31 views 0 comments 0 points Started by tommasodicesare Reporting and Analytics for HCM -
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…
-
How do you include inactive requisitions in an analysis?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Ed Sevilleja 51 views 4 comments 0 points Most recent by Ed Sevilleja Reporting and Analytics for HCM
-
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…
-
Error in Financial reporting centerHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add…Victor Chrabieh 41 views 2 comments 3 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Would like to report on HR Help Desk Audit History table in BI PublisherHello, We would like to report on HR Help Desk audit history in a BI Publisher report. Has anyone done this and might be willing to provide instruction? Thank you, Natal…Natalie A. 51 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center -
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 31 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 441 views 10 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Annualized TurnoverSummary Want to incorporate an annualized turnover in my Turnover DashboardContent Is there currently anything with annualized turnover, or do I need to formulate someth… -
What is FRS formula to populate Sep of last year dynamicallyQuestion We have Balance Sheet in FRWS where user selects specific period (Monthly GL calendar) thru prompt e.g. Jun-22. GL calendar is from Oct to Sep. User always want…CA Nirmal Choudhary 161 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
Is it possible to enable "All Values" as an option in a Table Prompt for an OTBI report?Summary: Table Prompt on OTBI report to include an option for the report to return "ALL" Content (required): We have a dropdown menu (table prompt) on an OTBI report tha… -
FRS POV Dimension LayoutSummary: Content (required): Hello: Some reports have all the defined POV's showing when opening the report, and some only show the POV's that need to be changed (i.e.: …
-
Account Analysis report returns no data - 2nd year in a row this report has become broken in March.Summary: In march, this report starts returning no data. Runs fine in Jan & Feb. Last year, the SR reported back that the data model had been updated for performance rea…Miriam Rowan 61 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
What is Maximum Threshold Limits for Management Report in Narrative ReportingSummary: Content (required): Hi, What is maximum threshold limits for the Management Report in Narrative Reporting? I tried but couldn't find in the admin guide. Can any…
-
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…Helen Thomas 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is there a foreign exchange gains and losses report available?Summary: As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the…Felicidat 51 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Employee Vacation and Delegation Rules Report is not being translatedSummary: Unable to translate the seeded Oracle report to FRC Content (required): We are trying to translate the Oracle seeded "Employee Vacation and Delegation Rules Rep…Eva Mirzoyan 41 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
What’s New in EPM Cloud Narrative Reporting and Reports Release 23.02What’s New in EPM Cloud Narrative Reporting and Reports Release 23.02 Please refer to the February 2023 What's New Guide to understand the new features included in EPM C…Dave Roberts_-Oracle 21 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting