Reports
Discussion List
-
Create a report that shows the actual date when the assignment status changed with the Action ReasonSummary Actual date and reason when an assignment status changesContent Hi All, I hope someone is able to help me with a SQL that I am trying to build. I have several re…User_2025-02-04-08-51-08-912 269 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
NR Datasource Creation with EPBCS (Traditional Account vs OCI Gen 2)Content Hello All, Please note that there seems to be a difference in the definition for creating a datasource in the narrative reporting with EPBCS (Traditional Account…Sandeep Hardikar N S 26 views 3 comments 0 points Most recent by Sandeep Hardikar N S Narrative Reporting -
Payroll Pay Affecting changes reportSummary Payroll Pay Affecting changes reportContent Hello, I am in process of creating the Payroll Pay affecting changes report and wanted to know if any one has come ac…Dharmendra Jha 46 views 2 comments 0 points Most recent by Dharmendra Jha Reporting and Analytics for HCM -
Required User Entity (HCM Extract) for StateSummary User Entity (HCM Extract) for US StateContent Hi All, Please provide user entity details in HCM extract for pulling the details of US state. Thanks -
Viewing secured views for Oracle delivered reportsContent I am reviewing some of our delivered reports and am noticing what I believe to be an issue with our secured views. Specifically, I noticed that users can see the…Evan Lehrhoff 30 views 3 comments 0 points Most recent by Evan Lehrhoff Reporting and Analytics for HCM
-
Report that pulls out the extract runSummary Do you have a report ready?Content Hello, I need to develop a report that pulls out the extract run in a specific date. Do you have something ready? Thanks Nicol…
-
Is there any possibility to create dynamic password protect for excel in Oracle HCM BI reports ?Summary Is there any possibility to create dynamic password protect for excel in Oracle HCM BI reports ?Content Hello Team, Is there any possibility to create dynamic pa… -
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…Aja Nealley 44 views 5 comments 2 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…Robinson Antunez 49 views 3 comments 0 points Most recent by Robinson Antunez Reporting and Analytics for ERP
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 1K views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 1K views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 44 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Combine Data tables in Data model as one similar to Union AllSummary Is there a way to combine tables in the Data Model which is similar to Union All? For example creating another table where they call all the table in the Data Mo…Mark kristan De los Reyes 36 views 4 comments 1 point Most recent by Denise Izzi Reporting and Analytics for HCM -
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip …GauravGupta39 723 views 2 comments 0 points Most recent by Priyanka More-Oracle Reporting and Analytics for HCM
-
Training Needs AnalysisContent Anyone can share the Training Needs Analysis samples report developed in Oracle HCM?Chris Ding 167 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Passing a Dashboard Variable to all BI reports on dashboardSummary Passing a Dashboard Variable to all BI reports on dashboardContent Hi All, I am preparing a dashboard to show multiple charts / reports embedded. I would like to…
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi ExpertsSelect LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. B… -
Address Audit ReportSummary Looking for a report with employee address changesContent Hi, Does anyone have a report that shows all address changes for an employee? Would want to see before …
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 23 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
Export User/Provisioning from IDCSSummary Need a report to expor current user provisioningContent Hello, we are in OCI GEN 2 and i'm looking for a report to run in IDCS to export the current status of us…Emanuele Panichi 28 views 1 comment 0 points Most recent by Kalimuthu V GSC-Oracle Identity and Access Management
-
Fusion HCM BIP report completed with errorSummary Fusion HCM BIP report completed with errorContent Hi Everyone, When attempting to run a fusion hcm BIP report Online (not schedule) the following error occurs. E…Dhanuka Chamal 496 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b…User_2025-01-25-03-46-43-745 296 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a…
-
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…User_2025-02-11-08-39-07-186 48 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
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…Ananya Sadhukhan 49 views 2 comments 0 points Most recent by Ananya Sadhukhan Reporting and Analytics for HCM