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
-
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing … -
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERROR
-
Report for ET Final Payout with 403b deductionWe've been asked by auditors for a report of all terminated employees in 2024 that were paid out 'Earned Time Final Payout' and what was deducted for 403b in those paych…
-
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce … -
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…
-
How to get referral candidates details using BIP reportHi Team, Could anyone give me the sql query for referral candidates details. The report must contain Candidate Number Candidate Name Candidate added into the system date…
-
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,… -
Where are Social Security Wages in OTBI?I'm trying to report on information from W-2s, specifically the Social Security Wages from box 3 in the W-2. Where do we find that information in OTBI, specifically Soci… -
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…
-
transaction administration subject area securityHello experts, we had an report using the subject area Human Capital Management - Transaction Administration Real Time and it dont consider the security of the employees… -
How to adjust the alignment of output messages within the OTBI dashboard reports?Summary: Hi Team, Could you please advise on how to adjust the alignment of output messages within the dashboard reports? I’ve attached a screenshot below for your refer…
-
Need help in Fetching Arrear Balance Value with pay_balance_view_pkg.get_balance_valuesHello Hope everyone is doing well! I need to use the below query to fetch Inception to Date Arrear Balance for Benefits Deductions in a existing BI query, the below quer… -
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …
-
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact… -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…
-
Unable to restrict OTBI data based on legal entitySummary: While attempting to create any OTBI analysis from HCM subject areas, we are encountering an issue where the data is not being limited to a specific legal entity…
-
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer…
-
Performance and Potential box empty for meetingSummary: Content (please ensure you mask any confidential information): Hello experts, we scheduled one meeting for potential and performance and the box names appear in… -
Field Created on in OTBISummary: In which subject area of OTBI HCM can the field created on of an action be found?
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
OTBI reports for talent review doesn't work with custom objectsSummary: Content (please ensure you mask any confidential information): Hello experts, we created OTBI dashboards for talent review and we enabled filter by talent revie…
-
Help needed with OTBI FilteringHi There I have an otbi analysis which is based off on "Workforce Management - Goals Real Time" and i want to filter out some records based off the analysis "Workforce M…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…
-
Only 3 formatting rules from excel template will be used when run the BI reportSummary: In BI Excel template, we define 5 formatting rules When we run the BI report, we can see only 3 rules are using. Is anyone know how to resolve it or it is a bug…
-
Getting error when running OTBISummary: Getting error when running OTBI analysis using Benefits - Person Information Real time Content (please ensure you mask any confidential information): Hi, Gettin…
-
How to filter out Contg Worker in Analysis | Workforce Management-Absence Calendar Details Real TimeSummary: Subject Area: Workforce Management - Absence Calendar Details Real Time Question: How can I filter out/ not include Contingent Workers in Analysis ? System Pers… -
OAC lab not found on Core HR implementer courseSummary: no OAC console as it was previously the case when requesting a lab from worforce structures in the Core HR MyLearn Course Content (please ensure you mask any co…
-
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…