General Ledger - EBS (MOSC)

MOSC Banner

"Posting: Single Ledger" concurrent request hanging

edited Feb 10, 2016 5:08PM in General Ledger - EBS (MOSC) 11 commentsAnswered


Posting: sinlge ledger concurrent program someitmes hangs and does not comlpete.  it remains in running status untill we terminate it and post manually the journals.

there is also a workaround we apply each time it hangs:

  1. Cancel the posting programs
    (Posting Single Ledger) using Auto.request (XXBA: Scheduled Programs
    responsibility)
  2. Create table gl_bc_packets_hists_bkp_DDMMYY as select * from
    GL_BC_PACKETS_HISTS;
  3. Truncate table GL.GL_BC_PACKETS_HISTS;
  4. Insert into GL_BC_PACKETS_HISTS (select* from
    GL_BC_PACKETS_HISTS_BKP_ DDMMYY)
  5. Commit;
  6. Run Gather Table statistics (GL, gl_bc_packets, 100, , , NOBACKUP,
    DEFAULT, LASTRUN, Y)   
  7. Run Gather Table statistics (GL, gl_bc_packets_hists, 100, , ,

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