General Ledger - EBS (MOSC)

MOSC Banner

Create Journals Program to Remove STATUS_CODE = 'T' rows with fatal crash

edited Mar 29, 2019 5:00AM in General Ledger - EBS (MOSC) 1 commentAnswered

This program also deletes transactions in the GL_BC_PACKETS table in the following situations:

    

STATUS_CODE = 'R': Rejected summary and detail account rows older than the user-specified Minimum Save Time.     

STATUS_CODE = 'S': successful Funds Check Complete rows older than the user-specified Minimum Save Time.     

STATUS_CODE = 'F': failed Funds Check rows older than the user-specified Minimum Save Time.     

STATUS_CODE = 'T' rows with fatal crash older than 24 hours.     

STATUS_CODE = 'P' pending rows older than 120 hours (five days).     

STATUS_CODE = 'C' checking rows older than 120 hours (five days).     

User cannot specify which STATUS_CODE to delete, and there is no way of knowing whether the pending transactions are from some reservation that has not yet been fully processed or if it is from a failed reservation, and other users are clearing the funds by increasing the budget.  Would like to delete transactions with STATUS_CODE = 'T'.

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