OTBI
Discussion List
-
Update permission of report with custom roleSummary: We want to limit the visibility of some reports only to specific user roles. We tried to add permission but we are not able to see the custom roles. We can add … -
Which Subject Area is used to access Relationships on Items or ChangesSummary: I am trying to build an Analysis that pulls the relationships of an item or a change. Content (please ensure you mask any confidential information): I am using …
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For …
-
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
Not able to run Transaction register for the duation of one monthSummary: We have 300K transactions per month and OTBI transaction register is not able to pull the data when we execute the report for one month. We are able to get the …Subbareddy Kandala 41 views 4 comments 0 points Most recent by Jill Stanton Receivables & Collections -
Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPASummary Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPAContent We have to give demo to your client on basic understanding o…User_2025-02-10-05-51-05-868 103 views 5 comments 0 points Most recent by Velmurugan Palanisamy Sourcing -
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…User_HRWJI 21 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
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…
-
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 …
-
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 21 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…
-
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 61 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 11 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 74 views 8 comments 0 points Most recent by Nakul Buradkar-Oracle Maintenance