E1: 12: Asset Split (P12106) Fails to Create Account Ledger Transactions (F0911) for the Cost Account on the Tax Ledger (Doc ID 2926062.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

When splitting an Asset (P12106) with two ledgers (AA Ledger and Tax Ledger), the split amounts are correctly calculated for both the original asset and the newly created asset in the Asset Account Balances table (F1202). But in the Account Ledger table (F0911), the AS (Asset Split) document type transactions for the cost account on the tax ledger is missing, resulting in an integrity issue between the Account Ledger (F0911) and Asset Account Balances table (F1202) tables.

Steps to duplicate:

1. P1201 - Asset Master: Create a new asset and set its Original Item Qty the same as Current Item Qty.

2. P1202 - Depreciation Information: Add the depreciation information to the asset as follows:

• On ledger AA set Depreciation Method = 01 & Life Months = 48 & Initial term = blank & Compute Direction = P
• On ledger D1 set Depreciation Method = 01 & Life Months = 36 & Initial term = blank & Compute Direction = P

3. P12851 - Work With Depreciation Rules: Set the depreciation rule for the AA Ledger as follows:

• Allow Over Depreciation = 1
• Allow Negative Depreciation = 1

4. P12853 - Work with Depreciation Formulas: check the Basis and Depreciation formulas:

• Depreciation Formula 101 = 10/03
• Basis Formula 501 = 01-07

5. P0911 – Journal Entry: Enter the Initial Cost and Accumulated Depreciation for the asset, on both AA and D1 ledgers, then post the JEs on the General Accounting and Fixed Assets.

6. R12855 – User Defined Depreciation: Depreciate the asset till the end of the year.

7. R12825 - Asset Account Balance Close: Run the Asset Close and then advance the year and period for the asset's company (P0010), then run R12855 User Defined Depreciation till Period 5 of the current year, inclusive.

8. P1204 – Asset Master: Select the asset, then select Asset Split as follows:

• Method = U
• G/L Date = end date of Period 5 of current year
• Asset Quantity = determining the system to calculate a split percent of 50,99 %.

After the split, notice that the split amounts have been correctly calculated for both the original asset and the newly created asset in the Asset Account Balances File (F1202), but the AS document type transactions for the cost account on the tax ledger are missing in the Account Ledger table (F0911).

Changes

Cause

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