This discussion is archived
2 Replies Latest reply: Nov 15, 2012 10:21 AM by lxiscas RSS

form with report, where some items in the form have been given values.

lxiscas Newbie
Currently Being Moderated
Hi, greetings:

I have a question that maybe silly but annoying to me. I need to provide a form with report, where some items in the form have been given values automatically, and these items (display only) are supposed to show given values in the form automatically.

I used the APEX form with report. The update and delete worked well. But I cannot show automatic values when insert. By default APEX insert form makes every item null; I tried to give value for two items: P5212_USERKEY, P5212_DAILY_VER_DATE with process before header, after header, after regions and before footer, and computation, or set values of these two items in the branch when user hit create button (submit). It never worked out, the two items always displayed null value, and when I insert, I got "ORA-01400: cannot insert NULL into ("TBSBI"."DAILYVERPRODNOTE"."USERKEY")", since I have set up constraint in database that these two columns should not be null.

Could anyone help on this? any suggestion would be appreciated.

Sam

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points