Orders Created Successfully, EFF Data is not Updated to Database

(Doc ID 2070533.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Fusion Distributed Order Orchestration - Version to [Release 1.0]
Oracle Fusion Order Management Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***


EFF data is not being stored to the Database

User has created a Fulfillment Line EFF, which uses a text Value Set of 10 Characters. The payload presented to DOO contains a value which is longer that 10 Characters. The order is created successfully and is processed, HOWEVER no value is stored for the Flexfield information, A row for this EFF is created in the database. In addition to this:

a. Support has observed that no error is reported in EM
b. All other flexfield information provided in the payload is also NOT stored.

Any EFF validation errors should cause an error to be reported to the user.

EFF Definition

Verify that the EFF row has been created with Null Values by executing the following SQL:

Executing SQL using BI in a Cloud Environment is described in - Fusion Applications BI Publisher : How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database ? (Doc ID 1910762.1)












Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms