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
-
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…
-
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…
-
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.
-
Print Labels on Zebra Printer from Oracle FAW - BIWe have a requirement on printing labels to Zebra printer. We are sending the print command from FAW-BI to CUPS and CUPS to Printer however it is not getting printed. Po…
-
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…
-
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…
-
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 …
-
Query/Table to find the below highlighted fields for Configure Negotiation Award Outbound Service?Can you help me in finding the above highlighted fields?
-
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…
-
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 …
-
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 …
-
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…
-
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…
-
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…
-
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…
-
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…
-
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, …
-
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 …
-
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…
-
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…
-
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…
-
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…
-
in subject area "Inventory Transfer Order Real Time" Actual Ship Date is not accurateSummary: in subject area "Inventory Transfer Order Real Time" under shipment details group we added in the report Actual Ship Date and confirmed date but we found it is …
-
Can we configure footer text message in oracle email notification (e.g. to suppliers)Summary: Is there any way to configure the footer on Oracle email notifications or needs Report customisation (esp notification sent outside like to suppliers) Content (…
-
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…
-
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…
-
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…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …