Category 81
Discussion List
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C… -
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 43 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Report to Audit Approval Rules ChangesSummary: Just trimmed back access to Transaction Console, but would like to see who made the most recent Approval Rules changes to workflows, and when the changes were m…Jessica D 545 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Batch Scheduler in PBCSSummary: Looking for way to kick off 45 batch scheduled reports at once Content (required): We have 45 scheduled batch reports that currently run as "Perform Monthly" on…
-
Can you use wildcards in a CASE statement?Summary: I have an analysis where if the Job Name is like 'abc%', '%hpr%', then I want to display certain text. Note that there are multiple wildcards, some only before,…
-
sum of 2 columns to be shown in 3rd column in OTBISummary: Hello, We are trying to sum 2 columns data and show it in 3rd column, however, it is not working. candidate-Job Applied + Candidate-Prospect = Total Referred Ca…Shiva Prasad M 121 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
BI Publisher - Filter Action NameSummary: I have a SQL query that was created by our vendor. I am still a beginner in using SQL so I am seeking assistance in how to filter the report to pull certain act…
-
Report Job Offer Employment Category in AnalysisSummary: I want to Report the Employment Category of a Job Offer in an Analysis Content (required): I use the Subject Area "Recruiting - Recruiting Real Time" and can't …Felix2 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Add division parameter to OTBI reportSummary: I am trying to create an OTBI report under the expense report templates to show approvers of given POs. I am able to add fields for company, department, and acc…
-
Learning Count Using Disability StatusSummary: Using the Workforce Learning - Learning Records Real Time Subject Area to pick up disability (which is using Workforce Management - Person Real Time to count th… -
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC…Rajib_Samanta 71 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Facing issue unable to override Willing to relocate filed by using HDLSummary: We cannot override existing field that is "Willing to relocate " while updating existing field through HDL it is creating one more record. Navigation: Directory…User_2025-07-18-06-45-42-477 31 views 2 comments 0 points Most recent by MandeepGupta HCM Data Loader (HDL)
-
Report on QuestionsSummary: Hi Experts, Can we built a report on questions available in Learning Assessment subscriber to indicate who has changed questions and date/time of change ? Conte… -
Hi, I hope everyone is doing well. I need help to pull every column from Oracle HCM (BI Query) .Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Karthi 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 11 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
What is the expnse items date field in OTBI for out of pocket expensesSummary: We are creating a report in OTBI for expenses. We are using Expense Transactions Real Time subject area. We want to pull the expense item date onto the report. …
-
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature …Amy Wilson 53 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to create a learning Analysis that is triggered by #of days past a certain date?Summary: Please, we're trying to understand if there is a capability with learning assignments (possibly via an OTBI analysis) to trigger certain learning based on an em…
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is…Cansel Karasoy 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SQL for compa ratioSummary: Need correct SQL to find Compa Ratio Content (required): Hello, I am writing a report for the business that includes the compa ratio as one of the columns. And …SeanWesche 62 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Period Close-GLSummary Period Close-GLContent Is there a report that shows the day the GL period was closed.
-
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
Pre-Requisite of Course A Completion but Not Enrolled in/Completed for Course BSummary: I have a business requirement to set up an analysis report in the Assignment Analyses area, where the prerequisite of being able to enroll in Course B, is the c…