My Oracle Support Banner

How To Remove An Existing Value From Item Sim Set Via Collections - IMM.dat File Load (Doc ID 2302022.1)

Last updated on SEPTEMBER 18, 2022

Applies to:

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


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.


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

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