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
-
Help on finding out the right PVOs...Hi, I'm trying to pull HCM data through data augmentation (FDI) and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax … -
How to correctly write a BIP query in the OAC environmentSummary: Obtain the value list of launch parameters in a BIP report on the OAC environment Content (please ensure you mask any confidential information): Hi when I write…
-
Is CRC32 function supported by Oracle fuion BISummary: Is CRC32 function supported by Oracle fuion BI Content (please ensure you mask any confidential information): Version (include the version you are using, if app…
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…
-
Need to add Adjustments and Absences in two different columns. Please hep me with the querySummary: Hi Folks, I need to add Adjustments in one column and Absences in one column in the report in Absence Management. Please help me with the query. Content (please…
-
Employees on Leave - Retrieving Assignment Dates for Old Reason CodesSummary: We are trying to create a report that has all employees who are on leave with the date they went out on leave. However, in OTBI if a change is made to an employ…
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
How to get the Top-Down Manager Hierarchy in OTBI expect CEO,remining Top down 3 Manager hierarchy.Summary: Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports like from CEO to employee Top level manager hierarchy to fetch in to the…
-
Require to fetch Roles and Data Access assigned to employees for BIP report in Oracle HCMSummary: Staff List by System Role Report Content (please ensure you mask any confidential information): Where do I find these fields - Data Access Permissions, Data Acc…
-
Recruiting - Recruiting Real Time not showing jobs with 0 applicationsSummary: Content (please ensure you mask any confidential information): Hi all, I am trying to build an analysis using the subject area "Recruiting - Recruiting Real Tim… -
What is OTBI field name that shows responses under ''Additional Comment'' boxSummary: When we create a questionnaire, under each question, you can enable ''allow additional comment'' box. I did for all questions, however I could not find that fie… -
Report on Career AmbassadorHi, is there any Oracle HCM table available to report employees who signed up for Career Ambassador? -
OTBI Analysis: only select worker records if primary assignment in hierarchySummary: I’m developing a performance document status report for managers, to be ran on self-service basis. I don’t want any records retrieved for a manager unless worke…
-
Adding a Common Sequence to Filename in Bursting Report Triggered via ESS JobHi everyone, I'm working on a bursting report in Oracle that generates filenames with a date and timestamp, like Grade_01012024_928282.csv. I have two different reports …
-
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank … -
Query to get interview details for a job requisition using BI ReportSummary: Hello Team, I am trying to get interviewer details (Interviewer person number and email address) using below query but I am not getting the right results. Can a…
-
SQL to Get Grade and Grade and Grade Step details on a assignmentSummary: Hello Everyone, I'm new to SQL query building. Just getting hands on it. I am trying to create a Data model that will return salary detail including Grade and G…
-
Some of reports when we try to download the report we are getting processing errorSummary: HI Team, Some of reports when we try to download the report we are getting processing error . Export>Data>CSV or Excel Content (please ensure you mask any confi… -
OTBI error - Error during query processingSummary: We have an OTBI report, pulling from 2 subject areas — Workforce Management - Work Relationship Real Time and Workforce Management - Person Real Time. Our HR us…
-
SQL query to find the Users that has role provisioned by an role mappingI'm trying to create a query that return the MAPPING_NAME from the PER_ROLE_MAPPINGS table and the USER_ID from the PER_USER_ROLES table to know which USER_ID is associa… -
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'Summary: Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each em… -
How to disable Export -> Data in selected OTBI reports?Summary: Hello, Do you know how to disable Export -> Data in selected OTBI reports? When user clicks Export -> Formatted -> Excel, the report contains only columns that … -
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I assigned the cost center code at the Person Costing level to an Assignment.Summary: I assigned the cost center code at the Person Costing level to an Assignment. I need to pull the OTBI report with the effective start date and End date. Can I k…
-
Accrual Report / "Time.Month" Formula / report formatingI'm building an OTBI report to based on Accrual Real time subject area, with the goal of displaying accrual balances. To have a report that makes sense I used Pivot Tabl…