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
-
How to restrict Inventory Items or On hand data based on User data access role in BIP Reports?Hi All, We have a requirement to restrict the Inventory Items or On-hand data based on User data access role Org assignments through BIP Reports. Currently, we have buil… -
ESS job is running longtime in JobsetWe have created a Jobset with 2 ESS jobs. First ESS Job is completed fast and second ESS Job is running longtime and not completing. When we run the second Job independe…
-
Extract DFF/EFF for Transfer Orders/Sales OrderSummary: Hi, We have a reqiurement to extract the DFF and EFF information for Transfer Orders and Sales order using BICC. We could able to find the below PVOs for extrac…
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…
-
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …
-
Requirement to add special instructions to a PDF report based on organization of a PO.Hi We have a requirement to add special instructions to a PDF report based on organization of a PO. Currently we have 20+ organizations. Which will increase in the futur…
-
How to decide if a report to be developed in BIP or FAW?Summary: Content (please ensure you mask any confidential information): Based on what criteria should we use to determine if a report can be developed in BIP or FAW? Ver… -
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…
-
Customizing Accrual Reconciliation report and status is Retrying when running ess jobSummary: Customizing Accrual Reconciliation report and create a new custom ESS job by copying standard ESS job but when running it then the status is Retrying Standard E…
-
Issue Number formating causing reporting issuesDear All, The format of numbers in the purchase order standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the da…
-
which privilage is needed to run 'Item Txn with Average Cost report'Summary: Hello experts , Our customer wants to give access to the user for 'Item Txn with Average Cost report' . They don't want to give the entire access of inventory s…
-
Sql query to get shipment method of orders in oracle fusonDear All, how will get shipment/delivery method of Orders in oracle fusion
-
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
SQL query to find the task for a specific tableSummary: Hi everyone, is there a query in which it will show the specific task of a table name? for example: table name = QA_INSPECTION_PLAN_B task name = Manage Attachm… -
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…
-
How to add page break for a HTML output of BIP Report. Please Advise.Summary: Page Break not working in HTML output of BIP Report. Content (please ensure you mask any confidential information): Version (include the version you are using, …
-
Need to create a Job set which call Min Max Job 600 times with different parametersSummary: We need to create a Job set which will trigger the Min-Max planning report 500 times for different Inventory Organizations. We are able to create the job set th…
-
Report Bursting CapacitySummary: Hi Team, We have a business requirement to send an email with a PDF attachment via bursting. Here are the specifics: Delivery Method: Email via Bursting Attachm…
-
Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.
-
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI… -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…
-
Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.
-
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …
-
We need to extract all the sales Order data in excelSummary: Hi Team, Can we have a report which can help to extract all the sales orders which are open same like the fulfilment view export functionality. Currently the ex…
-
Please provide SQL query to get UCM file name,owner and upload date based on the UCM pathSummary: Kindly provide me the SQL query to get file name, owner and upload date from UCM based on the UCM path. Need this to create a parameter based LOV for ESS job. '…
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …
-
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…
-
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…
-
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…