OTBI
Discussion List
-
OTBI analysis with date prompt pulling duplicate recordsSummary OTBI analysis with date prompt pulling duplicate recordsContent Hello, I was hoping to get some help with fixing my OTBI Analysis report that is pulling duplicat…User_2025-02-04-15-06-22-759 220 views 7 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 506 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,… -
DFF in RTF for GoalsContent Hello, I created 4 DFFs in Goal Details page and would like to include them in the RTF. However i don't see them in the xml output to use in while editing the RT…PriyaPenugonda-SC 49 views 13 comments 1 point Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
OTBI reporting on Areas of ResponsibilitySummary OTBI reporting on Areas of ResponsibilityContent I've not seen any recent posts on this so hoping there is some good news out there! Has anyone figured out how t…User_2025-02-04-10-43-02-447 138 views 6 comments 4 points Most recent by User_2025-01-29-02-58-08-021 Reporting and Analytics for HCM -
Logical SQL Error - OTBISummary When attempting to create a new Analysis using simple Logical SQLContent I am attempting to create a new analysis using the logical SQL below; however, whenever … -
Remove from an LC dateSummary I need to report on when someone was removed form an LCContent Can someone help me find the date a user was removed form a LC? I assumed that it would be a stand… -
How to change the default item attribute value at master levelSummary How to change the default item attribute value at master levelContent Hi, When we are creating items few item attribute values are defaulting from master level. … -
Unable to view all item attributes under specification tab in manage itemsSummary Unable to view all item attributes under specification tab in manage itemsContent Unable to view all item attributes under specification tab in manage itemsI hav… -
OTBI: Receivables - Transactions Real Time Subject AreaSummary OTBI: Receivables - Transactions Real Time Subject Area don't show collectionsContent I am trying to develop a report on this subject area to show the customer a…M.Adnan.Ansari 92 views 5 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
How to bring citizenship and nationily in analaysis?Summary Creating a termination Report using subject area Workforce Management:Worker Assignment Event Real TimeContent Creating Analysis in OTBI using subject area Workf…User_2025-01-29-18-45-19-617 26 views 11 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Unable to view all item attributes under specification tab in manage itemsSummary Unable to view all item attributes under specification tab in manage itemsContent I have created few items but I am not able to view few attribute values through… -
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…[Deleted User] 1.1K views 11 comments 2 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
How to hide "Release" and "Release and Pick Materials" using role customizationSummary How to hide "Release" and "Release and Pick Materials" using role customizationContent Hi all, We have requirement like some users need to create work orders and… -
Allow Employee role to view data other than own record in OTBISummary Any approach that allows custom Employee role to view records other than own data in OTBI reportsContent Hi, We have a situation wherein we have embedded an OTBI…Kalyan Amaravathi 491 views 3 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
PO and Invoice Amount - OTBISummary Need to show PO and Invoice Amount in a reportContent Hello - I have a requirement to show the Invoice Amount and PO Approved amount in the same report. I can se…Hari Thyagaraj 108 views 6 comments 0 points Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP -
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B -
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea… -
OBI - Cant view all employees in resultsSummary OBI - Cant view all employees in resultsContent Have a Custom HR data role with view all persons and view all everything else. This role also has Workforce Trans…User_2025-02-05-07-31-11-275 35 views 7 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
5 year history report for Salary + Element entriesSummary 5 year history report for Salary + Element entriesContent I am looking for an OTBI report to capture past 5 years details of salary along with element entries. b…User_2025-01-25-04-02-13-126 99 views 14 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
ERISA report or Form 5500Content Hi, Does anyone have any information about Form 5500 or if it's available ootb in our HCM Solution? Thanks,Dishti Malhotra-Oracle 29 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…Mukund Kudrimoti-144443 27 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Person Real Time - Contact Phone and Contact AddressesSummary Why don't Contact Phones and Addresses appear?Content Hello Experts, I've created an analysis where I'm prompting for the Person number and we've found that we a…Rob F 34 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Project Reporting - ForecastsSummary Unable to locate any measures that relate to past versions of forecasts in OTBIContent Hi, I am in then process of building an in-year expenditure/budget/forecas…StuartHibbert 117 views 1 comment 0 points Most recent by User10772173-Oracle Reporting and Analytics for ERP -
Manager Email AddressSummary I need to know how to add a field which includes manager's email addressesContent Using the Expense - Expense Transactions Real Time subject area, I need to add …User_2025-02-04-18-47-46-124 57 views 1 comment 3 points Most recent by Aaron Leggett Reporting and Analytics for ERP -
Process Manufacturing Implementation / Support Documents.Summary Process Manufacturing Implementation / Support Documents.Content Hi all, Please share "Process Manufacturing Implementation / Support Documents". Thanks, Dev Tho…