EBS Customizations (MOSC)

MOSC Banner

Enter a valid date for FORECAST_START_DATE. and for FORECAST_FINISH_DATE

Hi Team

While uploading file following error ‘Enter a valid date for FORECAST_START_DATE. and for FORECAST_FINISH_DATE’ is coming for custom webadi after EBS upgrade from 12.1.3 to 12.2.10

 

Below is the default value in formula type in webadi layout.

IF(AND([ACTUAL_START_DATE]="",[PV_FORECAST_START_DATE]<>""),TEXT(([PV_FORECAST_START_DATE]),"dd-mmm-yyyy"),IF([ACTUAL_START_DATE]<>"",TEXT(([ACTUAL_START_DATE]),"dd-mmm-yyyy"),IF([PLAN_START_DATE]<=TODAY(),TEXT((TODAY()),"dd-mmm-yyyy"),IF([PLAN_START_DATE]>TODAY(),TEXT(([PLAN_START_DATE]),"dd-mmm-yyyy")))))



Please help.


Thank you,

Nageswar

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center