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
-
Reports and Analytics AccessSummary: Production Supervisor Role unable to see Reports and Analytics under tools Content (please ensure you mask any confidential information): Production Supervisor … -
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…
-
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 …
-
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin… -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…
-
BIP Excel output removing zeros from decimalSummary: BIP Excel output removing zeros from decimal Content (please ensure you mask any confidential information): I have a BIP Data Model and Report with Excel (.xls)…
-
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): …
-
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…
-
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…
-
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…
-
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… -
How can we generate an OTBI report with receipt Number with received Quantity/AmountSummary: We have a requirement to create an OTBI report with Receipt Number and the corresponding Received Quantity or Amount. We tried using Purchasing Real Time data b…
-
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 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…
-
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…
-
Navigate to Installed base Assets page using action links in OTBISummary: Issue with Navigating to specific Asset summary page from OTBI analysis for IB assets Content (required): I am trying to click to view, and navigate to IB asset… -
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…
-
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…
-
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…
-
access to reports and analytics tileSummary: User does not see "Reports and Analytics" tile in Tools which role, data access needs to be given, user has Production Supervisor and Production Operator roles.…
-
Where can I find the list of all seeded reports (OTBI and BIP) provided by OracleSummary: Where can I find the list of all seeded reports (OTBI and BIP) provided by Oracle for Procurement and Contracts? Content (required): Where can I find the list o…
-
Unable to find database tables for Manage Terms and Conditions SetupHi Team We have the requirement to use the terms and conditions created under manage terms and conditions setup but not able to find out the related table or lookup. ple…
-
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…
-
Integration between OTBI and FAWSummary: Integration or Linking possible between OTBI and FAW. Content (required): There is currently an ask to integrate OTBI and Fusion Analytics Warehouse (FAW). Is t…
-
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
Need to know Job scheduler setting detailsHi Team, We are looking for BIP job scheduler setting details like job queue size , priority etc. Could you please guide on the same. If we can fetch the details from so…
-
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …
-
How do I stop my OTBI screen from going Null when the user leaves and comes backSummary: We need to keep the values in the dashboard when the user moves from tab to tab. Content (please ensure you mask any confidential information): Version (include…