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
-
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE… -
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca… -
Compensation Worksheet Approval transactions tables related issuesSummary: Users are trying to extract the data related to Compensation worksheet approval, But we are not getting right result. Getting the same result for different tran…
-
EU Pay transparancySummary: We looking for a report to analyze the pay transparance between genders as requested by EU. Has anyone seen or created a report showing variances in payment per…
-
What role is required to get read and execute access of BIP?Summary: What role is required to get read and execute access of BIP? Below tables are being used in BIP pay_dir_cards_f pdc ,pay_dir_card_definitions_vl ,pay_dir_card_c…
-
In an rtf template the single cell containing image is stretching to next pageSummary: In an rtf template, the single cell containing image is stretching to next page as it is not having any image to display. Whenever , the xml is generating image…
-
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…
-
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …
-
Report requirement- Employee name, Employee ID, Job name, Assignment ID & Assignment start dateSummary: Our client is looking for a report to fetch the columns- Employee name, Employee ID, Job name, Assignment ID & Assignment start date Which seeded report matches…
-
Trying to report on future dated Job code keying and Grade Rate keyingSummary: We're trying to report on future dated Job code keying and Grade Rate keying but can only obtain current effective data. Is there any way to report on future da… -
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t… -
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten… -
OTBI Custom Prompt for Company Fiscal Period, Quarter, and YearSummary: We have a need to report out on our fiscal calendar dates vs. the standard out of box calendar month dates. I was hoping there was a way to set-up our own fisca…
-
Detail of oracle delivered standard reportsSummary: Need details of Oracle delivered standard reports Content (please ensure you mask any confidential information): We have a list of oracle provided standard repo…
-
FYI notifications for withdrawal of absence request part way through approvalsSummary: If an employee withdraws an absence request mid way through an approval cycle (i.e manager has approved but HR has not yet approved) is there a way for Manager …
-
Which tables are used to link the Goal Plan Assignment ID with archived transactions?Summary: Could you please specify which database tables store the Goal Plan Assignment ID? Additionally, which tables are used to establish the relationship between the …
-
Transaction Console - Old Pending Transactions that should be ExpiredSummary: It was recently discovered that there are multiple pending transactions from 2022-2024 in Transaction Console that should have expired (screenshot attached). I …
-
Restrict documents by home/work country; prevent submission if missing.Summary: In Document Records we want to restrict specific documents based on users home country and work location country. When we are creating a document records, there…
-
Which privilege to access per_assignment_secured_list_vHello, I am struggling with the per_assignment_secured_list_v secured view in BI Publisher, as I can't seem to pinpoint the exact duty role that gives the "Report assign…
-
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…