Reset Records in EX status to BE status

For AR and CR batches that have failed and are in EX (extended) Status

update ar_batch_mstr

set arb_post_state = 'BE'

where arb_batch_id = 'CR000000'

 

For JE batches that have failed and are in EX (extended) Status

update glba_batch_mstr

set glba_post_state = 'BE'

where glba_batch_id = 'JE0000'

 

 

Run APOHUTUC

For Checks that have failed and are in EX (extended) Status

update oh_bir_mstr

set oh_post_state = 'BE'

where oh_ref = 'REQ0000000';

 

Get the oh_batch_id number from oh_bir_mstr table to update post state in the ohh_batch_mstr table

 

update ohh_batch_mstr

set oh_post_state = 'BE'

where oh_batch_id = 'OH0000000';

 

Resetting EFT numbers

NUUPCD – Code Category - APEFT.AP

Reset Associated Numeric Values

Value 1:

Value 2:

Details

Article ID: 158873
Created
Mon 11/13/23 11:19 AM