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
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t… -
Need Guidance on Mapping Employee Numbers in OTBI Expense-to-Payables ReportingSummary: We have developed an OTBI report using the Payables subject area to retrieve invoices imported from Expenses and to track the payment status of those expense-re… -
Is there a way to trigger an atom feed event when using spreadsheet loader?Summary: When we do position updates via Spreadsheet loader, there doesn't seem to be an atom feed event triggered. Is there a way to achieve that? Content (please ensur…
-
Reporting on Transaction Actions and ReasonsHello experts, Im trying to build a report that can capture the Action and Action Reason from the transactions submitted by the HR team using the normal tables (hrc_txn_… -
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, …
-
Looking for Primary flag for phone number in HCMIn HCM, I am trying to add a flag for "Primary" phone number in a BIP report. I didn't see the flag as a field in the per_phones table. Is there another table that I can…
-
HCM Extract Delivery via emailSummary Attempting to send a extract via BI report in emailContent We have an extract setup that uses Bi to deliver the data in a report. In the extract, we are able to …
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great… -
Oracle Recruiting Cloud – Talent and Candidate Pool (Pool entry date)Summary: Hi Experts, We urgently need Global Talent Pool and Candidate Pools reporting in Oracle Recruiting Cloud (ORC) to meet business demands. I would appreciate clar…
-
BI Publisher eText (Fixed Position) Number formatting issue.Summary: Hi everyone, I’m working on a BI Publisher eText template (fixed-position layout). I have a column that must display an amount as a 13‑character, left‑padded nu… -
TRC Code in Time cardsSummary: Can you please suggest how to get the TRC codes associated with the time card and the identifier field.
-
Employment contracts - Audit missing action code fieldSummary: Hi experts, we are trying to add the field "Action code" as selected attribute in the audit for the Worker Employment Contract business object but it seems it i…
-
OTBI To fetch the Requisition NumbersSummary: I have a requirement to fetch the Recruitment Number & Recruiter Full Name . The Subject Areas used ( Individually) 1. Recruiting - Recruiting Real Time 2. Recr… -
Old value of Seniority Date doesn't appear in the report.Summary: Hi, We are building a BI Publisher report to track changes in different attributes in the system alongside Seniority Dates. So while we perform changes in that …
-
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know…
-
Which table stores the Action Reason for salary?Summary: It doesn't seem the per_all_assignments_m but some other pay_* table, any idea? Content (please ensure you mask any confidential information): Version (include … -
How to Prevent Spacing between unmet conditions?Summary: I am currently in the process of consolidating multiple offer letters into a single document. Within this composite offer letter, I've included several sequenti…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…
-
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…
-
I want to check any report available which give the Org Chart data.Summary: We have requirement to fetch the Org Chart data from BI report. So is there any report available which give this data. Navigation : Me → Connection → Search Emp…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development… -
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl… -
BI Publisher Report - Prompt IssueSummary The drop down list for selecting criteria will not wipe cleanContent Hi, Everytime someone opens this report the Business Unit, Package Type, Legal Entity and Lo… -
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…
-
Employee is not available in Responsive UI but can access only via Person ManagementSummary: ADT | EE#321204 not exist in Employment info & Seniority Date pages, but available in Classic UI, we can able to access the employee in Classic UI (From Person …
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…
-
Extract instances of overrides in time cardsHi all, I would like to extract or get the number of overrides per timecard of an employee. The new Redwood layout for time cards is so confusing to me, in this example … -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…
-
How to customize "No Data Found" message in BI Publisher Interactive ReportsSummary: Customize the message "No data Found" in BIP Reports (Interactive Layout) Content (please ensure you mask any confidential information): Hello experts, I am loo…