Reports
Discussion List
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 221 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
Creating Reports and Extracts: How to map/link application front end fields to back end database tabSummary Looking for a simple way to map application pages/fields to cloud database tablesContent Good morning, I have been digging through the schema documentation while…User_2025-02-10-17-54-21-557 284 views 5 comments 1 point Most recent by Vamsi BOmmagani Reporting and Analytics for HCM -
Stacked Charts Unavailable?Watching a tutorial where the author created a stacked chart. I do not see this currently in narrative. Did the feature disappear? Thank you. -
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o… -
Pass Dashboard prompt and analysis filters to drill down analysisI have a summary analysis of employee count by home state in a dashboard using a dashboard date prompt to pull as of a certain effective date. I have other filter criter…Susan Anderson 111 views 9 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
how to call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…Venkatesan 828 views 4 comments 1 point Most recent by Ketan Prajapati Reporting and Analytics for HCM
-
I am unable to fetch payroll details with worker and bank details in OTBI .Summary: When i take only payroll columns like payroll_id, payroll_name then i got output but when i select payroll columns with bank details or worker columns getting n…mohityagyik 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Clubbing of SOA Instances while Invoking a web service using BIP reportSummary Clubbing at SOA instance instead of creating new instance while calling a external web service from SaaS BIP report as a Webservice type of BIP report.Content We…
-
Can you create a group or parent across several dimensions?Summary: Is it possible to create parents or groups involving multiple dimensions such as a "Gift Card" parent containing ("Account 1, Region 1, Dpt 1" and "Account 2, R…
-
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my …Cansel Karasoy 52 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?Cansel Karasoy 763 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Report Bursting - Can you publish a report in excel version to library folder?Summary: Client is needing a way to automate exporting reports to an external directory - Want to use an API to grab report from folder structure in Library but it needs…Valerie Fisher-279201 53 views 4 comments 0 points Most recent by Valerie Fisher-279201 Financial Consolidation and Close
-
How can I run the report when I select the required parameter field 'ALL'?Hi, I have 1 parameter that is mandatory in the report I prepared, assignment status, you can see it in the screenshot. It is true that the report should not be opened w…Cansel Karasoy 61 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
report formatting questionSummary: looking for help on report formatting with $ on first and last line but left justified Content (required): looking for help on the best way to format reports so…Nancy Ackerman 41 views 1 comment 0 points Most recent by Ganesh Golla Financial Consolidation and Close -
Query to extract the last update date for document record fieldsSummary: Query to extract the last update date for document record fields Content (required): Hello experts, please, could you share the query to execute in order to fin…Freddy_Cerron 355 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
"Search" bar in Smartview for "Import formatted Report" isn't availableDoes anyone faced similar issue, I'm trying to open reports in excel and there is search button to search for members. For example: "Centre" dimension has 800+ members, …User_2025-03-10-22-57-31-218 51 views 4 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning
-
FRS Report - Line break after change of cost centre in cost centre / parent rows - how?Summary: FRS Report - Line break after change of cost centre in cost centre / parent rows - how? Content (required): This feels like it should be easy, but isn't proving…
-
Oracle Analytics Cloud (OAC) - Briefing Books QuestionSummary: Briefing Books Update functionality Content (required): We are trying to create a briefing book that automatically updates itself whenever changes are made to t…Miguel Cardoso 41 views 2 comments 0 points Most recent by Miguel Cardoso Reporting and Analytics for HCM
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
What table is the values in "Payroll Transfer Status" and "Payroll Processing Status" stored?The screenshot below is accessible in Team Time Cards: I was looking for how could I get the values for "Payroll Transfer Status" and "Payroll Processing Status" -
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Is it possible to choose a member dynamically based on another member selection?Summary: We have users a number of use cases where we'd like to select a member in a report based on another member selection. For example we have a view dimension which…
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Recruitment Requisitions in Draft Not Displayed in AnalyticSummary In OTBI Answers, when querying recruitment requisitions that are in draft in Fusion, they aren't not returned.Content Recruitment requisitions that are in draft …User_2025-02-05-17-23-19-130 36 views 5 comments 1 point Most recent by Tina T Reporting and Analytics for HCM
-
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins…Tammy Hemmingson 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 171 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM