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 JULY 31, 2023

Applies to:

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

Symptoms

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

ERROR
After loading data, error is shown thru query:

  Error: Start date must start before end date.


NOTES
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.



Changes

 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

Cause

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
Symptoms
Changes
Cause
Solution
References


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