ORA-01830: date format picture ends before convert

[siva27]

I have created pre-insert Trigger at master % detail blocks.

in the master & details tables i have WHO columns in the back-end.
BEGIN
SELECT JVG_HEADER_ID_SEQ.nextval INTO :XX_JVG_CATALOG_HEADER.CAT_HEADER_ID FROM DUAL;
Fnd_Standard.set_who;
END;

Error : ORA-01830: date format picture ends before converting entire input string

How to over come this problem.

Regards
Siva

[siva sankar]

Hi Siva,

Error: ORA-01830: date format picture ends before converting entire input string
Cause: You tried to enter a date value, but the date entered did not match the date format.
Action: The options to resolve this Oracle error are:
This error can occur when you try to enter a date value without using the to_date function.
In Oracle, the default date format is generally DD-MON-YYYY. If you try to enter a date value that does not comply with this format, you need to use the to_date function.

For example, if you tried to execute the following SQL statement:

INSERT INTO supplier
VALUES
(1, 'IBM', '13-DEC-2004 6:56 PM');



You would receive the following error message:

ORA-01830: date format picture ends before converting entire input string



To correct this error, you can use the to_date function as follows:

INSERT INTO supplier
VALUES
(1, 'IBM', to_date('13-DEC-2004 6:56 PM', 'dd-mon-yyyy hh:mi PM'));

[siva27]

Hi Siva Sankar,

I'm using the Fnd_Standard.set_who; in the pre-insert procedure.
When ever i click in Form Front end by clicking SAVE button ,
This is how i'm getting the Error.

In forms where will be the Fnd_Standard.set_who; will be available.If u have idea can u please explane me in detail.

if possible u can mail me @ sivaprasad_14@yahoo.com