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 57 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 23 views 1 comment 0 points Most recent by Jamie Travis-Leonard Reporting and Analytics for HCM -
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 84 views 2 comments 2 points 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 1 view 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 42 views 0 comments 0 points Started by Krishna Palvadi Reporting & Analytics for Fusion Service -
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.7K 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 556 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 32 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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 594 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… -
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 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 60 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 … -
Requisition Creation Date and Requested Delivery Date in OTBISummary: We are creating an OTBI report using the Procurement – Requisitions Real Time subject area. We need to include the following columns in the report: Requisition …Sudheer Vidiyala 60 views 1 comment 0 points Most recent by Porfirio Benjamin Rodriguez Miguens Purchasing -
BICC Deprecated PVOs for 26CCould you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test en… -
Current Date Agent Set UpSummary: I am using Workforce Assignment Real Time and Workforce Relationship Real Time. An agent provides the data. Because the agent exports rather than pulling the cu… -
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke…Clifford Trett 613 views 1 comment 0 points Most recent by Lydia Jayasingh Reporting and Analytics for HCM -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…Meme 0101 171 views 4 comments 0 points Most recent by Shashi Kant Kumar Reporting and Analytics for HCM -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you … -
bulk Update/Creation of Customer Contact Points (Emails) - FBDI, API, or Spreadsheet?Hello Community, My client requires a way to update customer contact points in bulk, specifically by creating new email addresses for their existing customers. I need to…Patrick Chrabieh 264 views 2 comments 0 points Most recent by David Wright - More4apps Receivables & Collections