[PostgreSQL] Truncate Table and Reset Sequence

If we need that after TRUNCATE table, also reset the SEQUENCE then we can do this step :

1. Set the minimum value of the sequence

alter sequence mytable_id_seq minvalue 0 start with 1;

2. Now either reset it:

SELECT setval('mytable_id_seq', 0)

OR we can reset it while truncating:

truncate mytable restart identity;

[Oracle EBS] GL Journals Stuck With Funds Status In Process

Our finance team has an issue with their journals. The GL Journal Batch is stuck with Funds Reservation “In Process”. This journal cannot be posted or edited.

 

CAUSE

The issue usually has been caused by getting a connection/network error or PC hanging while in the process of reserving Funds for a GL Journal Entry.

SOLUTION

A datafix has been required to fix these issues. The datafix essentially clears out gl_bc_packets & gl_bc_packet_arrival_order of any fund reservation entries for the batch & sets the je batch back to an an unreserved status.  Then the user should take another shot at reserving the journal.

To fix the problem Journal Entries follow these steps.

1.  Get the JE_BATCH_ID using the batch NAME from GL_JE_BATCHES.

         SELECT JE_BATCH_ID
         FROM GL_JE_BATCHES
         WHERE NAME = '000-30062018-4251.02 02-JUL-2018 11:16:31'

2.  Delete all of the records out of GL_BC_PACKETS
         
         select * from gl_bc_packets where je_batch_id='3219763'
        
         DELETE GL_BC_PACKETS WHERE JE_BATCH_ID = '3219763'
        

3.  Change the BUDGETARY_CONTROL_STATUS = R in the GL_JE_BATCHES table @
for the specific JE_BATCH_ID.
        
         select * from GL_JE_BATCHES WHERE JE_BATCH_ID = '3219763' --status asli U
        
         UPDATE GL_JE_BATCHES
         SET BUDGETARY_CONTROL_STATUS = 'R' WHERE JE_BATCH_ID ='3219763'

Reference : 

- Oraclefedapps