E1: 12: Uploading Fixed Asset Balances (P12130/P12102/R12800) (Doc ID 641196.1)

Last updated on NOVEMBER 12, 2023

Applies to:

Purpose

Overview

Standard processing of Capitalization of Fixed Assets using a common journal entry approach is discussed in <Document 626063.1> E1: 12: Capitalization of Fixed Assets (Asset Cost Additions) (P12130/P122101/P12102/R12800/R09801).   

Interoperability processing creates the Asset Master (F1201), and if processing option #4 on the default tab of the P1201 is set to a “1” the Asset Account Balance Table (F1202) setup information only, will be created as well – without balances.  However, there isn't a way to create the F1202 records for accumulated depreciation or depreciation expense using the R1201Z1I.  A journal entry will be needed to create F1202 records for accumulated depreciation or depreciation expense.  The Beginning Balance Program P12130 can be used to create F1202 records for the accumulated depreciation.    For additional information on this process, please see “How to Create Asset Master Records Using Interoperability” <Document 626068.1>.

The significant process of adding assets and balances offers various complexities and options that must be carefully considered for applicability depending upon existing circumstances and desired results.  This question with solution option format is intended to provide insight into considerations for pre-planning given current user circumstances and process requirements for completion.   Conceptually then, all fields below must be “Y” when the process is complete, and an ongoing awareness of Fixed Asset to General Accounting integrity maintained throughout the entire process.

Prior to initiating any balance insert to the F1202, a user is advised to evaluate these considerations in a test environment, and calculating R12855 depreciation through current period for inspection:

•  Ensure that a good understanding between F0902 and F1202 production environment integrity status exists, and any necessary adjustments made prior to scalable additions.

•  Depreciation generally being a prime consideration following planned update completion, in a test environment add minimal sample assets that incorporate the depreciation methods and methods of computation, etc. that fairly represent those to be incorporated at scale.

•  A user will find that R12855 depreciation is generally calculated at differing amounts when inserted into a single period, versus that calculated when amounts are added utilizing beginning balance.  For assets with Accumulated Depreciation amounts, a user will typically find that current year beginning balances (F1202: Beg Balance/PYE Forward/FLAPYC) are preferable for import, and provide the necessary accuracy when computing subsequent current year periodic amounts.

If requirements are such that the prior year assets have up-to-date depreciation computed within the current fiscal year, in order to maintain current year computation integrity, a user is advised to populate beginning balances as of end of previous fiscal year - followed with current year balances added separately and in the current year.   See Final Update to Current Year Depreciation Amounts section below. 

The Beginning Balance Program, the P12130 Beginning Balance Setup / Adjustments program represents a manual process.  Note, however, that processing options exist for the program in order to create journal entries for subsequent F0902 posting – if needed.

Scope

Populating new or additional fixed asset balances can represent a complex process.  Experienced users competent in the Fixed Asset system 12 functionality, with particular emphasis and awareness surrounding General Accounting (GA) to Fixed Asset (FA) integrities, will benefit from this discussion.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.