Financial Management - PSFT (MOSC)

MOSC Banner

In FIN 9.1, Journal Unpost result to unexpected PS_JRNL_LN.UNPOST_SEQ = 2

edited Aug 12, 2013 8:32PM in Financial Management - PSFT (MOSC) 2 comments

 Performing a Journal Unpost is causing the UNPOST_SEQ on the JRNL_LN table to increment twice (from 0 to 2), likewise, causing it to be out of sequence with the UNPOST_SEQ on the JRNL_HEADER table (changed from 0 to 1).The MONETARY_AMOUNT in PS_JRNL_LN for the unposted journal is the same as the original journal, thus suggesting double entry.

This is observed after applying FMS FINANCIALS 9.1 BUNDLE #25.

The unposting of journals is causing lines to be orphaned because the UNPOST_SEQ value between the JRNL_HEADER and the JRNL_LN table do not match for the same BUSINESS_UNIT, JOURNAL_ID, and JOURNAL_DATE). 

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