Reports
Discussion List
-
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor…Dena Swanson 37 views 4 comments 0 points Most recent by RaviThejaDarbha Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari…Vamshi Mohan 69 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 107 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…User_2025-02-10-05-51-05-868 18 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP -
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - …User_2025-02-06-08-26-40-838 98 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 21 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
Locate First Names that begin with Blank characterSummary Locate First Names that begin with Blank characterContent Can anyone please advise on the proper Function or CASE statement to use in an OTBI Analysis to locate … -
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M…User_2025-02-05-02-38-04-251 25 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Vacant Position report with Last incumbentSummary Need a vacant position report with last incumbent detailsContent Hi Team I need a vacant position report with last incumbent details in OTBI, can you please let …User_2025-03-07-20-55-01-859 72 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Creating an IfThen() formula based on the selected dimension memberSummary Creating an IfThen() formula based on the selected dimension member in FR Web StudioContent Hi, I am trying to create a dynamic condition in my FR reports based … -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP…
-
How to add employee picture on DashboardContent I can't seem to add the employee picture/image on Dashboard. Can someone assist.
-
Adjust Auto numbering in RTF Template OutputContent We have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is …User_2025-02-05-15-04-32-460 112 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
BIP report needs to pick transactoions from the last successful runSummary BIP report needs to pick transactoions from the last successful runContent All, How to incorporate logic for a BIP report which needs to pick transactions from t…Amarnath 32 views 3 comments 2 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
Employees with Grade ChangesSummary A report that shows grade changes in last 12 monthsContent Hi How can I set up a report to identify a person who has changed its Grade on the last 12 months? Doe…User_2025-02-05-22-44-35-842 68 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859 Reporting and Analytics for HCM
-
PPM |Perform action from Dashboard | Send time card reminderSummary How we can perform action from dashboard Content In PPM dashboards option is available to perform actions from the dashboard. Just take the example of Missing Ti… -
Can I use text in IFTHEN function?Content I am trying to apply following formula in oracle but it does not work. it seems that we can't use text (or anything in quotation mark) as an argument in IfThen f…User_2025-02-10-15-49-56-251 47 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to…Sowdha Murugan 39 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Date Prompts with Italian InterfaceSummary Invalid Date format when using a date prompt in ItalianContent Hello! I've recently encountered a new problem and I'm hopeful that someone out there has figured …Rob F 27 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM -
Pivot Table helpSummary Trying to split two values in pivot tableContent Hi, I am trying to get my pivot table to show the sum of all National & International contracts by Business Unit…User_2025-02-05-22-44-35-842 37 views 3 comments 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Editing Delivered DashboardSummary Trying to edit the delivered Line Manger Dashboard but received error on saveContent Hi, I am trying to edit the delivered Line Manager Dashboard, I want to upda… -
When creating a dashboard how to you not show the refresh optionContent I am creating a dashboard and depending on the prompt values some of my reports that are in the dashboard sections don't have any information to display. I have …Mario B 25 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Prompted Bar Graphs for custom fields with case statementsSummary Prompted Bar Graphs for custom fields with case statementsContent We have a bar graph with a couple of custom fields derived using case statements. The fields on…User_2025-02-10-08-27-16-805 25 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Creating new Employee report with Expense Account InformationSummary What is the field and record to pull in the Employee Expense Account InformationContent We are building a new employee report and have a requirement to add the '…Jennifer Wolfe 41 views 4 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
How to fetch the Locked accounts of active employees in security consoleContent At present in the system, there is no table to fetch the active accounts which are all locked in security console. Kindly let me know is there is any table or qu… -
Data level security on OTBI reportSummary Can we apply data level security on OTBI reportContent Hello Everyone, Can we able to apply a data level security on OTBI report such as applying logic on data e…VarunG 59 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report running for everSummary Existing BIP report is running for ever with recent upgradeContent Hello Everyone, We have report which was running fine without any issues for 5 hours now with …