Reports
Discussion List
-
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 -
Increase the session timeout for Narrative ReportingSummary: Excel Reference Doclet gets all the row heights perfectly set, all the shading the same percentage of grey, borders applied consistently across all the tables, …Himani Jain-Oracle 42 views 4 comments 1 point Most recent by Gebril Abdellatif -Oracle Narrative Reporting -
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 21 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 -
ICP Clearing Account - Monthly Activity - USD_Reporting Alt Entity Rollups issue after 23.11 patchSummary: We are seeing issues with ICP Clearing Account - Monthly Activity - USD_Reporting Alt Entity Rollups issue after 23.11 patch with selection of ILvl0Descendants(…Ija Vidaurri 21 views 3 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
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 Most recent 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 41 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 42 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 Long 274 views 7 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for HCM
-
By thousandsSummary Show my report scaled by ThousandsContent Hello dear friends! I need to represent my Report in Thousands, so I selected all my Cells, Number->Scale value by Thou… -
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 542 views 3 comments 2 points Most recent by nmdp-andrew Reporting and Analytics for HCM -
Need help with checkbox wingding.ttf font fileHi All, we have a requirement to insert check box in a report. based provided "DocID: How to Add a Checkbox in a BI Publisher Report ( Doc ID 2692589.1 )" For the checkb… -
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 41 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 -
Need to clarify usage of service accounts (System/EPM_Default_Cloud Admin) in reports in FCCSummary: Need to clarify usage of service accounts (System/EPM_Default_Cloud Admin) in reports in FCC Content (please ensure you mask any confidential information): SYST…Dj1987 41 views 4 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
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 112 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 292 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 3.4K views 3 comments 2 points Most recent by Shrikant Gupta Reporting and Analytics for HCM -
Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 89 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM