Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Get Started with Redwood for Oracle Cloud SCM Begin Now
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
-
Missing the Attribute Column in FLEX_BI_ItemBaseDFF_VISummary: Content (please ensure you mask any confidential information): using (FscmTopModelAM.EgpItemsPublicModelAM.ItemBaseDFFBIAM.FLEX_BI_ItemBaseDFF_VI) I'm attemptin…
-
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…
-
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…
-
RTF Font not being rendered in PDF outputSummary: RTF Font not being rendered in PDF output Content (required): We are trying to use a specific font in our PO RTF template called Script MT Bold : However when w…
-
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…
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…
-
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…
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
Scheduled BIP Report not Working post update to Recipients listSummary: A BIP report Scheduled to run once a week, made changes to the recipients list and observed the changes were not reflected in the next run, means recipient's li…
-
OTBI REPORT from Purchase requisition to Invoice paidSummary: Report from Purchase Requisition to Invoice Paid Content (required): We need a report which show a full flow status from PR to purchase order to receipt and fin…
-
Where can I find the equivalent table of Approval Rule conditions?Summary: We are creating a new Approval Rules for Cash Advance and Expense report but it is not successful using the conditions available on the Approval Workflow. We ne…
-
Integration between OTBI and FAWSummary: Integration or Linking possible between OTBI and FAW. Content (required): There is currently an ask to integrate OTBI and Fusion Analytics Warehouse (FAW). Is t…
-
Can we customize the Inventory BIP reports grid and save the view for the user?Summary: Need the ability to customize the grid and query, then save the layout so it is available as a favorite layout. Content (required): Version (include the version…
-
Query to Derive tax amount for a purchase orderSummary: Looking for a query to calculate tax amount for a purchase order Content (required): Looking for a query to calculate tax amount for a purchase order Version (i…
-
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…
-
how to use BICC for extracting large data from cloudSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Where to look for seeded reports in Cloud application?Hi, I am looking for information about seeded reports. Could some one point me to the place where seeded/out of the box reports available? I have managed to get the SCM …
-
Can anyone help me tune the query which i have wriiten to fetch the goods received not invoicedSummary: Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced since its having performance issue. Content (required): select p…
-
how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real TiSummary: how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real Time? Content (required):n/a Version (include the version you …
-
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…
-
"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…
-
Field names in several subject areas are changed. Where to find this in documentsSummary: Field names in several subject areas seem to have been changed as a result of 23B release. We've reviewed the documents and can see no mention of this in any of…
-
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3…
-
How to schedule a custom job to run twice a day?Summary: How to schedule a custom job to run twice a day? Content (required): Is there a way we can schedule a job twice daily with the same set of parameters at 6am and…
-
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
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…
-
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…
-
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…
-
Not able to run and generate data for a Receiving Receipts Real time & Purchasing Receipts Real timeSummary: Not able to run and generate data for a Receiving Receipts Real time & Purchasing Receipts Real time OTBI report using a custom role. Currently these are added …