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
-
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver… -
BIP Report with stacked Bar chart not showing all dataContent Hello, We have created a BIP report with stacked bar chart. But it is not showing all data. I have attached screenshot document here. There is 1 filled requisiti… -
Filtering Workforce Trend Real Time by item in Worker Assignment Real TimeContent Has anyone had success filtering workforce trend real time data by a data point in Worker Assignment Real Time? I want to report on the make up of our officer po…
-
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…
-
SETSTAT is something that isn’t supported by AWS. How to solve?Summary Trying to deposit a file on a FTP but getting errorContent Hello, we need to deposit a file on an FTP of our partner. I'm using Oracle HCM BI. The configuration …
-
Statement of EarningsSummary Subject area for creating an Analysis in OTBIContent I would like to create an analysis using much of the information from the Statement of Earnings but adding m… -
Data Store ElementEntryPVO vs. RetroElementEntry - only one contains ElementEntryDateEarnedContent I have reviewed data lineage HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryPVO and HcmTopModelAnalyticsGlobalAM.HcmBatchProcessCoreAM.RetroElementEn…
-
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected … -
CSV output being generated in a different layoutSummary BI Publisher report tab is not working properly when CVS output is selected.Content Hi Team, Maybe this is a known issue and I getting late aboard. I've added a … -
in Hyperlink translated as %3c?EVALUATION_ID?%3eSummary in Hyperlink translated as %3c?EVALUATION_ID?%3eContent Hi, We are trying to add a hyperlink on BIP report with a EVALUATION_ID. EVAlUATION_ID is translated per… -
Not able to print pdf output after setting pdf security to true in report propertiesSummary Not able to print pdf output after setting pdf security to true in report propertiesContent Hi All, In order to avoid document modification we have set report le…
-
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 452 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106
-
ORC: Employee Referral ReportContent Hello - we would like to report off employee referrals whether an internal employee used the 'Refer a friend' option to invite someone to apply to a req or if th… -
How can we extract requisitions tied other locations data through BIP tables ?Content Hi All, PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUI… -
Department Hierarchy and Department Changes reportingContent I have been working on rolling out a department hierarchy for my company. The hierarchy is complete and working but i am looking at how it interacts with things …
-
.cvs output file is splitting in 2 columns I want it one column only.Content Hi Experts, I have BI Report and I want output as .csv Tab Delimited. I did all setup and when I schedule this report I see output in 2 columns (A & B). I want i…
-
How can we retrieve a effective date data on All Columns in OTBIContent Hi,I have got one requirment that client wants audit data in OTBI analysis.I have tried as of date but it will work for one columns do anyone have any idea more …
-
Aggregate function on ValueSet is not workingSummary Aggregate function on ValueSet is not workingContent I have attached my query containing the where clause which is not working. Even the below value set is not w…
-
Webservice to pull obiee reportSummary Webservice to pull obiee reportContent Hello all, Does anyone know how we can initiate a web service to pull a specific OBIEE report? Or is there a API that can … -
Capture job changeContent Hello there. I want to capture only the job change event, but for example if i change only the job in the transfer section, it captures what is selected in the a…
-
Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateSummary Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateContent Hi experts, I have an excel template ( from a benefits extract) in … -
Adding Grade Min, Mid, Max to a reportSummary Grade ratesContent I want to add Grade Min, Mid and Max to reports but get an error every time I try to add the Workforce Management - Grade Rate Real Time Subje… -
User Manual for adding OTBI report to HR dashboardSummary User Manual for adding OTBI report to HR dashboardContent Hi Team, Can any share user manual/White paper for adding a OTBI report to HR dashboard. Appreciate you…
-
OTBI Reports over Payroll DataSummary We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real TimeContent The OTBI reports tool is struggling to p…
-
Analytics Dashboard section header and report link font formattingContent Hi All, I have embedded dashboard on homepage, which has report hyperlinks and section header displayed. I have managed to change the background color same as ho… -
BI Publisher Bursting Real Time Notification/TriggerSummary BI Publisher Bursting Real Time Notification/TriggerContent Hi experts! I need to create and send an email notification whenever a person has enrolled or complet…
-
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem…
-
Bursting Report With Multiple AttachmentSummary Bursting Report With Multiple AttachmentContent Hi Team We have a requirement to attach multiple document using busting query, How to add multiple attachment in …
-
Timezone used by time parameter is always in GMT. How can I let user pick the timezone when enterinContent I have a BIP report with a parameter with a time component (It is a date type with a date string of" MM-dd-yyyy HH:mm:ss am"). What I am noticing is that date en…