Reporting and Analytics
Discussion List
-
Report showing different output when logging in same environment (With SSO and Without SSO)Summary: Background A customer report is a custom report that shows all parts/items that are appended to a Machine. Parts/items will be included in the report even when …Kamohelo Leqele-Oracle 11 views 1 comment 0 points Most recent by Kamohelo Leqele-Oracle Reporting and Analytics for SCM -
How to increase time-out limit for online reportsSummary: I need to know where to increase the processing time for online reports. We have already increased the extraction limit to 2GB, but when we extract the report w… -
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 42 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM
-
Is there any way to customize the filters for custom reports in OTM?Summary: I created the filters using the options available in the path: Business Process Automation>Power Data>Document Generation>Reports. The customer wants more flexi…
-
OTBI Procurement - Requisitions Real Time Subject areaSummary: Procurement - Requisitions Real Time Subject area doesn't show Requisition with Source Inventory, Only showing Data for Supplier Source so which Subject area ca…
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report.Assem Khaled 1 view 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
How to increase extraction capacity of a customized report?Summary: I need to extract the report over a 2-month interval, which would give approximately 100 000 lines. Content (required): I created a report with approximately 80…
-
Query in BIP report not showing result, what can I do to make it work? (SQL included)Summary: Content (required): Hi, I have created a report containing the receipts made for the selected time period. The report is showing the result when I limit the per…Mariyam129 32 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Is there a table that holds Impact AnalysisSummary: Content (required): we need to extract information from the tab "Impact Analysis" (which is available, for instance, in Change Order objects). Is there any tabl…
-
Need query to pull item cost details for specific transactionsSummary: Content (required): Business requirement is to pull item cost details for specific transactions from the refurbished SKUs Version (include the version you are u…kalyan gade 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 110 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
Equivalent Oracle Cloud table/view for the EBS 11i entity WIP_FLOW_SCHEDULESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity WIP_FLOW_SCHEDULES? Content (required): Version (include the v…Nagendrababu Kanuru 61 views 3 comments 0 points Most recent by vikram khengare Reporting and Analytics for SCM
-
Equivalent Oracle Cloud table/view for the EBS 11i entity WIP_ACCOUNTING_CLASSESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity WIP_ACCOUNTING_CLASSES? Content (required): Version (include t…Nagendrababu Kanuru 21 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Equivalent Oracle Cloud table/view for the EBS 11i entity MTL_MATERIAL_TRANSACTIONS_TEMPSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity MTL_MATERIAL_TRANSACTIONS_TEMP? Content (required): Version (i…Nagendrababu Kanuru 21 views 1 comment 0 points Most recent by Vikash Tiwary Reporting and Analytics for SCM
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
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…Kalyan Reddy 45 views 3 comments 0 points Most recent by Fabiana De Arruda Reporting and Analytics for SCM
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 181 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 43 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…
-
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…
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…Neela.Voduguru 71 views 1 comment 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How do you export a list of custom reports from OTBI?Summary: I need to export the list of custom reports created in OTBI, to manage the content and clean up the list of reports available. Content (required): Is it possibl…Jim Forsythe 801 views 6 comments 1 point Most recent by Jim Forsythe Reporting and Analytics for SCM
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Need Query to pull the item costs for the refurbished SKUsSummary: Have a requirement to find the item costs for refubrished SKUs Content (required): Query to pull the item costs for the refurbished SKUs Version (include the ve…
-
Is there any way that we get Inventory transaction details with Serial numbers using Inventory SubjeSummary Is there any way that we get Inventory transaction details with Serial numbers using Inventory Subject AreaContent Is there any way that we get Inventory transac…User_2025-02-04-07-31-55-085 86 views 3 comments 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User-Summary: Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User Content (required): Hi, We have a requirement for a report which…Aman Chaturvedi 41 views 1 comment 0 points Most recent by Rohan Kamat Reporting and Analytics for SCM