Hi Friends,
I have been facing an error like
"ORA-01438: value larger than specified precision allowed for this column"
when running a particular job.I had checked with the data size and found nothing wrong in that.
Could anyone please help me regarding this issue.
Thanks,
Vijay.
ORA : 1438
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
ORA : 1438
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
HI Hamzaqk,hamzaqk wrote:Can only tell if i had some sample rows and what metadata is defined in your oracle stage
Thank you for your responce.Please find the below details.
The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 6477 AC_STAT_SID = 14538 AC_SCHD_ST_SID
= 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20080401 AC_CUR_END_SID = 20090331 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 148411311.58 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0 AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT =
The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 6834 AC_STAT_SID = 14538 AC_SCHD_ST_SID = 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20070101 AC_CUR_END_SID = 20090531 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 0 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0
AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT = 0
The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 7589 AC_STAT_SID = 14538 AC_SCHD_ST_SID
= 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20070101 AC_CUR_END_SID = 20090531 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 0 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0
AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT = 0
The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 7615 AC_STAT_SID = 14538 AC_SCHD_ST_SID
= 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20070101 AC_CUR_END_SID = 20090531 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 0 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0
AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT = 0
Column name SQL Type Length
----------- -------- ------
SRC_SYS_ID Char 5
SNAP_DT_SID Decimal 19
AC_SID Decimal 20
AC_STAT_SID Decimal 20
AC_SCHD_ST_SID Decimal 20
AC_SCHD_END_SID Decimal 20
AC_CUR_ST_SID Decimal 30
AC_CUR_END_SID Decimal 20
AC_ACT_ST_SID Decimal 20
AC_ACT_END_SID Decimal 20
AC_CMPLTD_PCT Decimal 20
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This forum is for "Forum for Master Data Management theory and Razza Dimension Server - a Master Data Management software application". Please don't encourage posting in the wrong place by answering.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.