OTBI
Discussion List
-
Canceled report job is still runningSummary: Hi all, We have canceled a report's schedule job but for some reason the report is still being generated and sent to the users. If we check the Manage Report Jo…Maria Dantas 40 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Enrollment Coverage Through Date in the Benefits subject area is showing 12.31.4712Summary: When creating a open enrollment report for 2026 using Benefits - Enrollments Real time, Enrollment Coverage Through Date is 12/31/4712. Because of that it's sho…Ramani K 21 views 1 comment 0 points Most recent by Jamie Travis-Leonard Reporting and Analytics for HCM
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…Chanida 24 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Report issue when running Carry Forward Purchase Order Budgetary Control Balances processSummary: Hello we are having issue where not all the reports generate when we kick off the Carry Forward Purchase Order Budgetary Control Balances process. We even tried…
-
Receiving - Purchase Receipts Real Time - Returns no results when adding Amount columnsSummary: In OTBI, when adding in any purchase receipt line columns returns No Results. This has only happened after 24D, any suggestions? We have the correct Warehouse M…Steve Stovell 41 views 2 comments 1 point Most recent by Dkowall-Virtua Reporting and Analytics for SCM
-
Viewing OTBI reports should also need access for ledger /data access setViewing OTBI reports should also need access for ledger /data access set for which data is part of report. For eg: we have two ledgers ABC primary ledger XYZ primary led…Tanguturi Ajay kumar 2 views 1 comment 0 points Most recent by Devesh Tyagi General Ledger & Intercompany
-
Building OTBI security role by Subject Area for Oracle Fusion HCMSummary: We have requirement to build security roles by OTBI subject area. Content (please ensure you mask any confidential information): Looking for step by step instru…Krishna Palvadi 14 views 0 comments 0 points Started by Krishna Palvadi Reporting & Analytics for Fusion Service
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…Rona Jeongco 831 views 15 comments 0 points Most recent by Dkowall-Virtua Reporting and Analytics for ERP
-
P2P Dashboard – Received Quantity Formatting IssueSummary: Received Quantity displays as currency for specific users in the P2P PO Details Dashboard. Content (please ensure you mask any confidential information): Receiv…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.6K views 31 comments 31 points Most recent by Lionel Rajesh Devanbu Reporting and Analytics for ERP -
Time Change Request approval workflow notification. We need to create a custom BI Publisher templateHi Oracle Support Team, I need assistance with the Time Change Request approval workflow notification. We need to create a custom BI Publisher template to display additi…
-
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several …
-
OTBI subject area for Document of Records descriptive flexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we created custom fields within document type and we mapped them in OTBI. Where ca…Valerio Curzi 514 views 7 comments 0 points Most recent by Marlon Castillo Maliglig Reporting and Analytics for HCM -
Emedded dashboard (through Page Integration) without granting access to CatalogSummary: I need to make a report available to a group of HR users. These users are not HR Specialists per se, meaning they should not be allowed to make changes to perso…
-
How to expose the Context Segment in the OTBI report ?We are using the Descriptive Flexfield "Person Allocated Task Attributes" (Flexfield Code: PER_PERSON_ALLOCATED_TASKS_DFF). This flexfield has Context Sensitive Segments…Irfaan Camaloodeen 33 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
SQL query or table for Project Cost Transaction AccountingSummary: Hello, Please help to have query or table to get the accounting details from Project Cost Transaction where we know the transaction number. Content (please ensu…
-
Busting OTBI Myths - Using Agents to BurstContentMyth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase compa…Julian Challenger-Oracle 548 views 19 comments 10 points Most recent by RajGuru66 Reporting and Analytics for HCM -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
PER_EXTRACT_UTILITY performance in reportingSummary: Hi experts, quick question, is PER_EXTRACT_UTILITY faster than querying the actual table in BIP? e.g. we can use get_decoded_lookup to get the Meaning of the lo…
-
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 4 views 4 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary: Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting ru…
-
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 16 views 4 comments 0 points Most recent by Janitha Perera Reporting and Analytics for SCM
-
How can we migrate FRS reports in MYFOLDERSummary: How can we migrate FRS reports in MYFOLDER from one user to Shared folders by other user? As user 1 does not have access to paste the FRS reports to Shared Fold…SwapnilSurange1 42 views 6 comments 0 points Most recent by SwapnilSurange1 Reporting and Analytics for ERP
-
Combining Multiple Manufacturing Subject Areas in OTBISummary: We need to create a single OTBI report by combining data from the Manufacturing – Work Order Performance Real Time and Manufacturing – Work Order Definitions Re…
-
BIP Bursting LimitHi all, Hopefully a very quick one. Is there a limit at all to how many emails can be bursted out of BIP? I can't seem to find any documentation online so wanted to ask …
-
BICC Extract Failures with "Error occurs while calling remote service ADFService11G" after 26CUpdateSummary: We have been experiencing intermittent failures with several BICC extracts following the Oracle Fusion Cloud Applications 26C update. The failures started appea…