Reports
Discussion List
-
Convert from Thomson Reuters Onesource to TRCSI am in the very early phase of discovery to potentially implement the Tax module in EPM. A couple years (more than 5 now) we implemented Onesource (Thomson Reuters). I …Brian Hargreaves 51 views 2 comments 0 points Most recent by Brian Hargreaves Tax Reporting (Direct Tax) -
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A… -
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 21 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Expand Button in FR is not visibleSummary: Hi, After the OCI migration (which happened last Friday, 20 Oct 2023) the expand button in FR is not visible if opened from SmartView: But it's visible if opene… -
OTBI Learning course detailsSummary Need help to find attributes in subject areaContent Hello everyone, I am having trouble to locate the attributes for the following fields in learning subject are…User_2025-02-05-11-42-08-011 56 views 5 comments 0 points Most recent by VenkataSubbareddy Reporting and Analytics for HCM -
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 31 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Setup table to pull Approval rulesSummary: Setup table to pull Approval rules Content (please ensure you mask any confidential information): Hi, Could you please advise setup table to pull out Approval r…Bhavna-Civeo 63 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to … -
New Hands-on Tutorial for Planning now availableWe are pleased to announce the availability of the following new Hands-on Tutorial. Hands-on Tutorials provide step-by-step instruction on how to complete a set of tasks… -
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Date Calculation formulaHi, I've a requirement where I have to show some data based on future dates and also print dates like First Calendar Date of Next Month, Last Calendar Date of Next to Ne…Ninja 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 31 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM -
How to move data from PCM_CLC to PCM_REP cubeSummary: Content (required): Hi all As per documentation, we have just migrated from Standard PCM to EPCM and we wanted to take advantage of the REP cube. However, I can…NKW 271 views 12 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
Track changes to Primary National Identifier (social)Summary: Track changes to social (Primary National Identifier) Content (required): Have a requirement to identify changes (within the last 30 days) to a person's Primary… -
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it… -
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Maintain Meta Model and IndexHi, We have a Maintain Meta Model and Index process in error in scheduled processes. This was scheduled by someone who is now a leaver, so may be the reason for the erro…Daniel.McDermott 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample OTBI Report and Dashboard Workforce Compensation moduleSummary: Content (required): Hello experts, our customer want to see some delivered OTBI Analysis and Dashboards for workforce compensation module. I've tried to open th…Valerio Curzi 501 views 16 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Enumeration in FCCS reports and call up specific data from a single rowSummary: Enumeration in FCCS reports and call up specific data from a single row Content (required): Hello, I have two questions, with respect to the FCCS reports sectio…Anderson Florez 42 views 3 comments 0 points Most recent by Unknown Financial Consolidation and Close -
Vacant Positions in SQLSummary: Hi I have had a request through to list vacancies per Position Code/per CC. But instead of having one row per vacant position, it needs to have as many rows as … -
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report? -
Connect Oracle cloud HCM to MS power BI reportSummary: Connect Oracle cloud HCM to MS power BI report Content (please ensure you mask any confidential information): Hi, Is it possible to connect Oracle HCM data sour…Bhavna-Civeo 71 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM