ORA_INV_TRANSACTION_CREATION_DATE_VALIDATION does not seem to work correctly — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA_INV_TRANSACTION_CREATION_DATE_VALIDATION does not seem to work correctly

edited Jun 26, 2025 6:29AM in Inventory Management 4 comments

Hi,

We have some trouble with SETUP: ORA_INV_TRANSACTION_CREATION_DATE_VALIDATION.
If you have any ideas, please let us know.

Our setup is following:

Setup and Maintenance > Manage Inventory Profile Options

INV_TRANSACTION_DATE = No Validation (Profile Level = Site)

ORA_INV_TRANSACTION_CREATION_DATE_VALIDATION = 60 (Profile Level = Site)

However, some Transaction(Sales Order Pick) were created with a transaction date clearly more than 60 days before the creation date.

Is this expected behavior? For example, is the '60 days' setting calculated excluding weekends and only considering business days?

Or, Could there be Inaccuracy in the setup method?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!