1.How To Transfer The Journals To GL That Have Already Previously
Been Accounted By Create Accounting?
Answer:
Create Accounting does have the option to transfer to GL for the user's convenience to allow both in a one-step process. If Create Accounting was run successfully with this parameter set to No, the records will not be picked up again when Create Accounting is run again.Instead, one needs to run program Transfer Journal Entries to GL - Assets to transfer any accounting that is created in Final mode, but not transferred.
Navigate: Fixed Assets Responsibility > Other > Requests > Run > Select and Submit the Transfer Journal Entries to GL - Assets program (FAGLTRN) with parameters to include the journal entries to be transferred.
If the program does not exist for the Assets request group you are using, you should be able to add it to your request group for FA.
- Log on Sysadmin responsibility
- Navigate to Security > Responsibility > Define
- Query the FA responsibility you are using
- Check the name of the Request Group assigned to it
- Back to the menu, navigate to Security > Responsibility > Request
- Query the Request Group
- Add the program Transfer Journal Entries to GL - Assets to the list from the LOV.
Save the changes.
Now you can run the program Transfer Journal Entries to GL - Assets.
Answer:
Create Accounting does have the option to transfer to GL for the user's convenience to allow both in a one-step process. If Create Accounting was run successfully with this parameter set to No, the records will not be picked up again when Create Accounting is run again.Instead, one needs to run program Transfer Journal Entries to GL - Assets to transfer any accounting that is created in Final mode, but not transferred.
Navigate: Fixed Assets Responsibility > Other > Requests > Run > Select and Submit the Transfer Journal Entries to GL - Assets program (FAGLTRN) with parameters to include the journal entries to be transferred.
If the program does not exist for the Assets request group you are using, you should be able to add it to your request group for FA.
- Log on Sysadmin responsibility
- Navigate to Security > Responsibility > Define
- Query the FA responsibility you are using
- Check the name of the Request Group assigned to it
- Back to the menu, navigate to Security > Responsibility > Request
- Query the Request Group
- Add the program Transfer Journal Entries to GL - Assets to the list from the LOV.
Save the changes.
Now you can run the program Transfer Journal Entries to GL - Assets.
2.How Is Depreciation Catchup Charged In Period Of Addition sent
To GL In Release 12?
Answer:
When an asset is added as Expensed with backdated Date Placed in Service ,the application calculates depreciation catchup in the period of addition.
In Release 11i, this depreciation catchup is part of the Depreciation Journal which is created after running Depreciation.
For example, an asset is added in period SEP-08 as Expensed with cost =1000 and Prorate date= 01-JAN-2008 .
Depreciation Method is Table based on Cost with rate=0.5 in first year
Depreciation catchup is charged for January 2008 to August 2008 = 1000 * .5 /12 * 8 = 333.33
Hence in release 11i following Journal entries are sent to GL:
Addition Journal in R11i
Dr. Asset Cost 1000.00
Cr. Asset Clearing 1000.00
Depreciation Journal in R11i
Dr. Depreciation Expense (Adjustment) 333.33
Dr. Depreciation Expense 41.67
Cr. Accumulated Depreciation 375.03
In Release 12 , with the SLA model , behavior has been changed : the expense is allocated to the event that drove it.
As the backdated addition is what spawned the depreciation catchup , it is now tracked at the event level for that
transaction accordingly.
This is the reason why the depreciation catchup is included in the Addition Journal
Addition Journal in R12
Dr. Asset Cost 1000.00
Dr. Depreciation Expense (Adjustment) 333.33
Cr. Asset Clearing 1000.00
Cr. Accumulated Depreciation 333.33
Depreciation Journal in R12
Dr. Depreciation Expense 41.67
Cr. Accumulated Depreciation 41.67
Answer:
When an asset is added as Expensed with backdated Date Placed in Service ,the application calculates depreciation catchup in the period of addition.
In Release 11i, this depreciation catchup is part of the Depreciation Journal which is created after running Depreciation.
For example, an asset is added in period SEP-08 as Expensed with cost =1000 and Prorate date= 01-JAN-2008 .
Depreciation Method is Table based on Cost with rate=0.5 in first year
Depreciation catchup is charged for January 2008 to August 2008 = 1000 * .5 /12 * 8 = 333.33
Hence in release 11i following Journal entries are sent to GL:
Addition Journal in R11i
Dr. Asset Cost 1000.00
Cr. Asset Clearing 1000.00
Depreciation Journal in R11i
Dr. Depreciation Expense (Adjustment) 333.33
Dr. Depreciation Expense 41.67
Cr. Accumulated Depreciation 375.03
In Release 12 , with the SLA model , behavior has been changed : the expense is allocated to the event that drove it.
As the backdated addition is what spawned the depreciation catchup , it is now tracked at the event level for that
transaction accordingly.
This is the reason why the depreciation catchup is included in the Addition Journal
Addition Journal in R12
Dr. Asset Cost 1000.00
Dr. Depreciation Expense (Adjustment) 333.33
Cr. Asset Clearing 1000.00
Cr. Accumulated Depreciation 333.33
Depreciation Journal in R12
Dr. Depreciation Expense 41.67
Cr. Accumulated Depreciation 41.67
3.Can the Payables Code Combination Identifier (PAYABLES_CCID) be
used as a source for accounts other then the Asset Clearing account?
Answer:
No, it cannot be used as a source for any other account then the clearing account as the PAYABLES_CCID is not loaded for e.g. the Cost account. It is only loaded for the Clearing account. Validate Application Accounting Definitions and Create Accounting will not fail, it will just simply not load and use it.
It would also be problematic as e.g. what would happen if a second invoice with a different Clearing Account from AP would be added or if a source line transfer would be performed or a retirement? The system could only use one CCID.
Instead, there are 2 other options available:
1. One can use the value in the Expense account combination entered in the Prepare Mass Additions form or
2. Set up a descriptive flexfield to contain that value set and enter the segment value there when creating the asset.
Answer:
No, it cannot be used as a source for any other account then the clearing account as the PAYABLES_CCID is not loaded for e.g. the Cost account. It is only loaded for the Clearing account. Validate Application Accounting Definitions and Create Accounting will not fail, it will just simply not load and use it.
It would also be problematic as e.g. what would happen if a second invoice with a different Clearing Account from AP would be added or if a source line transfer would be performed or a retirement? The system could only use one CCID.
Instead, there are 2 other options available:
1. One can use the value in the Expense account combination entered in the Prepare Mass Additions form or
2. Set up a descriptive flexfield to contain that value set and enter the segment value there when creating the asset.
4.How to setup the secondary ledger so that the results of the
corporate FA book journals to be generated for the secondary ledger also?
Answer:
Perform the following steps in order that the secondary ledger to have generated the journals corresponding to the corporate book:
a. Go to Accounting Setup Manager form from FA responsibility:
(N) Setup > Financials > General Ledger > Accounting Setup Manager > Accounting
Setups
b. Query for your ledger.
c. Press Update button for your Secondary Ledger.
d. In the ledgers form, press Update button for Subledger Accounting Options of your secondary ledger.
e. For Assets application press Update Accounting Options button.
f. Ensure that Subledger Acounting Enabled and Use Primary Ledger Amounts options are set to Yes. If they are not set to Yes then please set them and press Apply button.
g).Go to the Assets application and submit again Create Accounting request for the corporate book as Draft and with
Detail level. You should be able to see now in the Create Accounting output the secondary ledger journals associated with the corporate book.
Answer:
Perform the following steps in order that the secondary ledger to have generated the journals corresponding to the corporate book:
a. Go to Accounting Setup Manager form from FA responsibility:
(N) Setup > Financials > General Ledger > Accounting Setup Manager > Accounting
Setups
b. Query for your ledger.
c. Press Update button for your Secondary Ledger.
d. In the ledgers form, press Update button for Subledger Accounting Options of your secondary ledger.
e. For Assets application press Update Accounting Options button.
f. Ensure that Subledger Acounting Enabled and Use Primary Ledger Amounts options are set to Yes. If they are not set to Yes then please set them and press Apply button.
g).Go to the Assets application and submit again Create Accounting request for the corporate book as Draft and with
Detail level. You should be able to see now in the Create Accounting output the secondary ledger journals associated with the corporate book.
5.R12: How To Transfer Reconciliation References From FA Subledger
To GL?
Answer:
Navigation: Setup > Financials > Subledger Accounting > Accounting Methods Builder > Journal Entry Setups > Journal Line Types
a. Query a seeded Journal Line Type and copy it by clicking on the Copy button at the bottom left of the form
b. Give your Journal Line Type code, name, and description a meaningful name.
c. Click on the Accounting Attribute Assignments button at the bottom right of the form
d. Pick a source for the Reconciliation Reference
e. Save.
Navigation: Setup > Financials > Subledger Accounting > Accounting Methods Builder > Methods and Definitions > Journal Line Definitions
f. Link the Journal Line Type just created to the Journal Line Definition. Copy a seeded one and create your own if needed.
g. Assuming that the JLD is already linked to the Application Accounting Definition, validate the Application Accounting Definition either in the form or via the concurrent program 'Validate Application Accounting Definitions'.
Assuming also that the Application Accounting Definition is already linked to the Subledger Accounting Method which in turn is already linked with the ledger, Create Accounting can now be run.
h. Once Create Accounting, Journal Import and the Post program in GL have completed, one can reconcile either manually or run Automatic reconciliation in GL.
Answer:
Navigation: Setup > Financials > Subledger Accounting > Accounting Methods Builder > Journal Entry Setups > Journal Line Types
a. Query a seeded Journal Line Type and copy it by clicking on the Copy button at the bottom left of the form
b. Give your Journal Line Type code, name, and description a meaningful name.
c. Click on the Accounting Attribute Assignments button at the bottom right of the form
d. Pick a source for the Reconciliation Reference
e. Save.
Navigation: Setup > Financials > Subledger Accounting > Accounting Methods Builder > Methods and Definitions > Journal Line Definitions
f. Link the Journal Line Type just created to the Journal Line Definition. Copy a seeded one and create your own if needed.
g. Assuming that the JLD is already linked to the Application Accounting Definition, validate the Application Accounting Definition either in the form or via the concurrent program 'Validate Application Accounting Definitions'.
Assuming also that the Application Accounting Definition is already linked to the Subledger Accounting Method which in turn is already linked with the ledger, Create Accounting can now be run.
h. Once Create Accounting, Journal Import and the Post program in GL have completed, one can reconcile either manually or run Automatic reconciliation in GL.
6.How to avoid the transfer to GL of the journal entries related
to the tax book in R12 ?
Answer:
This is the intended functionality to create the accounting entries in SLA for both the corporate book and the tax book as it is required for reporting. However, the accounting entries for the tax book can be prevented from being transferred to GL by keeping the check box 'Allow GL Posting' unchecked for the tax book in the Book Controls screen.
Answer:
This is the intended functionality to create the accounting entries in SLA for both the corporate book and the tax book as it is required for reporting. However, the accounting entries for the tax book can be prevented from being transferred to GL by keeping the check box 'Allow GL Posting' unchecked for the tax book in the Book Controls screen.
7.The CODE_COMBINATION_ID column in the FA_ADJUSTMENTS table
contains NULL values in Oracle Applications Release 12 Why ?
Answer:
This is one of the main changes related to Subledger Accounting (SLA) in R12. The account combination is generated during the Create Accounting process and it is stored in the SLA tables.
The CODE_COMBINATION_ID column is now populated only for:
- Unplanned depreciation
- Cost clearing account for invoice lines from Payables (AP)
Answer:
This is one of the main changes related to Subledger Accounting (SLA) in R12. The account combination is generated during the Create Accounting process and it is stored in the SLA tables.
The CODE_COMBINATION_ID column is now populated only for:
- Unplanned depreciation
- Cost clearing account for invoice lines from Payables (AP)
8.How to Show The Error Messages In The Create Accounting For
Assets Program If It Completes With Warning ?
Answer:
To show why the 'Create Accounting - Assets' program completed with warning, re-run it with the parameter 'Report' value set to 'Detail' or to 'Summary' to show the error number and error message in the 'Subledger Accounting Program Report.'
Answer:
To show why the 'Create Accounting - Assets' program completed with warning, re-run it with the parameter 'Report' value set to 'Detail' or to 'Summary' to show the error number and error message in the 'Subledger Accounting Program Report.'
This comment has been removed by the author.
ReplyDeleteHi Raju,
ReplyDeleteFirstly, this is a very useful article so thank you for sharing your knowledge.
I am new to the Oracle R12 world, I have a question and I hope you can help.
Basically, I would like to know how to setup the secondary ledger so that the results of the corporate FA book journals are also generated for the secondary ledger that is using a 4-4-5 calendar for management reporting?
I hope above makes sense and thank you in advance for your help and support in this matter.
Regards,
Arun