SCM
Discussion List
-
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… -
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
-
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
-
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 23 views 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 403 views 8 comments 0 points Most recent by Krishan_Palihakkara 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 25 views 3 comments 0 points Most recent by Chintan_KRishna973102 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…Scott Paulin 6 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for SCM
-
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…
-
What is template name of email body and subject of awarded negotiation that send to supplier?Actually our client want to customized the email body and subject name for Negotiation Invitation and Negotiation Awarded email that send to Supllier. We are to able fin…Chandan Kr 6 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 357 views 3 comments 0 points Most recent by User_HIEUU Reporting and Analytics for SCM
-
Custom Subject Area Primary Objects for ERP and SCM CloudSummary: What are the Primary Objects that we are supposed to have access to? I am looking at creating a Custom SA for Sourcing Responses. I only see the following: Cont… -
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 1.3K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table after Ship confirmSummary: Can we update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table in Fusion after Ship Confirm business event? Content (please ensure you mask any con…Khalida Raffath 12 views 1 comment 0 points Most recent by Khalida Raffath Reporting and Analytics for SCM
-
Print Receivables transaction ReportHi team, We have requirement where for Germany we have to print AR invoice report in german and english language both. But when we run the schedule process 'Print Receiv…vikram khengare 13 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Table for Source Reference field on Completed Transaction page - SCM CloudSummary: Hello, We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field. Content (plea…
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 11 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Pick slip running for too long after bursting customizationSummary: We have customized print pick slip report to burst to email.However , its running for too long post changes. Any suggestions? Content (please ensure you mask an…Akshitha Vyas 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
Unable to access data from content serverI have a text attachment in work order operation level. I would like to print the contents of the text in work order traveler report. I would like to know how can I acce… -
How can your report on Back dated receiptsDoes anyone know how you can report on back dated receipts FIN has allowed receivers to receive into the new year on orders for the previous year. the instruction is to … -
Which table in Oracle fusion stores the error messages while Importing sales Order using FBDIIn which table, can I find the error messages for any error occured during the Import Sales Order using FBDIRishabh33Maithani 901 views 3 comments 0 points Most recent by Murali01Jairaj Reporting and Analytics for SCM
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.1K views 4 comments 4 points Most recent by User_IIM8T Reporting and Analytics for SCM -
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanksAhmed Abdelaziz 32 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Backend tables for Receipt Accounting DistributionsSummary: I need backend tables for the screen Receipt Accounting Distributions (Supply Chain Execution>Receipt Accounting> Receipt Accounting Distributions). I found tha…Akankshya Jena 40 views 6 comments 0 points Most recent by Akankshya Jena Reporting and Analytics for SCM
-
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 46 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 24 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?
-
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 40 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM -
Access the standard BIP report extracts via APISummary: Hi Team, We have a requirement to fetch and place the standard BIP extracts from UCM to some file server. example, once the ap invoices import process is comple…
-
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.1K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM