Get Started with Redwood for Oracle Cloud SCM Begin Now
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
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …
-
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…
-
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…
-
Requisition Report errors when filtering to one BUWe have a Requisition Approved Status report that runs a report for approved Reqs for our 3 Business Units, Report runs fine when ALL BUs are selected or even 2 BUs. But…
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
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 …
-
Requisition Unprocessed daysSummary: Difference between OTBI Requisition- Unprocessed days in Line detail and Unprocessed days in the Line folder Content (please ensure you mask any confidential in…
-
Database table to get the min and max quantity for Replenishment plan type item in oracle fusionSummary: Hi all, please let us know Database table which stores min and max quantity for Replenishment plan type item in oracle fusion Content (please ensure you mask an…
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
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 …
-
Need SQL query to extract Agreements and the assigned Requisitioning Business unit namesSummary: Purchase agreements with assigned Requisitioning Business unit names extract Content (please ensure you mask any confidential information):Need SQL query to ext…
-
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…
-
Work Definition view only- secondary quantity is updatableSummary: Created custom view only manufacturing engineer role which is working fine, except secondary quantity for operation items (input material / ingredient) is edita…
-
BICC DFF extract sales order header and linesNeed to extract Sales order header and line data from tables DOO_HEADERS_ALL and DOO_Lines_ALL. I am able to get this using BICC extract into UCM server. But DFF columns…
-
How to Insert/modify targets in main dashboard OTMSummary: Hi, I'm opening this ticket by suggestion from OTM CCC discussion: Is it possible to insert or update targets values in the main dashboard page? We have try to …
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
Is it possible to create or move the DFF fields under Product & Servies Tab in Supplier PageSummary: Business requirement is to create or move the existing Dff fields under Product & Servies Tab in Supplier Page. Please find the below screenshot for more detail…
-
Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transactHi Team, We need to retrieve available to reserve and available to transact , but we've observed discrepancies when querying through SQL. Our goal is to achieve this via…
-
Prompt LOV restriction in OTBI according to user Business unit data accessSummary: We are trying to restrict the prompt LOV which returns BU names that currency configured in the system. But we want that when a particular user will try to run …
-
Work Definition Comparison reportSummary: Is there any existing report available to get below details? Work Definition Comparison report if not, what table I need to refer for this comparison? Content (…
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …
-
Not seeing 'Create Infotiles' button in sandbox and edit pagesSummary: Not seeing 'Create Infotiles' button in sandbox and edit pages Content (please ensure you mask any confidential information): Created a sandbox 'Page Template C…
-
Query to get PO Change History details which have Been Purged.Summary: There is a requirement by the business to fetch the details of the archived history for POs Content (please ensure you mask any confidential information): To re…
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
sending email for bursting not workingHi . I create the Bursting process for an user. In the first step i created the query bursting in the data model : In particulary the parameters for my the Bursting quer…
-
Supplier Address Level Tax Classification CodeSummary: We are trying to determine the Tax classification code field at Supplier Address level in OTBI analysis Content (please ensure you mask any confidential informa…
-
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…
-
No data displayed in Goods Received not Invoiced ReportSummary: Hi, I am using seeded OTBI Report 'Goods Received not Invoiced Report' and made a custom report with the same subject area i.e. Costing- Receipt Accounting Real…