Category 174
Discussion List
-
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 91 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 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 148 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 19 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… -
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 13 views 2 comments 0 points Most recent by Manish Maheshwari Reporting and Analytics for SCM
-
Fusion SCM Analytics Prebuilt KPI Library for MFGHi, I am looking for prebuilt KPIs library for MFG subject area. I checked the documentation link 25R1. but could not find the list for MFG, although for OM,INV etc I co…
-
Print Commercial Invoice is ending up with retrying status.Hi All, We have a custom role and with privilege assigned print shipping reports. When i'm trying to run the Print commercial invoice, it is ending up retrying status. I…KSowmya 46 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle 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
-
SQL Query to fetch Configure Negotiation Award Outbound Service in oracle fusionSummary: Content (please ensure you mask any confidential information): We required table to get the columns in the screenshot Version (include the version you are using…Chintan_KRishna973102 10 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 75 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Which SQL table stores the Transfer Order Receipt Distribution Journal EntriesSummary: I am aiming to write a report that joins the 'journal entry account' - pictured below, all the way to the INV_TRANSFER_ORDER_LINES table using source document n…MichaelV823 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Seeking guidance on SQL querySummary: Hello, can someone please advise how to transform this query in order to return only records where a combination of (esib.item_number, hp.party_name, and pltl.l…MichaelV823 11 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 -
Audit Cancelled Reqs that were tied to an open Purchase Order at time of cancellationSummary: Is there a way we can write a query/check an audit file that contains history of all requisitions that were cancelled that were already tied to an open Purchase…MichaelV823 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there a way to exclude the LOTs on hold from Inventory ValuationSummary: Is there a way to exclude the LOT on hold from the Inventory Valuation? example quality hold ? Content (please ensure you mask any confidential information): Ve…Amrish_Amradkar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 527 views 8 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM