Category 174-2
Discussion List
-
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… -
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 17K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
Change order that is cancelled is still counting as a change orderSummary: Change order that is cancelled is still counting as a change order. Is this is the standard Oracle functionality. If we cancel the change order and create new o…
-
Column for reject/return reason for PO/ Requisition in OTBI Subject AreasSummary: Column for reject/return reason for PO/ Requisition in OTBI Subject Areas Content (please ensure you mask any confidential information): Hi Team, We are searchi…Nidhi Chhajed 1 view 1 comment 0 points Most recent by Nidhi Chhajed 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… -
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
-
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…
-
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 92 views 2 comments 0 points Most recent by Walter Spinelli 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 -
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
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 …
-
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… -
Is there a function accepted in OTBI to print FIRST ROW of values?Summary: Summary: I would like to Print all Invited Suppliers and selected Sites with site adress and site email but if Contact is blank in Negociation, only print first…
-
Unable to find PartySiteID received in EDI850 payload in backend CML Log tables for CMK Errors.We have a requirement to display the 'PartySiteId' and 'AccountSiteUseId' fields—present in the Purchase Order Inbound EDI payload—in the Custom EDI850 Error Report when…Manish Maheshwari 11 views 2 comments 0 points Most recent by Manish Maheshwari Reporting and Analytics for SCM
-
Help Needed: Average Costing Logic – How to Carry Forward Updated Unit CostHi, I have a requirement to calculate the updated unit cost using the following formula and use the resulting value as the current unit cost for the next transaction row…RiyaKaushal123 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl…Shamsul_Wzd 73 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to identify and track any changes made to few specific Item Standard/UDA attributes Only ?Summary Of the problem scenario: As part of a data outbound from oracle cloud to boundary systems, we have to send item info whenever there is some update made to any sp…Dileep_Parise 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Is there a field with the original PRIMARY_QUANTITY for the table INV_TXN_REQUEST_LINESSummary: I have a report with the INV_TXN_REQUEST_LINES table using PRIMARY_QUANTITY but this field changes value as pick slips are recorded and confirmed. I need a fiel…Jorge D 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to create depended LOV parameters (based on value set) in ESS jobHow to create depended LOV parameters in ESS job. The LOV parameters will be based on value sets.KabirB 81 views 6 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for ERP -
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion.Krishan_Palihakkara 537 views 8 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Subledger Accounting-Journals Real Time Subject area in OTBI not showing Supporting Reference DataSummary: From the "Subledger Accounting - Journals Real Time" subject area in OTBI, we are not able to pull actual data in any of the Supporting Reference 31 to 60 colum…Jay Chandran 62 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for SCM
-
What tables stores fixed choice list dependency created using application composerSummary: A custom application was created using Application Composer. A fixed choice list field was set up to depend on another fixed choice list. However, the selected …
-
How to apply modifications to the Redwood Oracle Analytics Publisher template?Summary: We have been using a customized template for Requisition Approval Notifications. As per Oracle documentation, starting from 25A, businesses are required to reap…Vikrant Bhardwaj-Oracle 41 views 1 comment 0 points Most recent by Vikrant Bhardwaj-Oracle Reporting and Analytics for SCM
-
Need to have Inventory Location details in the OTBi reportSummary: Hello, We have a requirement where we need to have all the Location Name, Code and ID in one of the report. But I am umable to find it in the Inventory subject …Krupesh Joshi 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM