开发者

Oracle: error while trying to use formulas

I created an element with an input value of type "Day" , when i write a formula i get this error.

Any idea what's wrong?

APP-FF-33232: EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE has null or not found allowed, but no default set specified.

Cause: If a Database Item has null allowed, or not found allowed, then the item must also specify a default set to be used to provide default values in the event of these occurring. The item named has one of these c开发者_Go百科onditions allowed, but the default set column in the FF_DATABASE_ITEMS table is null.

Action: Please refer to your local support representative.

-


I'm not an expert in Oracle Apps (to say the least) but the error message is fairly clear. You - or someone - have written a Fast Formula which references a database column EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE. Apparently this column can be nullable, in which case your Formula needs to provide a default value. Something like:

default for EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE is 01-JAN-2010

Or perhaps you can use SYSDATE or CURRENT_DATE rather than a fixed value.


Solution to error: You called database item in Fast formula,

you need to initialize the date to specific date

alias EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE as day

default for day is 01-jan-2010

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜