To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
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… -
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 …
-
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…
-
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…
-
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… -
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…
-
List all SCM transactions not captured under transaction consoleSummary: List all the names of the supply chain management transactions that take place in the oracle system but are not captured under the Transaction Console in Tools …
-
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…
-
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…
-
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…
-
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…
-
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 …
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…
-
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…
-
Seeking guidance on LISTAGG() functionSummary: Hello, could someone please guide on why listagg() is not working in the following query: Content (please ensure you mask any confidential information): Hello, …
-
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…
-
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… -
Presentation variable based on another presentation variableSummary: I would like to print the Negotiation Title of the selected Negotiation Number in the Header. I have the Negotiation number in a presentation variable (pb_negot… -
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …
-
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…
-
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 …
-
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…
-
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…
-
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult…
-
Change Order Summary Report QueryHi, Previously, there was a built-in customized report in Oracle PLM titled "Change Order Summary Report", which provided details of Change Orders along with redlining i… -
Column label not showing in ArabicSummary: Column label not showing in Arabic Content (please ensure you mask any confidential information): Hi All, We got a requirement to change the company name in iSu…
-
issue query filter BICCSummary: We're trying to filter specifc data from VO at BICC , but log returns query error at where clause. Content (please ensure you mask any confidential information)…
-
OTBI report to pull purchase order issued from each punchout and catalogSummary: OTBI report to pull purchase order issued from each punchout and catalog Content (please ensure you mask any confidential information): Hi Team, We have require…
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…
-
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…