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
-
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… -
Equivalent Oracle Cloud table for the EBS 11i table SO_PRICE_LISTSSummary: Could you please help us to provide the equivalent Oracle Cloud table for the EBS 11i table SO_PRICE_LISTS? Content (required): Version (include the version you…
-
Equivalent Oracle Cloud table for the EBS 11i table WIP_LINESSummary: Could you please help us to provide the equivalent Oracle Cloud table for the EBS 11i table WIP_LINES? Content (required): Version (include the version you are …
-
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, Julia -
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…
-
Access to Inventory Subject Areas for Inventory OTBI AnalysisHello, According to this document: https://docs.oracle.com/en/cloud/saas/supply-chain-management/22d/faosm/Inventory--Inventory-Transactions-Real-Time-SA-36.html#Invento…
-
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…
-
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… -
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…
-
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…
-
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, … -
Bursting report in errorSummary: The log shows the following error: BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition…
-
How to schedule an OTBI report output in excel/ csv format to the intended usersSummary: Hi we need to schedule an OTBI report output in csv format to the users. Is there any document for this. Thanks Content (required): Version (include the version…
-
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…
-
Need to report which Orgs have a common BOM added in OTBI reportSummary: When I run a BOM report in OTBI only brings up the master org when other orgs have the common BOM added Content (required): We have a group of products where th…
-
Interconnect Oracle fusion and Azure databasesSummary: We seek information to interconnect Oracle Application Fusion and Microsoft Azure databases. We need step by step process to connect these databases. Content (r…
-
SCM Dashboard ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…
-
Supplier Registration or Profile Change Approval DetailsContent Hi , I want to prepare a SQL which will have supplier and approver details. I know we have below workflow and supplier tables: fa_fusion_soainfra.wftask fa_fusio…
-
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…
-
BI publisher for Demand Plan custom measures.Summary: Hi all, please I would thank for any help with the following. We need the query below this Demand Plan screens. Example 1. Example 2. We have noticed some table…
-
What time does the User Password Changes Audit Report show?Summary: I'm running the User Password Changes Audit Report and I'd like to know what time zone does the report output show. Content (required): User Password Changes Au…
-
Get latest revision of sales order in OTBISummary: Get latest revision of sales order in OTBI Content (required): Hi Team, A sales order may have more than one revision. We are trying to create a OTBI analytics …
-
OTBI Subject Area to be used to create report in capturing receipt details and DFFSummary: OTBI Subject Area to be used to create report in capturing receipt details and DFF in self-service receiving. Content (required): Self-service receiving Version…
-
In PO Print PDF report , how can we avoid canceled line in PDF outputSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Item Pricing informationSummary Need to extract item pricing information by locationContent Hi, We are looking for BIP report/OTBI subject areas that can extract Item pricing information. Is th…
-
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…
-
Supplier Statement ReportSummary: Any OTBI or Seeded Supplier Statement Summary & Details report including transactions details and opening closing balances. Content (required): Any OTBI or Seed… -
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…
-
Is there a way to dynamically update the column header names on reports when Name = Months?We have a report that displays monthly data with the Months as Column Headers. Currently, as a workaround, row 1 is displayed as Month 1, Month 2, etc. and row 2 is mont…