OTBI
Discussion List
-
How to view Logical Ship and Receive transaction for Dropship ordersSummary: How to view Logical Ship and Receive transaction for Dropship orders Content (please ensure you mask any confidential information): We have a requirement to rec…
-
In order management old and updated data needed in OTBI in separate lines.Summary: When we create a sales order due to some issues if we cancel the sales order, we are able to see the updated data of the sales order in the OTBI report. The req…
-
Which column in Fulfillment Lines Real Time is the same as fulfillment lines status in the screen?Summary: Which column in Order Management - Fulfillment Lines Real Time is the same as fulfillment lines status in the screen? When I selected "Fulfilment Line Status Na…
-
Facing an Error when changing the ware house in the Order Fulfillment Lines. How to resolve this?Selected shipping method is not available. Already added the required Inventory org to the Shipment method. Still error is populating. How to solve this?
-
How to get serial number by sales order line in SQLSummary: I need to get the serial result by order line, Does anyone know how to do it? All I can do is the result below. there are 2 lines with 2 different ship-out date…
-
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa…
-
Not able to see the EFF data in the doo_headers_eff_b tableSummary: We are creating some new sales orders from UI having some default values assigned to certain EFFs, but the EFFs values are not visible into the doo_headers_eff_…
-
How to auto release "Credit Check Hold" applied based on "Credit Hold" Flag at Customer MasterSummary: How to auto release Credit Hold applied based on "Credit Hold" Flag at Customer Master Content (please ensure you mask any confidential information): We have ma…
-
Is any schema recording the order in which it is discarded?Summary: Is any schema recording the order in which it is discarded? I need the information about who discarded the draft order and the time. Version (include the versio…
-
-
How to build a OTBI report to track changes across order revisions for a certain attribute?Summary: How to build a OTBI report to track changes across order revisions for a certain attribute? Content (please ensure you mask any confidential information): Versi…
-
How To Print Sales order Line Text Attachments into BIP reportSummary: We have requirement of "Print Sales order Line Text Attachments into BIP report", Please note: We have the same requirement for PO line text attachment which is…
-
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…
-
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 53 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 181 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 113 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 32 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 22 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…
-
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…