Reports
Discussion List
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 223 views 8 comments 0 points Most recent by Kundan Kumar17 Reporting and Analytics for HCM -
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 24 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 41 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 48 views 17 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
OTBI to show future effective datesSummary: Hi Community, Please refresh my mind: how to make the OTBI to show future dates from EFF table? Thank you, Alvaro Couto Content (please ensure you mask any conf…Alvaro Couto 17 views 1 comment 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 41 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 3.7K views 13 comments 0 points Most recent by User_SOEJE Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 82 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https… -
Document Category is salary infomration notification issue redwoodwe have DOR with Document Category, which is salary information. For this DOR, we have created a DFF. When employee submits DOR, line manager cannot see DFF values in ap…
-
In Oracle Fusion HCM, eText template with UTF-8 character set converting space to special character.Hi Community, I am facing an issue in eText template with UTF-8 character set, whenever for a field if it has space as a value it's converting space to special character…
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 1.4K views 4 comments 7 points Most recent by Kundan Kumar17 Reporting and Analytics for HCM
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 358 views 5 comments 2 points Most recent by Toni B Reporting and Analytics for HCM -
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…Venkatesan 38 views 2 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…Parag Hiremath 17 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 183 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 81 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple …Julie Searles 32 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 1.1K views 21 comments 1 point Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 13 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
HCM Workflow ReportSummary All HCM transactions current status of the workflow and approval detailsContent Hi, I'm trying to create a report to display all HCM transactions Current status … -
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…