My Oracle Support Banner

Using WebADI to Load Header Details Requires the Effective From And To Dates To Both be NULL Or Both Not Null Else "Error: Start date must start before end date" (Doc ID 2871020.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.


When attempting to create modifier through WebADI,
populating an effective from date and leaving effective to date as NULL,
the following error occurs.

After loading data, error is shown thru query:

  Error: Start date must start before end date.

Header - the Effective From / To dates have to be both null or both not null.
Expects to be able to enter Effective From Date without Effective To Date
and/or To be able to enter Effective To Date without Effective From Date

The issue can be reproduced at will with the following steps:
1) Download document (create modifier)
2) Prepare data in WebADI spreadsheet, using out of box layout QP Manage Modifiers
  downloaded from Oracle Pricing User
  start date: 01-JAN-2001
  end date: NULL
3) Upload
4)Check for interface error
     Error: Start date must start before end date.


 Patches recently applied:
     <Patch 33411095:R12.QP.C>  ---> This is a consolidation patch for Web ADI feature support from release 12.2.4 to 12.2.8


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.