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
-
R13 Financials 24A OTBI subject areas to database lineage mapping Spread SheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Need Tables for Cost Transactions Depletion Layer DetailsSummary: I'm looking for tables for Cost Transactions Depletion Layer Details as in the screenshot below. Content (please ensure you mask any confidential information): …
-
How to restrict the Subject areas against specific Module with a roleSummary: Hi Team, We have a requirement to restrict the subject areas against each area, like inventory, procurement, and order management, using a specific role, as the…
-
How to provide a Procurement Requester access to OTBI report creation?Summary: How to provide a Procurement Requester access to OTBI report creation? Do we create a custom role and add the BI Author role? Is there a privilege which governs…
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real… -
On Update 23.R4 SQM is noted as future roadmap itemSummary: On Update 23.R4 SQM is noted as future roadmap item. Is timeline available for this functionality? Content (please ensure you mask any confidential information)… -
Cost Accounting subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Daniel North - Orafinapps 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle
-
Receipt Creation Date coumn in OTBISummary: Which column in OTBI area can we leverage to get the receipt date information in Self Service receiving. Content (please ensure you mask any confidential inform…
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…
-
Need to maintain imagesSummary: For fusion SCM Is there any way we can maintain employee signature images to be displayed on reports Content (please ensure you mask any confidential informatio…
-
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to … -
How to add attachment column in bank account creation page of register supplier pageSummary: How to add attachment column in bank account creation page of register supplier page Content (please ensure you mask any confidential information): How to add a…
-
how to update/change Attributes in Fusion base table called "Inv_material_txns"Summary: Any rest api to update/change custom attributes in Fusion base table called "Inv_material_txns" Content (please ensure you mask any confidential information): V…
-
Sourcing Negotiation PDF - Tag which contains value for Allow Alternate Lines FieldSummary: Please help in Identifying if any tag pertains to "Allow Alternate Lines" field in Sourcing Negotiation PDF report. We have checked the below note but not able … -
Supplier Recon reportSummary: We are importing the suppliers,address,site details using FBDI.Is there a specific report that we can access or generate to reconcile the imported data with the…User_2025-10-31-01-02-51-214 91 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle
-
Combining order management & Cost accounting subject area not giving data in OTBI reportSummary: How to combine order management & cost accounting subject areas in OTBI report? Content (please ensure you mask any confidential information): We have an OTBI r…
-
how to add dff to subject areaSummary: We are using some DFF's in Transaction History under Inventory and DFF and enable the same for reporting. There is no DFF's are available under this subject are… -
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…
-
Can we create multi language records in AP_TERMS_TLSummary: Can we create multi language (i.e. English, French, German etc.) records in AP_TERMS_TL Content (please ensure you mask any confidential information): The table… -
MSC_BOMs_VSummary: When queried it results no data and when the code is viewed it says "undefine" Content (please ensure you mask any confidential information): Is this a bug that…
-
How to build custom report for LCM details with receipt accounting details to recon with GLHow to build custom report for LCM details with receipt accounting details which will be reconciling with GL. We are looking to build the report which will give us Lande…
-
How to add an Hyperlink/Button without page or app composer'sOur requirement is to add an hyperlink/button in this page, But page composer in this page does'nt alllow us to add new components here. Object related to this page does…
-
Not able to pass parameters from fusion into reportInside quality management -> we created a button named report in which a report link inserted, Data inside report is fine, But the requirement is to pass the data dynami…
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…
-
Query to get the Serial Number of Shipment number for PO in CloudNeed to find the serial number used in shipment for purchase order when we pass shipment number. select rsl.line_num, rsh.shipment_num, poh.segment1 as po_number, pol.it…
-
Inventory OTBI Report is working for some users and giving error for otherSummary: I have created OTBI report under the following subject areas (Receiving – Receipts Real Time) and (Receiving – Transactions Real Time). Using Sandbox page integ…
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…
-
System should pop a message to remind transaction date should be prior to current system dateIn oracle fusion, Work Execution->Report Material Transactions we are able to add a message here to say that transaction date should not be today's date. But we are unab…
-
We want to provide a deep link in email to supplier for purchase order acknowledgementSummary: We want to provide a deep link in email to suppliers for purchase order acknowledgement so that supplier can click on the URL and PO acknowledgement page opens …