Reports
Discussion List
-
Cumulative totals in OTBISummary: We want to create cumulative Actual costs in OTBI. Please advise how to do this? SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Proj… -
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…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 81 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
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