Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…
-
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …
-
Transaction Approvers Comments ReportSummary I am preparing a report to fetch Transaction details along with Approver comments which we can see in Transaction console.Content Hi Team, I am facing a problem …
-
BIP Report to get Employees with Bank Accounts not assigned in a Payment MethodSummary: Hello everyone, I am trying to create a report where I want to get a list of employees who have bank accounts that are not tied to any Personal Payment Method. …
-
Can we change the Date format to Text in OTBISummary Can we change the Date format to Text in OTBIContent Hi I would like to know to know if we can use any of the functions in OTBI to change the date format to Text…
-
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…
-
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…
-
BIP report date format is not working in Dashboard promptsContent Hi All, I have created a BIP report with date parameter and it is working fine. When I tried to apply dashboard column prompts on the same report data is not fet…
-
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a…
-
Approval Path- Info is locked- Recruiting.Summary: Is there a way to see the approval flow on pending requisitions. Right now, only the person who submitted it is able to see where it is in the approval path, No…
-
REQUISITION_POSTED State Code Giving Strange ResultsHello, I have a need to find the most recent date a requisition was posted and unposted. For compliance purposes, we need to ensure our jobs are being posted for a minim…
-
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…
-
How to edit and disable delivery option of Oracle HCM Fusion HCM Extract in 24BWe would like to disable the delivery option of HCM Extract and edit one of the Data group filter in 24B. As we do not have Advance edit option enable.
-
Identify Hire Dates that are any date in the Next WeekSummary: I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE…
-
User Role Membership Report SQL Query / TablesSummary: Hi Team, for audit purposes customer is requesting to know which tables/views at db level are being used to extract the seeded report "User Role Membership Repo…
-
Migration of Fast Formula, Lookup, UDT in bulk from one instance to another.I am migrating Fast Formula, Lookups, UDTS from one instance to another in bulk, what we need to select under deployment method while creating task, please suggest?
-
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc.
-
No Results custom message not updatedSummary: No Results custom message not updated. Design Sample: Parameter selected: Absence Type parameter selected = Purchase Day. No Results message expected to be prin…
-
New/Pending approval/requires approval goals in the tableContent Hi Team, We were able to get the details of the new/pending approval/requires approval from the table HRG_GOALS . In 20B we are not able to find the same. Is the…
-
Line Manager Hierarchy with Active/Inactive employeesContent I am looking for a BIP report which shows all the active/inactive employees to a Line Manager Hierarchy. When Manager run the report then they can see all the ac…
-
Where in OTBI subject areas can I find the actual start date of an assignment?Summary When trying to find the start date of an assignment, I can only find all actions related to the assignment. How to show only the actual starting date of the assi…
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…
-
Moved: OTBI Dashboard - Integrate BIP Report and Date Dashboard PromptThis discussion has been moved.
-
Multiple School Districts and Multiple Cities per GeocodeSummary: When trying to build an OTBI Data Model for Tax Withholding, we are finding multiple cities in a Geocode (HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS), and multipl…
-
Repeating RowsSummary: I am creating a report that will show job requisitions, the candidates who applied along with their education and previous employment information. Due to multip…
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…
-
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr …
-
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…