OTBI
Discussion List
-
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… -
Edit item description on sales order or create the sales order without selecting a item codeSummary: Is there a way to Edit item description on sales order same like we have option on PO level or is there a way to create the sales order without selecting a item… -
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 56 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 13 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 5 views 1 comment 0 points Most recent by Sandeep Kurur-Oracle SCM Product Management-Oracle Order Management
-
Required sql query or tables sales order approval rules under Manage Order Approval Rules task.We required SQL query or back end tables where the information of Order management workflow Approval rules stored. Task name: Manage Order Approval Rules. For example Ru…
-
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…
-
Line Status supply Request CompleteSummary Some of the order lines gets stuck with the status "Supply Request Complete"Content Dear, Some of the order lines gets stuck with the status "Supply Request Comp…
-
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…
-
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…
-
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 41 views 1 comment 0 points Most recent by Brian G- Support-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 -
Redirecting users to core module through OTBI dashboard clickSummary: Redirecting users to core module through OTBI dashboard click Content (required): In the core ERP system, we have these infolets with one functionality that wou…Leandro Vasconcelos 11 views 1 comment 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Order Management -
OM Cloud - Has someone created any dashboard or report for the credit exposure details like in EBS?Summary: In EBS, there is a credit exposure report which has complete credit information of customer like open invoices, existing open sales order etc. which help busine…
-
Query to find Ship to Contact Method on Header and Line level of Sales OrderSummary Query to find Ship to Contact Method on Header and Line level of Sales OrderContent Hi Guru's Can you please help me to find Ship to Contact Method on Header and…