Receivables - EBS (MOSC)

MOSC Banner

Error at the time of insertion of PAN/TAN number in JAI_CMN_CUS_ADDRESSES table

edited Mar 1, 2013 2:00AM in Receivables - EBS (MOSC) 8 commentsAnswered

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

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