Reports
Discussion List
-
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 102 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 42 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. 52 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 32 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 445 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 63 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 42 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 52 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 -
Oracle Fusion HCM Extract getting fails when we select Delivery Type as FTPSummary: Hi, Delivery option getting failed when we select delivery type as "FTP" along with bursting in BI data model. if I select Delivery type as "None" extract getti…
-
Dimension Management in PCMCS through Smartview not availableSummary Dimension Management in PCMCS through Smartview not availableContent Hi All- We know we don't have the facility of dimension management in PCMCS through Smartvie…Amit Agarwal-158816 48 views 10 comments 2 points Most recent by NKW Profitability and Cost Management -
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 62 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is there a standard report for generating invoice cover letter by contractSummary: Is there a standard report for generating invoice cover letter by contract Any inputs on this will be appreciated. Content (required): Version (include the vers…