Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Applying 11.5.10.2 Maintenance Pack causes DB to crash

edited Aug 20, 2021 10:01AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered
While Applying maintenance pack Oracle 11.5.10.2  one of the workers fail on the following query:

    select IGI.ROWID ROW_ID,

         to_number(gjl.reference_3) cash_basis_distribution_id

         , GJL.set_of_books_id,

          sign( nvl(entered_cr,0) - nvl(entered_dr,0) )

         * abs(nvl(entered_cr,0) - nvl(entered_dr,0))   correct_amount

         , IGI.amount

         , sign( nvl(accounted_cr,0) - nvl(accounted_dr,0) )

         * abs(nvl(accounted_cr,0) - nvl(accounted_dr,0)) correct_acctd_amount

         , IGI.acctd_amount, to_number(gjl.reference_1) posting_control_id

    from   GL_JE_LINES GJL, igi_ar_cash_basis_dists_all IGI,

           GL_JE_HEADERS GJH

    where  GJL.reference_10 = 'AR_CASH_BASIS_DISTRIBUTIONS'

Tagged:

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