Reports
Discussion List
-
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 42 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM -
Customize Print Receivables Transaction for all Invoice TypesSummary Customize Print Receivables Transaction for all Invoice TypesContent Hello, Oracle has provided 4 different templates for 4 Invoice Types: Invoice, Debit Memo, C…Vinay Gharge 469 views 1 comment 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…User_4VVG2 428 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM -
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro…
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…User_2025-02-07-22-21-23-100 74 views 2 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP -
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data… -
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 22 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Import FR reports via Smartview using XML connections fileContent I'd like to use a smartview connections file to support connecting to multiple pods via shared connections but haven't found a way to access FR content. Does any… -
Default TRCS Financial ReportsContent Hi, How to access the default TRCS Financial reports. I am looking for them in Library->Financial Reports. It is appearing as blank. -
Member Selection for Prompt for Department determines which Generation appears in ReportContent We have a request to show the Level 0 members when the top parent is chosen otherwise show just the member selected. I have attempted using an IfThen() statement… -
Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusSummary Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusContent Hi, Our scheduled BIP reports are stuck on "Waiting" or "Running" status, even the one… -
Report on Transactions that failed in BPMSummary Report on Transactions that failed in BPMContent Hi Has anyone worked on creating reports based on BPM tables. I have requirement to fetch the failed termination…User_2025-01-30-21-52-52-008 130 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 132 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534 Reporting and Analytics for HCM -
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 26 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Notes in new Reports featureContent Hello, We are starting to explore using the Reports tool that is now included in the core Products (Financial Close & Planning). One thing that we noticed is tha… -
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 49 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Createandassign assetSummary Createandassign assetContent The Createandassignasset excel sheet should the cost be entered for the project in the excel. I need some info on the function and h… -
find field name behind oracle formSummary find the 'activity class' field in the the AR tablesContent Hello all, Can you please help me with something? I am trying to find out the table behind the Transa…User_2025-02-04-08-34-10-102 50 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
Rounding Issues in Reports on ScalingContent We have reports which are being scaled to thousands and millions. And we are facing rounding issues resulting in the wrong totals. Please suggest the steps to re…Sandeep Hardikar N S 53 views 6 comments 0 points Most recent by Sandeep Hardikar N S Narrative Reporting -
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a…Mike Householder 29 views 2 comments 1 point Most recent by Mike Householder Reporting and Analytics for HCM -
Accessing External DataSource via Fusion BIP reportsSummary We have a requirement to build a report the data of which will be in oracle cloud as well as in external database.Content Hi Guru's We have a requirement to buil…_IshanAgarwal 288 views 5 comments 0 points Most recent by Pradeep Rananaware-216731 Reporting and Analytics for ERP -
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…Kiran Kancherla 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on Performance Document AcknowledgmentSummary Is there a table or Subject area to report on employee acknowledgement?Content Is there a table or Subject area to report on employee acknowledgement? We need a …User_2025-02-05-15-32-02-086 47 views 3 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio… -
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti… -
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…User_2025-02-04-08-51-08-912 56 views 1 comment 1 point Most recent by Srdjan Ostojic Reporting and Analytics for HCM -
As Of Date reporting and dimensional attributes in OTBIContent Hi, We want to use As Of Date reporting with OTBI. But we are not sure which dimensional attributes will also move to the value at this 'As Of Date'. Will all di…User10137270-Oracle 28 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…Priyanka More-Oracle 187 views 5 comments 1 point Most recent by Priyanka More-Oracle Reporting and Analytics for HCM