OTBI
Discussion List
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 6K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP -
Date between effective start date and effective end dateI am trying to create an otbi report on element entries historical subject area. I have to create a date filter condition in such a way so that it will ask a date from t…Neelotpal01 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can we configure the date picker parameter in an ESS job to show JST instead of the default UTC?Summary: We have an ESS job where the 'Territory' is set to Japan, and the 'Time Zone' is set to (UTC+09:00) Tokyo – Japan Time (JT) in the Process Options. However, in …
-
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…Patrick Turcotte 91 views 9 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Is there a field in OTBI that shows who initiated a Movement Request Transfer?Summary: I would like to create an OTBI analysis for Transaction Type = Movement Request Transfer that includes the user who initiated the request. In Manage Movement Re…Kathleen Fletcher 11 views 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management -
OTBI - invoice life cycle detailsSummary: Is it possible to add the Order Life Cycle details to an OTBI analysis? Content (please ensure you mask any confidential information): We have created OTBI anal… -
Unable to remove datastore from Offering in BICCSummary: BICC, Unable to remove the existing PVO from the offering Content (please ensure you mask any confidential information): Version (include the version you are us…Dinesh K89 1 view 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management
-
Facing issue with BICC PVO extractionSummary: We have Configured Fivetran to pull data from Fusion to Fabric. However, when we try to sync after enabling the PVO ItemEFFBPackaging__InformationPublicVO and t…
-
How to create a report in OTBI of Manage Payment Process Requests informationSummary: The customer needs to have the information regarding the related invoices in a payment batch. Content (please ensure you mask any confidential information): I a…SERGIO BARRETO 81 views 3 comments 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management -
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there Report of expenses showing all transactions in all statuses?Summary: User is looking for is a report of expenses (all status e.g. not approved) at the end of the month in the Fusion Expense Module that have not been processed thr…
-
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …Emily Wilde 231 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r…bobby.hussey 271 views 10 comments 0 points Most recent by Florence Z Reporting and Analytics for ERP -
Linking Redwood SP to Existing Courses and Impact on ReportingHi everyone, We are exploring the new Self-Paced Learning Redwood Experience page and I’m trying to understand how it works in relation to existing courses. Currently, m… -
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…User_2025-03-07-18-57-57-349 918 views 4 comments 2 points Most recent by Robert A Reporting and Analytics for ERP
-
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…JMLMIII 31 views 10 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
How a requisition approver can see all the approved requestion by himSummary: How a requisition approver can see all the approved requestion by him Content (please ensure you mask any confidential information): How a requisition approver …Tapas_Sathua 31 views 4 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement -
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…
-
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… -
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 710 views 3 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 133 views 8 comments 0 points Most recent by ganesh_b-Oracle Reporting and Analytics for HCM
-
OTBI delimit data from 1 column into multiple columnsSummary: We have a report requirement where we want to delimit output from 1 column into multiple columns based on '/' delimiter Content (please ensure you mask any conf… -
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 41 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany