OTBI
Discussion List
-
Retrieving Enrollment Questionnaire DataSummary: We're configuring a learner enrollment questionnaire to obtain event registration information (e.g., name, DOB, travel information, allergens, etc.) I created t… -
OTBI report looks different when opening from ERPOTBI report looks different when opening from ERP than when opening it from OTBI. I want it to look like in ERP, but I do not understand why it will not do this. The fie… -
Remove duplicates in an OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, I have a table that include several completions of a course by the same person. I want … -
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How can I report via OTBI on 'Source' field in Payables - Transactions Real Time?Summary: We have a request from the Business to include 'Source' field in a dashboard utilising Payables - Transactions Real Time. We've used the Invoice Source Code in …Fiona Marran 1 view 0 comments 0 points Started by Fiona Marran Payables, Payments & Cash Management
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 376 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
REDWOOD: Descriptive Flex Fields for Learning Request are not appearing on Approval WorkflowsSummary: Hi there, Currently we have DFFs set up on our Supported Study Course Offerings (Qualification for Role and Study Assistance courses). Since 24D was applied and…
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Report on Messages sent to Candidates using a message templateSummary: Content (required): I'm looking to report on Email messages sent to candidates who've submitted a job application. Any thoughts on which subject area/dimension …Susan Anderson 82 views 5 comments 2 points Most recent by User_JI4P7 Reporting and Analytics for HCM -
How to Enable the "Primary Project Manager" in manage project resource using API or FBDISummary: Hi I create project resource (project manager) using Import Project Enterprise Resources FBDI. But, the imported resource is not imported as primary project man…
-
I would like to customize the standard OTBI Trial Balance report in Oracle Fusion to meet our specifI would like to customize the standard OTBI Trial Balance report in Oracle Fusion to meet our specific reporting requirements. I am not sure about the exact steps involv…Puran Joshi 43 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
where to add parameter effective date conditions to OTBIHi All, Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date para… -
Where in BI can I find fixed data of a marked for released order—item, qty, date, org, source org?Summary: Once a planned order has been marked for release, how can I find these information in a BI table? I would expect to find the order details—item, quantity, organ…C:BRANCHI 11 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
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 279 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 924 views 4 comments 2 points Most recent by Robert A Reporting and Analytics for ERP