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
-
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…
-
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…
-
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…
-
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
How to give access to a custom dashboard and data within itSummary: How to give access to a custom dashboard and data within it Content (required): Hi, We have some custom dashbaords developed and each dashboard has multiple ana…
-
Filter Planned Completion Date Based on Current DateSummary: Content (required): Hi, We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time…
-
Need a way to create OTBI for Available to transact quantity in Inventory ManagementSummary: We are trying to create a OTBI to report 'Available to Transact' on hand quantity. However, we dont find this field in any OTBI under Inventory Management. Any …
-
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c… -
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…
-
Fusion SCM Analytics for MFG and Planning?Summary: Does Oracle has any plans to extend its current footprint of Fusion SCM Analytics with pre-build (industry standard) KPIs for MFG and Planning ? Content (requir…
-
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…