Forum Stats

  • 3,838,074 Users
  • 2,262,326 Discussions
  • 7,900,495 Comments

Discussions

ORA-01438: value larger than specified precision allowed for this column

Mishra Chandan
Mishra Chandan Member Posts: 249 Blue Ribbon
edited Dec 29, 2019 11:20PM in Planning and Budgeting

Hi Experts,

We are trying to upload the data from Oracle Fusion to PBCS application. Data is getting uploaded for all months except May-18. Whenever we upload this month data we are getting an error: -

ERROR [AIF]: EPMFDM-140274:Message - ORA-01438: value larger than specified precision allowed for this column

Can anyone suggest if this error is due to 12 decimal restrictions? If yes how to deal with this

Thanks & Regards

CM

Tagged:

Answers

  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Dec 29, 2019 11:20PM

    Yes, try looking the precision set in Oracle Fusion Fusion :: How to make Precision or decimals change in currency reflect in the transactions (Doc ID 2273593.1)

    Also, have a look at this doc, Data Load Error In EPBCS Data Management ORA-01438: Value Larger Than Specified Precision Allowed For This Column (Doc ID 2406254.1)

    HTH,

    Dayalan P.