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
-
Which column in OTBI will display if employee is also a manager, We need this in Learning ManagementWhich coloumn in OTBI will display if employee is also a manager, We need this in Learning Managment OTBI reports -
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table… -
BI Publisher report not showing translated reportSummary Template translation as well as XLIF translation not working as expectedContent I have created a BIP report using rtf template. I wanted to test the translation …
-
How can we get "Starting Date in current Job" and "Starting Date in current Grade" in BI analysisContent I have a requirement to get the details in BI analysis that what is the start date in current grade and job.May be this date can be assignment start date when em… -
Master tables and employees transactions tableSummary: Hi, We need to Archive all information of the system so want to know which all Master tables which stored configuration details and which all tables stores empl…
-
An unresolvable error has occured. Please contact your administrator for more InformationSummary: Getting unknown error as "An unresolvable error has occurred. Please contact your administrator for more Information" While clicking on Start Synchronization fo…
-
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid…
-
OTBI - values turning to blank after more columns are addedSummary: I have built a report that combines two subject areas: Compensation - Salary Details Real Time and Payroll - Element Entries History Real Time The report is sho…
-
Adjusted Service Date Behavior During Global TransfersSummary: When an employee undergoes a global transfer from one legal entity to another in HCM, how does the system handle the Adjusted Service Date? Is it carried forwar…
-
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…
-
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… -
Effective end date in PER_MANAGER_HRCHY_DN not updatedSummary: When does effective_end_date in PER_MANAGER_HRCHY_DN gets populated? We are assuming that when an employee is no longer reporting to a manager then effective_en…
-
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 …
-
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…
-
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…
-
BI Publisher Preview Options not enabledSummary: BI Publisher Preview Options are not enabled. Content (please ensure you mask any confidential information): We are trying to update our RTF template and the Pr… -
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…
-
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 Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question…
-
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_… -
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…
-
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…
-
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…
-
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…
-
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 … -
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… -
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 … -
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 …