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
-
Is there any standard Oracle reports for reconciling Receiving Inspection account?Summary: Content (required): We're looking to see if there's any standard Oracle reports to help reconcile receiving inspection account and review whether there are any … -
OTBI Report view as Transpose RowsSummary: Content (required): Hello Friends, How I can get a Transposed view display for OTBI report (based on subject Area)? For Example: Currently I am getting output a… -
Why Front Infolets Source to Settle it does not show any data?Summary: Analytics Source to Settle Infolets section in front not show any data (blanket) users only can see results into Expanded view. Content (required): Procurement … -
In which table Derived related items are stored in Oracle Fusion CloudHi , We have the item which has related item with reciprocal flag is Y and when i search the related item, i can see the actual part in the derived relation items. but s…
-
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …
-
SCM & Procurement Standard reports templates ?Summary: am searching for a document that include fusion SCM & Procurement Standard reports templates Content (required): SCM & Procurement Standard reports templates Ve… -
Data not showing albeit correct rolesSummary: Data is not showing whilst creating an OTBI analysis Content (required): Data is not showing whilst creating an OTBI analysis for the Unit Cost Dimension althou…
-
Getting error while downloading larger amount of data in BI ReportSummary: We have observed one issue in BI Report wherein while extracting the report output, it only shows total 74701 number of records. After that it shows error as Ex…
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…
-
SCM roles to create OTBI reportSummary list of roles is requiredContent Hi All, Kindly, I want to use OTBI to create reports specifically in SCM. I need the list of roles that facilitate this kind of … -
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Unable to link Order Fulfillment and Item Cross Reference Subject AreasSummary Unable to link Order Fulfillment and Item Cross Reference Subject AreasContent Hi, Are there any documentation to identify what join is missing when we try to re… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…
-
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL … -
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query … -
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… -
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…
-
Ability to run BI report from Isupplier portalContent Hi Experts, We have built one custom report related supplier performance in BI. Requirement is Suppliers should be able to access the reports in iSupplier Portal… -
we need item transaction qty with item costContent Dear , We need item transaction qty with item cost. So we used CST_TRANSACTION_COSTS ctc table to join INV_MATERIAL_TXNS imt through imt.TRANSACTION_ID = ctc.TRA… -
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…
-
Lot Experation Date Field in Subject AreaSummary Looking for the Lot Experation Date fieldContent I am using the Inventory - Inventory Transaction Real-Time subject Area. Under Lot there is no Expiration Date f… -
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 938 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045
-
Index to be applied on LAST_UPDATE_DATE field of "doo_headers_all" tableSummary Index to be applied on LAST_UPDATE_DATE field of "doo_headers_all" tableContent Hi , We have a report created which fetches order,Order charge component , pricin…
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…
-
Need organization inventory data unit cost wiseContent Dear , We have 11 Inventory Organization in which we want inventory unit cost as per org id. so we created customized query join cst_transactions ct into inv_mat…
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …
-
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…