Reporting and Analytics for SCM
Discussion List
-
How to make a custom report available in supply planning work area?Summary How to make a custom report available in supply planning work area?Content Created a custom report. Users want it to be able to open from the supply planning wor… -
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'… -
logic and functional usage of table column COST_RETAIL_FLAG on fif_gl_crossref on Oracle Retail merSummary Trandata history do not have the column COST_RETAIL_FLAGContent Trandata history do not have the column COST_RETAIL_FLAG, hence it is not clear how the TDH trans…
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data … -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…
-
Report 'Receipt Accrual Balances'Summary Report similar to 'Adjust Receipt Accrual Balances' menuContent We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Ba… -
Product Management - Change Order Real Time analysis does not show Change Orders in "DRAFT" statusSummary Product Management - Change Order Real Time analysis does not show Change Orders in "DRAFT" statusContent A client requested a dashboard report to show ALL Chang… -
Create Link to the BIP from InfoletContent We are looking for the solution where we create a custom Infolet and that infolet should have a link to open a UI screen same as Standard infolets. For example: …
-
Payables invoices items detailsSummary Payables invoices items detailsContent Dear All, I need to create new OTBI report showing all details for suppliers received invoices as follows: Item number - I… -
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…
-
OTBI - Product Management - Cross Subject Area Logical SQL giving ErrorSummary OTBI - Product Management - Cross Subject Area Logical SQL giving Error 'The selected request cannot be performed because it references an unknown subject area n…
-
Need Query to Identify current pending approver for Supplier Registration in SQMSummary Supplier Registration Request Approval - need to report pending approver(s) in approval flowContent When a supplier registration request is submitted for approva…
-
Item issuance report with CostSummary Item Issuance report required with Cost.Content Hi, Is there any report for Inventory issuance including the Cost ( Item list price * Quantity issue ) Month or w… -
Presentation Variable working from one analysis and when I call the same analysis from other analysiSummary Action link presentation variable working for 1 analysis and does not for anotherContent I have created two analysis 1. XXVS Analysis 1.. In this I have created …
-
Suing ASBN on In Transit OTBI ReportSummary a)ASBN with 1 line received , 1 not disappear from In Transit report b) Possibility to add Received Quantity (Receiving In-Transit Advance Shipment Not. Real Tim…
-
Out of the box Sales and GP reportContent My client is looking if there is a seeded out of the box Sales report that shows the daily sales and Gross profit. The closest i see is the Sales Order document …
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…
-
Retail merchandising system, Tran data codes and their accounting treatment - EntriesSummary tran data codes from RMS and its accountingContent where can i find any reference document or user guide consisting of RMS tran data codes / GL_REF_NO accounting…
-
Costing - Item Cost Real Time - Cost-As Of dateContent Hi, Is there some way to in BA Costing - Item Cost Real Time for the Cost-As Of date include also HH:MM:SS? like "Transaction Date" in the BA Inventory Transacti… -
Does anyone know if there is a Report to track the unused items in our Warehouse?Summary We need to get rid of unused products and can't find a report for unused items (or for used items turnover)Content Is there a standard turnover report for Invent… -
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…
-
How to navigate to Cloud Application pages using Action links on columns in AnswersSummary How to navigate to Cloud Application pages using Action links on columns in AnswersContent Hello, I have created an analysis using subject area. Currently I am w…
-
inventory - inventory transaction real timeContent i use inventory - inventory transaction real time subject area, i need to create analysis 1- open balance for each item before specific date . 2- sum transaction…
-
Boost Revenue and Profit Performance With Oracle IBPXSummary Join us on Wednesday, January 20 from 11:00 AM - 12:00 PM CT to learn how to implement forward-looking metrics to drive optimum performanceContent Manufacturers … -
Unable to add Negotiation Icon to the Springboard and Navigator.Summary Unable to add Negotiation, SQM, Catalog Icons to the Springboard and Navigator.Content Hi Fellow Practitioners, Season's greetings. I have done all the necessary… -
How to report data present in DBaaS/Pluggable DB along with Cloud DataSummary we have 2 sets of data, 1. staging data present in DBaaS/Pluggable DB and 2. interfaced/transactional data in Cloud DB. We want to publish a common report throug… -
Inventory report.Summary Trying to use OTBI but some columns like cost are missing.Content A report that shows the following below; I.) Item number II.) Item description )On hand quantit…
-
OTBI Dashboard results in display errorSummary The dashboard contains an analysis with extensible flexfields. The flex field is deployed and working fine within OTBI but when deployed on OM Landing page via s…
-
JOb Scheduling which need a change of date on parameterSummary how to do change the parameter date of the ESS job when we schedule itContent we need to schedule a ESS job on daily basis on parameter we have start date and en…