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
-
Need Help : 9 BOX Talent ReviewContent Hi Expets, I have been looking catlog or some kind of link form which we can build or design 9 BOX Talent Review. Tried in different sources and not able to find… -
Date and Time Generated in an OTBI Report or Dashboard with No ResultsContent Hi there, We have a few OTBI Analyses that are combined into a Dashboard and the Dashboard is then scheduled to be emailed on a bi-weekly basis. The ask is to in…
-
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…
-
SQL to Pull Most Current Ethnicity recordSummary Looking for BIP Data Model that will select the most current EthnicityContent Hi, I am creating a data model of person information and have been challenged when … -
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an…
-
Tile in Fusion for Managers to directly take them to their Manager ReportsContent We are trying to figure out if it is possible to create a tile in Fusion for anyone with a Manager role to have a tile to take them to our Manager Reports folder… -
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab…
-
Retrieving Affected Party column in HRHDContent Sharing the data model for reference and for others to benefit. This column was unavailable in OTBI at the time the report was built.
-
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)…
-
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, Vijay
-
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…
-
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank You
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo…
-
Bank Account UpdatesContent I was wondering if anyone had a report that was able to pick up changes to bank account information? We currently have a report that pulls the last update date o…User_2025-01-31-00-25-12-234 133 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want … -
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…
-
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, Vijay
-
OTBI ReportsSummary CURRENT DATE formulaContent We are in the process of converting to Oracle so I am new to writing OTBI reports. I have tried the following formulas and get errors… -
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular …
-
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We…
-
Formula to add 30 days to a date fieldContent Is there a formula that can take a date field and add 30 days to it? Version 21A -
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there… -
Role security not being enforced on dashboard promptContent I am using "Workforce Profiles - Person Profile Real Time" to create a list of employee certifications by manger (direct and indirect). The "Matrix Manager"."Top…User_2025-01-23-21-24-21-434 23 views 4 comments 0 points Most recent by User_2025-01-23-21-24-21-434
-
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop…
-
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 39 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242
-
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…
-
Finding the actual performance document managerSummary Would like to find the document manager of the performance evaluationContent Dear All, We have created the OTBI analysis through Performance Document Status Real…Janaki Ramana Reddy Vayyala 57 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil… -
Drill down report not showing up for a specific userSummary Drill down report not showing up for a specific userContent For viewing the Drill down report does the user need any special security? The user can able to see t…