OTBI
Discussion List
-
Query dropship and receiptsSummary: Query dropship and receipts Content (please ensure you mask any confidential information): Hello everyone, I need a query to associate sales order lines with th… -
OTBI dashboard row count limitSummary: I have a dashboard in OTBI that, depending on the user input prompts, may produce more than 500 lines of data. There seems to be a row limit of 500 that I canno…
-
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
Merging Multiple PDF Attachments as Additional Pages in a Single PDF Output BIP ReportI am working on a BI Publisher report in Oracle Fusion and would like to understand whether the following requirement is technically feasible. For an AP Invoice, there m…
-
How to create OTBI Custom Subject AreaSummary: While creating OTBI custom Subject Area, how to know which primary object is for the specific table? Content (please ensure you mask any confidential informatio…
-
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates?Summary: How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates. Content (please ensure you mask any confidential information): To…
-
Restrict line manager access to report on direct reports DOB and Address InformationSummary: Hello, We don't want our line managers to report on their direct reports DOB and Address information. We tried to use data security profiles to restrict access …
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 757 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Parent and Child Assets Appearing on OTBI ReportAn OTBI query was created for Fixed Assets and it's not pulling in newly created assets (parent and child) as long as fields, Asset Book or Major Category, are on the qu…
-
Candidate Extensible Flexfields recruiting for Job Application specific candidate profileSummary: Hello - 26A release the ability to report off Candidate Extensible Flexfields in OTBI subject area - Recruiting - Recruiting Real Time under the Candidate > Can…Shanna Oppenheim 32 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Trade Reference Letter aka Credit Reference Letter - Available?Does Oracle have functionality to generate a trade reference letter aka credit reference letter? If so, from which module? I am not asking about a letter of credit but i…
-
OTBI Reporting Performance issueI am using two subject areas Order Management - fulfilment lines real time & Shipping real time for oracle fusion OTBI report, as per the business requirement, inspite o…Shahid Qureshi 01 17 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM
-
Difference in report outputs in PIMI have a custom report built using SQL based data model, no UI or report level filters. However when I run the report an excel is downloaded with inconsistent report out…Nilesh Jain 2 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…Yasser Ali 62 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
In OTBI's Order Management - Order Headers Real Time, all currency fields are nullSummary: Our customers have a requirement to output a report of the total amount of sales orders in OTBI. At that time, we want to display the currency code along with t…
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 15 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM
-
Assets Descriptive Flexfield history trackingSummary Assets Descriptive Flexfield history trackingContent Can anyone confirm if the Assets Descriptive Flexfield values are history tracked. We have some asset attrib…User_2025-03-08-03-49-56-344 81 views 8 comments 0 points Most recent by Nakul Buradkar-Oracle Maintenance
-
Customization of Purchase Requisition Approval EmailI am currently trying to customize the purchase requisition approval email template. I need to add additional text to the email body and modify the subject line of this …
-
dashboard for CXOSummary: is there any dashboard available by delivered for HR basis of AOR, they can data trends for all modules including core HR , Absence , Talent including learning … -
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…Mohit Gupta-45440 956 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Supply Chain Cost Rollup Real TimeSummary: Customer enabled the Perform Standard Cost Rollup Across Multiple Organizations feature and created supply chain cost rollup enabled cost scenario. A cost rollu…
-
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 44.4K views 97 comments 120 points Most recent by MukeshBabu-Oracle Reporting and Analytics for HCM -
Join GL and RCV_TRANSACTIONS in Fusion/ERP CloudSummary: HI All, We are looking a solution to create a SQL query for BIP report to Drill down Join from GL To RCV_TRANSACTIONS in Fusion/ERP Cloud where JE_Source='Recei…