Case 00043082 – FA GL Transfer Batch IDs Stuck on Depreciation Period

FA GL Transfer Batch IDs Stuck on Depreciation Period

Case Number	00043082
Oracle Module	Fixed Assets (FA)
EBS Version	R12
Functional Area	FA Depreciation / GL Transfer
Related Patches	None

Symptoms

The FA Create Journal Entries (or GL Transfer) process for a depreciation period fails or cannot be re-run.
FA_DEPRN_PERIODS shows non-null batch IDs (e.g., depreciation_batch_id, transfer_batch_id, GL_TRANSFER_FLAG) for a period that needs to be re-transferred.
The GL_TRANSFER_FLAG is not NULL, preventing the GL Transfer process from running again for the period.
FA_DEPRN_DETAIL and FA_ADJUSTMENTS rows for the period have je_header_id values that point to journal headers that were deleted or not properly created.

Root Cause

A failed or incomplete GL Transfer run left batch ID and journal header references on the Fixed Assets period and detail tables. These references signal to the FA system that the transfer is complete, but the corresponding GL journal entries were not successfully created. Clearing the batch IDs and journal references allows the GL Transfer process to be re-run for the affected period.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. Backup tables are created for:

FA_DEPRN_PERIODS — the affected period record
FA_ADJUSTMENTS — adjustments for the period
FA_DEPRN_DETAIL — depreciation detail records for the period
FA_JOURNAL_ENTRIES — the stuck journal entry record
FA_ADJUSTMENTS — backup of the specific errored asset transfer record

Step 2 – Clear batch IDs and GL transfer flag from FA_DEPRN_PERIODS

Update FA_DEPRN_PERIODS for the affected book and period counter to NULL out all batch ID columns:

depreciation_batch_id, retirement_batch_id, reclass_batch_id, transfer_batch_id
addition_batch_id, ADJUSTMENT_BATCH_ID, deferred_deprn_batch_id
reval_batch_id, deprn_adjustment_batch_id, CIP batch IDs
GL_TRANSFER_FLAG = NULL

Step 3 – Clear journal line references from FA_DEPRN_DETAIL

Update FA_DEPRN_DETAIL for the affected book and period counter to NULL out deprn_expense_je_line_num, deprn_reserve_je_line_num, bonus journal line numbers, and je_header_id.

Step 4 – Clear je_header_id from FA_ADJUSTMENTS

Update FA_ADJUSTMENTS for the affected book and period counter to NULL out je_header_id and related journal line number columns.

Step 5 – Commit and re-run GL Transfer

Issue COMMIT. Re-run the FA Create Journal Entries (GL Transfer) process for the affected book and period.

Note: The book type code in the original script references a specific asset book. Verify the correct book type code and period counter before running this fix.

Script Inventory

File	Description
data_fix.sql	Creates backups; clears all batch IDs and GL_TRANSFER_FLAG from FA_DEPRN_PERIODS; clears je_header_id from FA_DEPRN_DETAIL and FA_ADJUSTMENTS for the affected book and period. Allows GL Transfer to be re-run.

Key Tables Affected

Table	Action
FA_DEPRN_PERIODS	NULL out all batch IDs and GL_TRANSFER_FLAG
FA_DEPRN_DETAIL	NULL out je_header_id and journal line number columns
FA_ADJUSTMENTS	NULL out je_header_id and journal line columns
FA_JOURNAL_ENTRIES	Backup only