Category 174
Discussion List
-
https://CloudUrl:443/xmlpserver/services/ExternalReportWSSService' failed:Timeout exceeded.Summary: We have custom BI Report data model and layout. we trigger BI report using https://iaxgqy-dev1.fa.ocs.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSS…sasi 137 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Issue creating RTF Template using Non-standard SQL Data ModelSummary: Issue creating RTF Template using Non-standard SQL Data Model Content (please ensure you mask any confidential information): I have created a new Data Model in …
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da… -
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…
-
BICC Extracts: how can i find out what attributes are used for each of the fields in the data storesI am looking to find out what attributes are used for each of the fields extracted within our BICC Extract data. Our data reporting teams need to understand if a field i…Tracy Collins 6 views 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting and Analytics for SCM
-
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…
-
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 46 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
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: 25D…Ramamurthy Shankarachetty-Oracle 17.6K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
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 37 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for SCM
-
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 …
-
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…
-
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 117 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…
-
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 160 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… -
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 23 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 20 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…SIVASANKARAN GOPALAN 14 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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 43 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 12 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 25 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 14 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 14 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 26 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM