General Ledger - EBS (MOSC)

MOSC Banner

Settlement_Dt on JRNL_CF_BAL_TBL when a Journal is Imported

edited Nov 29, 2017 8:00AM in General Ledger - EBS (MOSC) 2 commentsAnswered

When a journal is imported and then edited, and the journal has errors, a record on the  JRNL_CF_BAL_TBL gets created with todays date for the settlement_dt.  When you add lines to the journal to have the debits and credits equal, (the next day) because the journal import runs on batch at night, ANOTHER Jrnl_CF_BAL_TBL record gets created with the current date  for example - one record with a settlement_dt of yesterday and one with a settlement_dt of today.   The journal is now balanced BUT we get the error - 'Journal is not balanced on journal totals or balancing ChartField totals'.  

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