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
-
How to rollback customized PDF templateSummary: How to rollback customized PDF template? Content (please ensure you mask any confidential information): Hi Experts, I got this requirement to rollback the custo… -
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n… -
OTBI report timeout error how to schedule OTBI reportHi All, In the OTBI report, we have a large number of records. It was running for 25 minutes successfully with my user credentials, but when using another user's credent…
-
Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …
-
Receiving - Purchase Receipts Real Time - Returns no results when adding Amount columnsSummary: In OTBI, when adding in any purchase receipt line columns returns No Results. This has only happened after 24D, any suggestions? We have the correct Warehouse M…
-
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…
-
Restrict "Edit" function on OTBISummary: Restrict "Edit" function on OTBI Content (please ensure you mask any confidential information): Hi Experts, I got this question that I am not able to restrict e…
-
BICC Not showing DFF FieldsSummary: Hello Team, BICC extracts are not showing the Shipment header and line DFFs which are configured in the system for the following seeded PVOs: - FscmTopModelAM.S…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
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 (…
-
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…
-
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… -
Where would the overview page analytics be visible in the Redwood theme page?Where would the overview page analytics be visible in the Redwood theme page? For Order Management/Procurement?
-
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…
-
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…
-
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… -
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…
-
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?
-
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)…
-
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 …
-
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…
-
Customising Datamodel of (seeded) Sales Order ReportSummary: How can we customise the Datamodel of the (seeded) Sales Order Report? Content (please ensure you mask any confidential information): The Sales Order Report is …
-
Shared SCM ReportsDoes anyone have a monthly total spend report that they might share? OTBI or SQL code? Co
-
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 …
-
Requisition Counts and Year to dateSummary: Requisition Realtime Help! I am trying to create a Requisition report that will display Departments and columns Jan ct, Feb cnt etc and the last column will be …