Script for Fixed Assets Books Close Status
In generally FA need to be closed before the GL is closed.. in some cases if the business is not following the process correctly, then in that case business can close the GL before the other subledgers are being closed..
We have seen a case where the GL books were closed before the FA books were closed. There was a process GAP between the teams.. they need to announce/inform the other teams about their closing schedules but where it was failing because of that they closed the GL before we close the FA..
In such Scenarios, based on the business decession we can proceed with the below approaches
- Either we have to re open the GL Period and need to run create accounting in FA and need to Transfer all those entries to GL.
- Else, we need to open the GL Period which is closed and need to do the Accounting and transfer those entries to GL with NO Posting and need to move them in GL to the next period, so that the current month balances will not get changed.
- Third option is we need to create an SR with oracle to get the data fix/script to Sweep those unaccounted transactions/additions/merge/split/ retire activities and need to move it to Next period.
Below is the script to check the period close status for the Fixed Asset Module ..
SELECT *
FROM apps.fa_book_controls fbc
,apps.fa_deprn_periods fdp
WHERE fbc.set_of_books_id in (‘2173′,’2331’)
AND fbc.book_type_code = fdp.book_type_code
AND UPPER (fdp.period_name) = UPPER (:PERIOD_NAME)
