GL_JEDIT_0 gives error - ORA-01476: divisor is equal to zero
We recently went to 9.1 bundle #23 from bundle #11 and now users are getting frequent errors in journal edit because the ACTUALS journal is missing the divisor rate, when the journal is entered to LOCAL. Other rows are assigned the rates fine.
To find the errors we use the SQL,
select l.business_unit, l.journal_id, l.journal_date, l.journal_line, l.ledger, l.account, l.monetary_amount, l.currency_cd, l.foreign_amount, l.foreign_currency, l.rate_div, l.rate_mult, l.process_instance, h.jrnl_hdr_status, h.journal_locked
from ps_jrnl_ln l , ps_jrnl_header h
0