Oracle Transportation Management (MOSC)

MOSC Banner

Updating with Null values through integration

edited Aug 4, 2010 1:07PM in Oracle Transportation Management (MOSC) 3 commentsAnswered ✓
 Hi,

We are trying to update existing values with null values through integration. If we do any updates with new values, the changes happen in OTM.

But in case if we pass null values in update, there is no change and the previous values remain.

One example is we are trying to update the location address:

Before updation:
Address line1: xxxxx
Address line2: xxxxx
Address line3: xxxxx

Next we are passing the values as below:
Address line1: yyyyy
Address line2: yyyyy
Address line3: null value.

But we see in the above, address line1 and 2 are updated with new values and address line3 is not getting updated with the null value. It retains the same old value.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center