Error at the time of insertion of PAN/TAN number in JAI_CMN_CUS_ADDRESSES table
issue :- when ever i am trying to run concurrent program for insert/update in JAI_CMN_CUS_ADDRESSES table from front end. will get following error.
error:(Current system time is 28-FEB-2013 19:05:56
+---------------------------------------------------------------------------+
**Starts**28-FEB-2013 19:05:56
ORACLE error 1722 in FDPSTP
Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.CRISIL_AR_CUSTOMER_PKG", line 1029
ORA-06512: at "APPS.CRISIL_AR_CUSTOMER_PKG", line 982
ORA-06512: at line 1
The SQL statement being executed at the )
but if we call same program from back end(TOAD) record get inserted roperly..
Kindly suggest.
Regards,
Sonam