OTBI
Discussion List
-
An OTBI report with mutiple subject area from ERP and HCMSummary: I want to create an OTBI report consisting of Journal header Id, batch id, Journal created by Username, Approval status , rejected by whom(if any), Department t…HarshitBa 11 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
Sample Report: Workforce Compensation Market CompositesSummary: Sample report showing how you can report on market composites within Compensation - Workforce Compensation Real Time Content (please ensure you mask any confide…Gail Langendorf-Oracle 21 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Work Order DFF not visible in OTBI Subject AreaSummary: Work Order DFFs are not visible in OTBI Subject Area We have run the process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" also…
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 217 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
How To Manually Retrieve Database Query for BICC VO Through BI UISummary: How To Manually Retrieve Database Query for BICC VO Through BI UI Followed the steps given in (Doc ID 2513701.1). But when we click on ISSUE SQL getting error C…
-
Operation Status columnSummary: Operation Status column Content (please ensure you mask any confidential information): Hi, On which Manufacturing subject area I can find operation status (Read…Muhammad_Saad 21 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Fusion SQL Linking between GL Transactions and PA to obtain the expenditure item idI have been asked to update a BIP GL report to provide the expenditure item id, should it exist, from projects. I have done lots of searches and some AI. The responses s…Brian Doc 42 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil_Makhiza 490 views 25 comments 0 points Most recent by NeenaS25 Reporting and Analytics for ERP
-
is there way to hide Page Options - Edit dashboard - we have access it through work areaSummary: Dear exports, We have created work area and provided below static url of the dashboard link to access the report. The manger's are able to see the ritNow, the c…Rama123-Oracle 11 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su…
-
How to create custom ESS jobset to run Revaluation rules.Summary: As Part of month end, we are running multiple Revaluation rule, our question is can we group them based on our requirement (Region Wise) and create a custom ESS…Shadaab Ahmed 65 views 2 comments 0 points Most recent by Sheena Floyd General Ledger & Intercompany
-
Procurement PRC DashboardI am looking for the Procurement Dashboard, have seen it in the Oracle demo environment. I am looking to enable it in our environment however I can't find any documentat… -
OTBI Filter Criteriaanalysis result in error when no prompts are selected Errore Errore di visualizzazione della vista Errore durante l'elaborazione della query (SQLExecDirectW). Dettagli e…Rosita Santosuosso 11 views 0 comments 0 points Started by Rosita Santosuosso Reporting and Analytics for HCM
-
Learning related subject areaI need to create report based on these inputs but I am unable to find relevant columns from the learning related subject areas. I am not aware of the proper columns. htt…
-
OTBI Report to bring customer details for misc receipts.Summary: OTBI Report to bring customer name, customer account number , batch number, reference number , receipt status details for miscellaneous receipts. We tried using…
-
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 315 views 7 comments 0 points Most recent by Gillian Kilbride Reporting and Analytics for HCM -
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
Capture AP MetricsTo accurately capture Accounts Payable clerk metrics in a scenario where any clerk can fix or process any invoice, the 'last updated' field is insufficient for identifyi…
-
Set different hyperlinks for different languages with Page ComposerContent Hi all, we have the following problem: We have customized the "Request noncatalog item"-page. Therefor, among other things, we have insterted a hyperlink that re…
-
How to move reports under project modulesSummary: I can find some reports in the project management function of the project management module, but I want to move them to the cost function under the project mana…
-
How to show custom dashboards under Dashboard Header Menu in Oracle Fusion Report & AnalyticsI have created custom dashboard and I want show that dashboard under Dashboard Header Menu as attached Help me how to achieve it. How to add custom dashboard to Existing…
-
V3 Seniority date pulling old assignment detailsSummary: We are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Per…Sreeraj Kavallore Sujith 11 views 2 comments 0 points Most recent by Sreeraj Kavallore Sujith Reporting and Analytics for HCM
-
Help Finding Training "Start Date" Field or Table in Oracle DBWe’re trying to report learner states as Not Started, In Progress, Completed, and Past Due. Currently, we can only show Not Completed, Completed and Past Due reliably. T…
-
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an…
-
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 163 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM