Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Organization Hierarchy in OTBI missing peopleSummary: Hello, We have updated our org tree on 01/01/2026 and we noticed that when we are adding a field from the 'Organization Hierarchy' subject area catalog folder, … -
Dynamic Signature Management in PDF Job Letter ReportSummary: Need Oracle-recommended approach to dynamically maintain and update signatures in a BI Publisher PDF Job Letter report without modifying the report template whe…
-
HCM module OTBI / SQL report on employee informationSummary: SQL / OTBI report related to LE / BU / Employee first name & Last name / Person number/ Person ID/ Person type /contact with email / Department / User name if t…
-
Is PER_ACTION_OCCURRENCES.CREATED_BY reliable for identifying the initiator?Summary: We use PER_ACTION_OCCURRENCES in our HCM reporting to identify who initiated an assignment transaction (Employee, Manager or HR). Historically, CREATED_BY has b…
-
Is it possible / How to create BIP report output in .xlsx format?Is it possible / How to create BIP report output in .xlsx format? Currently we can only see .xls option while creating the template. Please advise.
-
Ability to disable all the custom OTBI schedule reportsDo we have a process in place to inactivate all OTBI scheduled reports (agents)? We have a business requirement to inactivate all scheduled reports for a certain period …
-
Oracle Recruiting Offer Dashboard ReportingSummary: Oracle Recruiting Offer Dashboard Reporting Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well. This requ… -
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…
-
OTBI Folder DisappearanceSummary: Is anyone experiencing folders disappearing in the catalog? I pulled a report to see what happened to the folder, and there is no record of it being moved or de…
-
BIP report: Profile ID not populated on candidates TableSummary: There is a profile ID on IRC_Candidates that the description says is he foreign key to HRT_PROFILES_B, but it appears to be null for newer candidates. https://d…
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
Consolidated Offer Report and DashboardSummary: Consolidated Offer Report and Dashboard Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well! We are lookin…
-
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
how can i join person number with transaction details in HCM OTBI?Summary: How can i have detailed information on what fields are changed in a transaction, and the person number of the user initiated the transaction? Content (please en…
-
Reporting the candidate offer transaction approval attachmentsSummary: Reporting the candidate offer transaction approval attachments Content (please ensure you mask any confidential information): Hi All, Greetings! This is about t…
-
Query to get attachment URLSummary: I have uploaded the attachment under Skill and Qualifications —> Licenses and Certifications. Need query to get attachment details related license and certifica…
-
BI SQL FILTERWhen I search for a code in a filter, it correctly returns two values—as shown in the query below—but when I select both, only one code appears in the list of selected v…
-
Zip File for 'Identifying Authorized Hosted Named Users' no longer available?Summary: Hi, I used to be the primary person managing Oracle Licenses and would utilize the 'Identifying Authorized Hosted Named Users' reports which provided the follow… -
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 … -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl… -
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
Display a Document of Records Image in a BIP ReportSummary: Hi All We have a requirement to display photos stored in Documents of Record within a BI Publisher (BIP) report. Has anyone implemented this before or can provi…
-
HCM Extract PGP encryption appends .txt extension — supported workaround?Summary: We are generating an HCM Extract file and applying PGP encryption for SFTP delivery. The file is encrypted successfully, but the resulting filename includes an …
-
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…
-
DOCX Output Does Not Preserve Image Alternative Text from RTF TemplateWe are using Oracle Fusion HCM BI Publisher with an RTF layout template. Images in the source RTF contain valid alternative text. The alternative text is present when th…
-
Which HCM Extract DBI to use to fetch full state name (region2) from person address?Summary: Extract_address_region2 and address_region are giving only short forms of state. Is there any other way? Content (please ensure you mask any confidential inform…
-
In BIP, when clicking on the download button in PDF output, an HTML file is downloadedSummary: The issue is when clicking on the download button in PDF output, an HTML file is downloaded instead of a PDF. Would there be any setting to set in the BIP repor… -
HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO does not show some person recordsSummary: HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO and HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO does not show some records though they are avai…
-
Role/privilege is required to retrieve Position Code from OTBI "Position Real Time" in BI Publisher?Summary: Hello Experts, I am trying to retrieve Position information from OTBI subject area Workforce Management - Position Real Time through a BI Publisher Data Model. …
-
Legislation of Absence Type not visible in dropdown in Time Entry Layout Components taskSummary: How to identify which legislation does the absence type belongs to in the time entry layout components task while selecting absence management type? Content (pl…