Category 174
Discussion List
-
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… -
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 44 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
Does anybody know why fields are not available to be shown on template for data modelSummary: Does anybody know why the data model may be correctly reading my 2 fields (source_document_id, txn_qty) but they are not listed in fields available in current d…
-
Inventory Transaction Detail BIP Report-30 Columns-Item with Serial Control Enabled-65K LimitationSummary: Hi Everyone, We have a requirement from business to build BIP report for the Inventory transactions which they track manually at present. There are around 30 co…
-
Need to validate why the value is differing from ERP in TableHi, At the table level, for item SU103216, we are seeing the inverse usage rate value as 1000000000, with a last update timestamp of 2025-05-19T10:33:22.169+00:00. Howev…
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 25B…Ramamurthy Shankarachetty-Oracle 16.4K views 54 comments 43 points Most recent by Kirk Li Reporting and Analytics for SCM
-
not able to locate any PVOs that expose the DFFs for Transfer Order Header and LineSummary: In the 25B release, I’m trying to create a BICC data extract job for Transfer Order Headers and Transfer Order Lines, including their Descriptive Flexfields (DF…
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…Sai Revanth 208 views 5 comments 0 points Most recent by Maheshwari_Saurabh Reporting and Analytics for SCM
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas… -
Are Sourcing Rules (Table MSC_SR_ASSIGNMENTS) available in BICC?Summary: Which is the right PVO / Dataset to use for this in BICC Offering setup? Content (please ensure you mask any confidential information): We need to extract Sourc…Frank.Steinjan 19 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for SCM
-
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…
-
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…
-
How can I use the item keyword as a parameter in a BI Publisher reportSummary: I want to allow users to search the BI Publisher report by any word within the item description. Currently, the parameter for item description limits LOV to 30 …
-
Conversion UOM columns From and To Code from INV_UOM_CLASS_CONVERSIONS Showing Interchanged ValuesHi, I have observed an interchanged outputs in column- FROM_UOM_CODE, TO_UOM_CODE in table INV_UOM_CLASS_CONVERSIONS. What could've been the cause of this? Regards, Mika
-
Where is Source Reference stored in the Review Completed Txns screen?Summary: In the Review Completed Transactions screen we have a ‘Source Reference’ column. I am unable to understand where this is stored in the sql base tables. Content …
-
LOV Parameter Disabled When Using Full Item DescriptionSummary: I'm working on a BI Publisher report in Oracle Fusion where I want to use item description as a parameter. The parameter is based on a List of Values (LOV) from…
-
Which Oracle table is used to store the valueProduct Line Description under Product Line InformationSummary: Hi @everyone Can anyone have any idea that which Oracle table is used to store the exact value of below Product Line Information in the backend and how it shoul… -
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…
-
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …Khalid Aldosari-Oracle 76 views 2 comments 0 points Most recent by Walter Spinelli Reporting and Analytics for SCM
-
Error response during RestAction in Awaiting Putaway ScreenSummary: Unable to do Putaway in Received Lines task and error message pops up "Error response during RestAction" Content (please ensure you mask any confidential inform…
-
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 450 views 4 comments 0 points Most recent by JGutierrezM Reporting and Analytics for SCM
-
Need the base table/Query to extract the number of Open Production Exceptions in Work ExecutionSummary: Need the base table to understand the list of Open Production Exceptions in the Work Execution > Manage Production Exceptions Content (please ensure you mask an…Vignesh Subramanian 11 views 0 comments 0 points Started by Vignesh Subramanian Reporting and Analytics for SCM -
PVO - BICC For Customer Address - Party, Account, SiteSummary: Hello, We are trying to find the PVO for Customer Address for Party, Account and Site in below and looks like one is not available. Can some one please confirm …
-
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…Deepthi Suravaram 141 views 20 comments 0 points Most recent by Sumit Patil Reporting and Analytics for SCM
-
Scheduled BIP Report not Working post update to Recipients listSummary: A BIP report Scheduled to run once a week, made changes to the recipients list and observed the changes were not reflected in the next run, means recipient's li…
-
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …
-
Issue with HTML Tags in Excel Output from Oracle Fusion BIP ReportWe are encountering an issue in Oracle Fusion where HTML tags are appearing in the Excel output of a BIP report. This problem was observed during the creation of an RFQ …Venkatesh Babu Somalinga 12 views 2 comments 0 points Most recent by Venkatesh Babu Somalinga Reporting and Analytics for SCM
-
Maintenance Work Order Cost OTBI Subject AreaWhere can i find Subject Area for Maintenance Work Order Cost, I am using Costing Subject area but it only shows Manufacturing Work orders. Please help
-
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma…