Category 174-2
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
-
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 113 views 2 comments 0 points Most recent by Walter Spinelli Reporting and Analytics for SCM
-
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 18 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 13 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 24 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 84 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 587 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 77 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 44 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 29 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Query/Table to find the below highlighted fields for Configure Negotiation Award Outbound Service?Can you help me in finding the above highlighted fields?Varalakshmi 21 views 3 comments 0 points Most recent by Chintan_KRishna973102 Reporting and Analytics for SCM -
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 42 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM -
we need to modify the "reply to" on the dashboards and analysis that we send via emailSummary: We have different dashboards or emails that are sent via email to different users. However we want the users to be able to "reply" to any of those emails and th…
-
Contract - option to download supplier or procurement contract details and attachmentSummary: when we go to Contracts Manage contract - there is only option to query based on name or contract number. 1)How to export all the contracts in on go instead of …
-
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different …VDM_IM 23 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain…Ahmed Abdelhamid 96 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
What tables/views are related to REST API /itemUnitOfMeasureConversionsSummary: I need to confirm the data is being retrieved without exception, so I would like to create a report of the same data that the API should be fetching. Content (p…
-
What is the OTBI item for "Organization" (under PO schedules)?We are trying to create a report that pulls the Ship-to location, PO number, and receiving organization (see above) to see where we have mismatching values (Ex: NATHW sh…