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 laterInformation 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 |