Financial Management - PSFT (MOSC)

MOSC Banner

GL_JEDIT_0 gives error - ORA-01476: divisor is equal to zero

edited Oct 18, 2013 3:02AM in Financial Management - PSFT (MOSC) 10 commentsAnswered
 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

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