Reports
Discussion List
-
Reports and Analytics- Folder Security changes after 22a?We are noticing changes in security access to BI Publisher reports in our Custom Reports and Analytics Folders and Sub Folders. Example 1: Employees with only the Employ… -
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level…Raghavendra M 624 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b… -
BI Publisher Solution ? - Start Excel Preview only open: falseSummary: Hello R&A forum: Start Excel Preview only open: false mTemplate: C:\Users\john.white\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls mT…User_2025-02-12-15-41-59-245 1.7K views 0 comments 0 points Started by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM -
BI Publisher Excel Template preview failsSummary BI Publisher Excel Template preview failsContent I am new to the use of BI Publisher Desktop in Word and Excel to create templates for BI reporting. I have a rep…Dena Swanson 205 views 7 comments 0 points Most recent by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM -
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…User_2025-02-04-10-47-55-876 64 views 3 comments 1 point Most recent by Harry Oracle Reporting and Analytics for HCM
-
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…Meenakshi K 606 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Agents sending out from test instanceSummary: We just received our 22A and received our first refreshes since. We applied the administrative settings to override the email and set notifications to none but …Shanna Oppenheim 21 views 6 comments 0 points Most recent by Gaurav F Reporting and Analytics for HCM -
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.05What’s New in EPM Cloud Narrative Reporting and Reports Release 22.05 Please refer to the May 2022 What's New Guide to understand the new features included in EPM Cloud …Dave Roberts_-Oracle 31 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination Headcount causing errorSummary: Reporting Experts - We are trying to build a simple OTBI that should list the managers (Any level: Level 1 or level 2) with the direct and indirect reports. Whe…Vijay Rajendran 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Does the Default Alias Setup works in FCCS?Summary: we did setup the default alias in the FCCS setting to be one of the custom alias tables we created. In smatview the setup is not reflected and once we connect t…Emanuele Panichi 11 views 2 comments 0 points Most recent by Emanuele Panichi Financial Consolidation and Close
-
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 192 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
HCM Extract | How to find current difference FTE, Incumbent FTE of position in fusion hcmContent Hi All, I am working on a HCM extract and I need to fetch the position details like difference FTE, current Incumbent FTE of position. I am able to get current p… -
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor…Vijay Rajendran 21 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
GL Trial Balance Report Custom TemplateSummary:We've created custom template for TrialBalalnce.xdo, But still ESS job is taking standard template.Is there are changes required in configuration to pick custom …
-
New Member doesn't appear in ReportsSummary: When a new member is created and the database is refreshed, the new member doesn't appear in Reports. Content (required): Hi everyone. When I create a new membe…
-
OTBI Dashboard Embedded into HCM Not ResponsiveSummary: Issue with dashboard running/completing that are embedded in HCM. The dashboards were working until a recent patch after 22A. Content (required): Hi there, We h…
-
Matrix ReportSummary: We have a created a matrix report using BI Publisher report.The requirement is to have the drill down also to view the deatils. Can someone please suggest how c…minati_behera-Oracle 11 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM
-
Threshold Error in Financial Report (HFR)Summary: Hi All, We are facing the threshold limits issue for all the customers and Oracle is refusing to increase the limits from 500,000. Is there any workaround to co…
-
How to build a rule that is Malaysia pull the National Identifiers no, Non Malaysia pull passport noWe Need to build a rule that is Malaysia pull the National Identifiers Field, Non Malaysia pull the Passport number may i know how to write logic. and which field we nee…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center -
Please help on Oracle Learning activity report not pulling activity completion date.Summary: Trying to create a OTBI report for Oracle Learning activity report using Workforce Learning - Learning Management Real Time subject area . But I am not able to …Srinivas Sakinala 51 views 7 comments 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
Organization Hierarchy fields causing missing employeesSummary: We have a report that keeps dropping employees whenever we add the Organization Hierarchy fields level 2 and level 3. We have made sure the values are populated…Shanna Oppenheim 21 views 9 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM