Reports
Discussion List
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …Santo Campione 22 views 2 comments 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 34 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 51 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo…
-
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM -
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…Scott_Turner_ 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Oracle Compatible Tamil FontSummary: I have a Letter development which need to compile with Tamil Font. For that I have using Using NirmalUI font and it works fine with word format and rtf format. …Dhajani Perera 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
unpivot dataSummary: Move rows to columns Content (please ensure you mask any confidential information): I am looking to unpivot the data and move Input Value Name and Displayed Inp…Julia Kiszelewska1234 24 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Medical Examination Data OTBI report display problemHello, With a specific role created role of Medical examination I have a problem displaying the report while connecting as a nurse in my organization. At first there was… -
Audit ReportSummary: We did enable the audit for the PER_PHONES table. This reports on future phone number change history. We included date prompts. I updated the phone of the user …Stela Martins-Oracle 21 views 2 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Finding Records with Trailing Space in OTBISummary: Finding records that have a trailing space in OTBI Content (required): We have file transfers that fail when a trailing space is on the end of Address Line 1. I…
-
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 42 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Add new entity using Manage Attachment entitiesIs it possible to add a new entity using 'Manage Attachment entities' task and make the attachments available for one of the standard Objects? I tried adding for one the…SatyendraSingh Dangi-Oracle 41 views 3 comments 0 points Most recent by SatyendraSingh Dangi-Oracle Reporting and Analytics for HCM
-
Job Entry Date and Department Entry Date Equivalents in OTBIContent Wondering if anyone has identified a way to access job entry date and department entry date in fusion hcm. These were delivered calculated fields in People Soft,…Karen Costakes 255 views 7 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for HCM -
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables …nmdp-andrew 503 views 3 comments 2 points Most recent by nmdp-andrew Reporting and Analytics for HCM -
Onboarding Report Jobs failingSummary: we have 15days and 30days reports but when we schedule the report it failing and even self also failed . we are used data parameters duration of 16 months . Det…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …
-
Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Host address in BI publisher reportIs it possible to get the host address in the BI publisher report? Regards, NivyaNivya Mathire 41 views 8 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
HelpDesk category reportingSummary: My company utilizes an HR Shared Services department for HR Inquiries. They are essentially a call center for HR questions. They file tickets for each inquiry, …
-
Where can I find the database table that holds Segment Value Security Conditions and Policies?Summary: I'm looking for the table in the database where Segment Value Security Conditions and Policies live. Content (required): I am making some changes to the rules a…David Rabalais 91 views 2 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Dashboard: Workforce Compensation Budgets issueSummary: Content (please ensure you mask any confidential information): Hello experts, what is the meaning behind the attached budget seeded reports? The count of total …Valerio Curzi 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How can I add a deep link to go straight to an employee's details?Summary: I am trying to create a deep link in OTBI using the employee number to open the Additional Person Info page, but can only get to the initial page rather than th…Mark Stoker 234 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesSummary organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesContent HI Team, report has to be developed in the column format parent_n…Hanuman Chennamsetty 3K views 3 comments 2 points Most recent by Shrikant Gupta Reporting and Analytics for HCM