OTBI
Discussion List
-
How to Reprice the Sales Orders after Pick ReleaseSummary: How to Reprice the Sales Orders after Pick Release Content (please ensure you mask any confidential information): We have a requirement to reprice the Sales Ord… -
Report for Sales Orders Pending InvoicingSummary: We need a report showing us details of all sales order lines against which delivery is done but invoicing is not yet done, in real time. In other words a report…
-
Approve Purchase Order from OTBI Action LinkSummary: Since 24A, the PO link within approval notifications is navigating to a blank page. As a workaround, we created an OTBI report that pulls all pending approval o… -
Query to get sales order line level revision detailsSummary: Query to get sales order line level revision details Content (please ensure you mask any confidential information): Query to get sales order line level revision…
-
Error: EL expression isn't correctCreated one custom role for the purpose of quote creation. Need to change Create Order to Create Quote in sales Order, but EL Expression is Not working. -
Unable to get the price after made the revision of the Sales order.Summary: Dear, By using a revision option, we are trying to add the new line to a sales order that currently contains several closed or awaiting shipping lines, but syst… -
How to Remove Unwanted currencies from LOV in Sales Order?Hello, After putting End date and disabling the currency in the " Manage Currencies " still system is showing the currencies in the Sales Order Header. We required to se…Sankarjith P M 41 views 9 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
sql query to get Drop Ship Financial FlowsSummary: sql query to get Drop Ship Financial Flows Content (please ensure you mask any confidential information): Hi Team, We need the table where the information "Sell…Opkey PA 131 views 1 comment 0 points Most recent by Mohit Jain-Oracle Supply Chain Financial Orchestration
-
sql query to get Drop Ship Financial FlowsSummary: sql query to get Drop Ship Financial Flows Content (please ensure you mask any confidential information): Hi Team, We need the table where the information "Sell…
-
how to show extensible flexfields from order management to OTBISummary: Hi, we able extensible flexfield in order management and we enabled "BI Enabled" in all of fields, but these fields don't migrate to OTBI, we run the process Im…Alex Pagliarini - Ninecon 73 views 8 comments 0 points Most recent by User612903-Oracle Order Management -
How do add custom infolets in order-to-cash tab?Summary: Hi, we need to add custom infolets, but there is no add field in this option below. We able the sandbox, but I can't add new custom infolets Content (please ens…Alex Pagliarini - Ninecon 31 views 2 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management
-
How to create a custom Infolet using a query example?Summary: Hi, we need to create a custom infolet by a query example Content (please ensure you mask any confidential information): There is a away to create a custom info…Alex Pagliarini - Ninecon 21 views 4 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management
-
We have to create an Custom field in sales order page.Summary: We need to create a custom column in Sales Order, That can be updatable at any point of time. Content (please ensure you mask any confidential information): Ver…KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Sandeep Kurur-Oracle SCM Product Management-Oracle Order Management
-
How to receive description of EFFs' LOVSummary: Hello Experts, We have created a report to see the item attributes. For a case we need to see the description of the value. Do you know in which table the value…
-
Display Source warehouse information during Item entry in the sales orderSummary: Hi Folks We would like to see the source warehouse along with On-hand information during item entry in the sales order Content (please ensure you mask any confi…
-
Trying to default Selling Profit center BU on SO line using pre transformation rules but could not fSummary Trying to default Selling Profit center BU on SO line using pre transformation rules but could not find right attributeContent Trying to default Selling Profit c…
-
Sending E mail A Report When New Content ProducedSummary: Hello Experts, We have a contract report in the system. It is like an abstract of the sales order but in customers' format. We have a template and it changes up…
-
How to execute web services using Groovy on Order Management Extensions?Summary We want to create an extension that runs a report on Oracle Business Intelligence to get the content of its responseContent Hello guys! We were looking into a wa… -
Need query to get the line level error message from the sales orderSummary: We have a business requirement to display the Error Message from the line level of the sales order in Fulfillment lines. We are getting error throw back end que…
-
Customers real time not giving correct outputSummary: Not able to create Customer Master Report. Customer and accounts are not mapped. Is this correct subject area to get customer info? Single Customer to joined to…
-
Is it possible to approve an order from a OTBI analysis?All orders are created directly in OM and they have a simple approval workflow. For the approval is critical to review the price components of each item. The problem tha…
-
Any report available to fetch ESS -scheduled pick waveSummary: Any standard report available to fetch scheduled pick wave ESS. Content (required): our client has 5 inventory organizations, and each org has multiple pick wav…
-
Global Order Promising module to consider PO from external systemSummary: We have use case where we need to get the recommendation from Global Order Promising module from fusion cloud instance by considering POs created in On premise …
-
How to convert calculated fields into measures OTBISummary: We're using data from the Recruiting - Recruiting Real Time subject area. We need to create a performance tile to display Total Openings Left to Fill however th…Mark kristan De los Reyes 51 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Recruiting, Opportunity Marketplace -
Easier and access-controlled way to run any report instead of navigating to Scheduled JobsWe have a custom sales order report, where business wants to be able to run it directly from the Sales Order screen rather than navigating to Scheduled Jobs. Is there an…
-
Where to store certain data having in 6-7 excel columns in Oracle Fusion for BI reports purposeSummary: Is there any appropriate place in Oracle Fusion to store certain key data having in 6-7 columns (around 1000 rows) and use that information in the custom report…
-
Deep Link for Manage OrderSummary: We are creating an custom infolet which shows number of order in a month and when user clicks on the month it should open the Manage Order screen as it do in ca…
-
Are Multi Row Extensible Flexfield Segments Supported by Order Management in Current Release 21A?Summary Are Multi Row Extensible Flexfield Segments Supported by Order Management in Current Release 21A?Content Hi Team, We have requirement to capture Lot and Serial n…
-
Query to get sales order details plus transaction detailsContent Hi all, I need a query to get the sales_order_number,sales_order_header_id,inventory_transaction_id for the sales order. Please do guide me. RegardsSushan Peris