How To Remove An Existing Value From Item Sim Set Via Collections - IMM.dat File Load

(Doc ID 2302022.1)

Last updated on SEPTEMBER 04, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.1 and later
Information in this document applies to any platform.

Goal

I have an item simulation set that I'm using self-service collections and the IMM dat file to update.
For character fields, I can enter a value of NULL into a field and have it effectively remove the field from the sim set.
How do I do this for a number field such as Fixed Order Quantity?
If I enter NULL into the excel file and then create the extract, the loader worker tries to upload "NULL" into a number field and errors out.

Functionally, I want to remove the existing numeric value from the field in the sim set (set it to null), not use the sim set to remove any FOQ that is on the item master when a plan uses the simulation set.
 

Solution

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