My Oracle Support Banner

How to Modify the Seeded Sales Order to Add Flex Fields or Add Other Fields (Doc ID 2622217.1)

Last updated on FEBRUARY 01, 2020

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.
Fusion - BI Publisher
Data Model Base on XML

Goal


How to modify the out of the box Sales Order Line Status Update or Sales Order Report to add flex fields OR to add Other fields like Scheduled Arrival Date.

We are attempting to use out of the box Sales Order Notification communication for when an Order Status updates, but we cannot extend the data model as the data model is an XML file which is read only. When trying to build our own data model with a query, there is no visibility into the parameters used in the report which causes the out of the box notifications to fail.

Specific data model we are trying to modify:
/shared/Supply Chain Management/Order Management/Fulfillment Alerts/Data Models/Sales Order Status Update Data Model

Others that would be helpful to modify:
/shared/Supply Chain Management/Order Management/Fulfillment Alerts/Data Models/Shipping Notification Data Model
/shared/Supply Chain Management/Order Management/Sales Orders/Data Models/Sales Order Report Data Model

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.