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
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve… -
How to fetch when Auto provsioned roles were revoked from the user in Cloud Fusion HCMSummary: Hi All, We need to fetch details of Auto provisoned roles which were revoked from the user. Basically , the role name and when the auto provisioned role was rev… -
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti… -
Preview Offer didn't show Draft Watermark while previewing the offerSummary: Content (please ensure you mask any confidential information): Dears , I added Draft Watermark to the rtf file and while trying to preview the offer the draft w…
-
Showing Attachments on Notification Worklist for "Request New Position" & "Request Position Change"Hello Community, I'm working with Oracle Cloud HCM and have a question regarding the visibility of attachments on approval notifications in the worklist. My Goal: I want…
-
Draft WaterMark missing while previewingSummary: Content (please ensure you mask any confidential information): Dears , I am working on adding DRAFT watermark on rtf file , it working offline while testing on …
-
Table to get special purpose field of input valueHello, I'd like to know if anyone has an idea on where I can find the field of ''Special Purpose' and its value, whether it's a table or a query would be very helpful. I…
-
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…
-
Canceled report job is still runningSummary: Hi all, We have canceled a report's schedule job but for some reason the report is still being generated and sent to the users. If we check the Manage Report Jo…
-
unable to see the custom manager types in OTBIHi, I'm using 'Workforce Management - Worker Assignment Event Real time' subject area, I've checked the matrix manager dimension as well, but i' don't find any other cus… -
Did Exec Admin Delegation change with the 26C upgradeSummary: Our Exec Admins who have delegation access can no longer schedule check-ins on behalf of our execs. When they log in, as themselves, and go to My Team . Team Ac… -
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log…
-
How retrieve a list of BIP report names and paths that use a specific table name?Summary: How to retrieve a list of BIP report names and paths that use a specific table name? I wanted to know the list of BIP Data models used below benefit tables. Tab… -
per_person_secured_list_v view problemSummary: per_person_secured_list_v view is ignoring past events Content (please ensure you mask any confidential information): Hi, we have an admin user and she should h… -
Enrollment Coverage Through Date in the Benefits subject area is showing 12.31.4712Summary: When creating a open enrollment report for 2026 using Benefits - Enrollments Real time, Enrollment Coverage Through Date is 12/31/4712. Because of that it's sho…
-
Manage Audit Policies -> AUDIT_CHANGE_BIT_MAP_Content Helo, I have activate the audit of assignment object : Navigator > Setup and Maintenance > All Tasks > Name : Manage Audit Policies> Search > Go To task > Audit … -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
which duty roles would give access to BI Publisher Report which queries these tablesHello All, We want to give access to a custom role to a BI Publisher Report that queries these tables: per_periods_of_service ppos , per_assignment_secured_list_v paam ,… -
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…
-
Build BI Pub for Representatives Details InformationHi Everyone, We are currently building a BI Publisher report to retrieve detailed information about Representatives. The report and SQL query work as expected in our Tes… -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…
-
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several …
-
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…
-
OTBI subject area for Document of Records descriptive flexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we created custom fields within document type and we mapped them in OTBI. Where ca… -
Emedded dashboard (through Page Integration) without granting access to CatalogSummary: I need to make a report available to a group of HR users. These users are not HR Specialists per se, meaning they should not be allowed to make changes to perso…
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud … -
How to expose the Context Segment in the OTBI report ?We are using the Descriptive Flexfield "Person Allocated Task Attributes" (Flexfield Code: PER_PERSON_ALLOCATED_TASKS_DFF). This flexfield has Context Sensitive Segments… -
Busting OTBI Myths - Using Agents to BurstContentMyth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase compa…