General Ledger FAQ for Segment Security Rules

By // No comments:


I have defined a security rule and assigned it to my responsibility. Why does it still not work?

Make sure that you have enabled security at both the segment and value set levels, it must be enabled at both these levels to work.
Also make sure you have switched out and back into the responsibility.

My security rules don't work for the Account Analysis and General Ledger reports in Release 11.0.3.

This functionality is available starting in Release 11i. In Releases 11 and lower, one cannot set security for standard reports. Security Rules will only limit users from a few functions (e.g. Account Inquiry, Budgets, Journal Entries, and FSGs). In addition,in Release 11i there is limited use of the security rule functionality for running standard reports.
If your goal is to restrict users from submitting reports for a particular company, then this cannot be accomplished using security rules.

When using the intercompany segment, can I have a security rule on the balancing segment (company) without affecting the intercompany segment, since they share the same value set?

Yes it is possible. You would enable security on the value set, but then on the flexfield segment (intercompany) you would not enable security.


How can I assign different security rules to a responsibility based on the User ID?

You cannot apply different security rules to the same responsibility for different users based on the user ID. You will have to create a new responsibility and define its own security rules. Then you can assign the new responsibility to one of the users.

Can I use security rules to control the posting of journal entries?

Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted.

When I perform a query, Security rules don't seem to work on all forms, why?

Flexfield Value Security gives you the capability to restrict the set of values a user can use during data entry. With easy-to-define security rules and responsibility level control, you can quickly set up data entry security on your flexfield segments and report parameters.

Flexfield Value Security lets you determine who can use flexfield segment values and report parameter values. Based on your responsibility and access rules that you define, Flexfield Value Security limits what values you can enter in flexfield pop-up windows and report parameters.


Security rules for the Accounting Flexfield also restrict query access to segment values in the Account Inquiry, Funds Available, and Summary Account Inquiry windows. In these windows, you cannot query up any combination that contains a secure value.

However in all other forms, you will be able to query up a value even if it is restricted to the user.


Can I use Security Rules to prevent users in one organization (in the same set of books) from adding Cross Validation Rules to another organization?

There is no way in the same set of books, to prevent users from one operating unit via security rules, from changing cross validation rules for another operating unit. The only way to do this would to be create a separate set of books for each operating unit. Since security rules prevent users from either viewing data or entering data in general, they do not pertain to set up issues such as creating cross validation rules. Therefore, the only other way to prevent one user from one organization from creating cross-validation rules to the other organization, when in the same set of books, would be to completely remove that menu function from the user.

Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, a journal from one country can be posted by a user of another country. How is this possible?

This is working as intended. Security rules will prohibit a responsibility from being able to enter or review certain values. However security rules will not prohibit the actions above because they are in the same set of books. The system does not determine if a journal has values in it that are blocked by security rules. If it did that, the journal would appear as unbalanced. There would have to be an incredible amount of logic involved, which would further reduce performance, for the posting program to scan the journal for security rules first before posting. Posting does not take into consideration the rules, this is done at the time of journal entry.

I forgot to check the security enabled flag for each segment and now it is not updateable. How do I correct this?

Check your Accounting Flexfield structure to see if it is frozen. Unfreeze the structure, then you should be able to enable Security for the Segment.


Can I delete an Exclude statement in order to resolve a Security Rule issue?

The Security rule should not be modified by deleting an exclude or include as it may corrupt the rule. Instead, delete all rule lines (include and excludes), save and redefine the include and excludes. If the rule still doesn't work, create a new rule and assign it to the responsibilities in place of the original rule.

What standard reports have security enabled in Release 11i?

Trial Balance, Account Analysis and General Ledger are the only standard reports in Release 11i for which security rules apply.

Must I use a universal Include when setting up rules?

It is recommended by development to start each security rule with a universal Include statement and then eliminate each value using Exclude statements.

What functions do security rules apply to?

Security rules apply to Account Inquiry, budgets, FSG's and journal entry functions.
Since Release 11i this also applies to several standard reports.
Please note, they do not apply to the posting of journals or the review of journals. When reviewing a journal with security rules, the totals are still displayed, it is only the individual lines with secured accounts that are not visible. This is standard functionality.

 

 


 

 

Security Rules In R12

By // 8 comments:
Security Rules In R12:

Define segment value security rules to restrict user access to certain segment values when entering journals, performing online inquiries, and running FSG and some standard reports. Segment value security rules can work alone or with data access set security that secures data in ledgers, balancing segment values, or management segment values.

Define Security Rules:

Navigation: General Ledger --> Setup --> Financial --> Flexfields --> Key --> Security --> Define.

To define security rules:
1. Navigate to Define Security Rules window.
2. In the Segment Values block, identify the value set to which your values belong. You can identify your value set or by the flexfield segment or concurrent program parameter that uses the value set.
3. In the Security Rule region, enter a name and description for your security rule.
4. Enter a message for this security rule. This message appears automatically whenever a user enters a segment value that violates your security rule.
5. Define the security rule elements that make up your rule.
6. Save your changes.

Defining Security Rule Elements

You define a security rule element by specifying a value range that includes both a low and high value for your segment. A security rule element applies to all segment values included in the value range you specify. You identify each security rule element as either Include or Exclude, where Include includes all values in the specified range, and Exclude excludes all values in the specified range. Every rule must have at least one Include rule element, since a rule automatically excludes all values unless you specifically include them. Exclude rule elements override Include rule elements. You should always include any default values you use in your segments or dependent value sets. If the default value is secured, the flexfield window erases it from the segment as the window opens, and the user must enter a value manually. If you want to specify a single value to include or exclude, enter the same value in both the Low and High fields.
Minimum and maximum possible values The lowest and highest possible values in a range depend on the format type of your value set. For example, you might create a value set with format type of Number where
the user can enter only the values between 0 and 100. Or, you might create a value set with format type of Standard Date where the user can enter only dates for the current year (a range of 01-JAN-2008 to 31-DEC-2008, for example). For example, if your format type is Char, then 1000 is less than 110, but if your format type is Number, 110 is less than 1000. The lowest and highest possible values in a range are also operating system dependent. When you use a Char format type for most platforms (ASCII platforms),
numeric characters are "less" than alphabetic characters (that is, 9 is less than A), but for some platforms (EBCDIC platforms) numeric characters are "greater" than alphabetic characters (that is, Z is less than 0). The window gives you an error message if you specify a larger minimum value than your maximum value for your platform.
If you leave the low segment blank, the minimum value for this range is automatically the smallest value possible for your segment's value set. For example, if the value set maximum size is 3 and Right-justify and Zero-fill Numbers is checked, the minimum value is 000. However, if the value set has a maximum size of 3, has Numbers Only checked and Right-justify and Zero-fill Numbers unchecked, the minimum value is 0.
If you leave the high segment blank, the maximum value for this range is automatically the largest value possible for your segment's value set. For example, if the value set maximum size is 3 and Numbers Only is checked, the maximum value is 999. However, 5-18 Oracle Applications Flexfields Guide
if the value set maximum size is 5, and Numbers Only is checked, the maximum value is 99999.
Tip: Use blank segments to specify the minimum or maximum possible values for a range to avoid having operating system dependent rules. Note that security rules do not check or affect a blank segment value (null value).

To define security rule elements:
1. In the Security Rule Elements block, select the type of security rule element. Valid
types are:
Include Your user can enter any segment value that falls in the
following range.
Exclude Your user cannot enter any segment value that falls in
the following range.
2. Enter the low (From) and high (To) ends of this value range. Your value does not
have to be a valid segment value.



Assigning Security Rules:

Navigation: General Ledger --> Setup --> Financial --> Flexfields --> Key --> Security -->Assign.

To assign security rules:

1. Navigate to Assign Security Rules window.
2. In the Assign Security Rules block, identify the value set to which your values belong. You can identify your value set or by the flexfield segment or concurrent program parameter that uses the value set.
3. In the Security Rules block, enter the application and responsibility name that uniquely identifies the responsibility to which you want to assign security rules.
4. Enter the name of a security rule you want to assign to this responsibility.
5. Save your changes.



Period-End Process In Receivables R12

By // 2 comments:
Oracle Receivables requires periodic internal reconciliation of the transactions entered into the Accounts Receivables system. Oracle Receivables provides a comprehensive set of reports to facilitate the reconciliation of outstanding customer balances, transactions, receipts, and account balances. The application provides the functionality to enable reconciliation of your sub-ledger, before posting to the General Ledger. Posting to the General Ledger allows the extraction of details from Oracle Receivables, and the creation of journal entries in the General Ledger. After posting to the General Ledger, it is possible to reconcile Oracle Receivables with the General Ledger by verifying that all the correct journal entries were made.

Procedures:

The following steps are taken in performing period-end processing for Oracle Receivables.

1. Complete All Transactions for the Period Being Closed

Ensure that all transactions have been entered for the period being closed.
Completing all transactions for Oracle Receivables:
* Complete Invoicing, Credits and Adjustments
* Complete Receipts and Reversals
* Complete Invoice and Customer Import
* Complete Lock Box Processing
* Run the revenue recognition program (Optional; required if OM-shipping is used)
If you import transactions from an external system or Oracle Projects, ensure that you have imported all transactions and master files, and reviewed all audit trails for completeness.

2. Reconcile Transaction Activity for the Period

Reconcile the transaction activity in Oracle Receivables, before posting to the General Ledger using SLA. This reconciliation process checks that Oracle Receivables transactions are balanced, ensuring that all items eligible for posting are reflected on the Sales Journal. Run the following reports for the same accounting
period date range:

a. Transaction Register

This report details all the transactions (i.e. invoices, debit memos, credit memos, deposits, guarantees and chargebacks) entered with a GL date between the period start and period end dates, specified for the period being reconciled. This report shows transactions which were entered and completed.

b. Sales Journal by Customer Report and the Sales Journal by GL Account Report Oracle Financials E-Business Suite Release 12 Period End Procedures 40 This report enables the review of all transactions for the specified period. The summary totals for the sales journal are by Posting Status, Company, and Transaction Currency. This report details, by account type (i.e. receivables, revenue, freight, tax), the general ledger distributions for posted and/or un-posted invoices for the specified period. The total on the Sales Journal by GL Account should equal the total of items eligible for posting as listed on the Transaction Register. If any discrepancies are evident, research the customer balances to find out which balance does not tally, using the Sales Journal by Customer report. By using the following formula, ensure that the Transaction Register matches the Sales Journal:
Transaction Register (Items eligible for posting) + 2 * Credit Memo Total = Sales
Journal (Debits plus Credits)
E.g. $100 + (2 * $20) = Debits $120 + Credits $20
($120 Debits - $20 Credits)
Attention: The Transaction Register total for any credits must be adjusted, as they are negative on the Transaction Register and positive on the Sales Journal.
Attention: Ensure that the monthly transaction total is accurate and that no distribution issues exist.

c. Journal Entries Report

This report enables the review and analysis of accounting entries in the Receivables subledger, as accounted by SLA. Using the report parameters, you can produce a detailed or summary listing of the accounting information you want to review. The report also lists in detail, transactions that have been accounted with error, and all entries that could not be transferred to the general ledger. When a transaction is accounted with errors, review the details and make the necessary changes. By altering the parameters, the report also lists those transactions, which have been posted in general ledger, and those which are yet to be posted but have been accounted. SLA groups the report by ledger, ledger currency, source, category, and event class. Data is then sorted by accounting date, event type, customer name, document number, and voucher number.

Note: To avoid duplication with subledger journal entries, general ledger journal entries imported from Subledger Accounting are not included in the report.
 
d. AR to GL Reconciliation Report
The AR to GL Reconciliation report compares the account balances in Oracle Receivables to those in Oracle General Ledger, and highlights journal sources where discrepancies might exist. This report simplifies the reconciliation process by comparing Receivables and General Ledger account balances in a single place.
Run the AR to GL Reconciliation report:
* After the Create Accounting program in Receivables has completed, and
* You have reviewed the Unposted Items report to confirm that all journal entries have posted, and
* You have used the posting execution reports to confirm that the journal entries exported from Receivables match those posted in General Ledger.
Oracle Financials E-Business Suite Release 12 Period End Procedures 41
This report will show a difference between Receivables and GL account balances only if items did not successfully post to GL accounts. The Difference column indicates how the activity in Receivables compares to the journal source of Receivables in the General Ledger. If the actual balance of a specific account is different in Receivables than in GL, then the following columns highlight the type of journals that affect the account balances:
* GL Source Manual - Manual journal entries made in the General Ledger.
* GL Subledgers Not AR - Journal entries posted to the General Ledger from other subledgers, such as Oracle Payables or a legacy feeder system.
* Unposted in GL - Unposted Oracle Receivables journals in the general ledger. During the internal reconciliation process, use the AR Reconciliation report to confirm that your transactional and accounting data match. However, even if the data matches, the journals could still post to incorrect GL accounts. The Potential Reconciling Items report addresses this issue by suggesting journal items that might potentially post to GL accounts with unexpected account types, thus creating reconciliation issues in Oracle General Ledger.
 
3. Reconcile Outstanding Customer Balances
Reconcile the outstanding customer balances at the beginning of a specified period with the ending balance for the same period, using the following formula, known as the Roll Forward Formula:
Period-End Balance = Outstanding Balance at Start of Period + Transactions + Adjustments – Invoice Exceptions – Applied Receipts – Unapplied Receipts
The following list represents the various components that affect a customer’s balance and the reports, which can be run and reviewed to reconcile these components:
Component Report
Beginning Balance Aging reports
Transactions Transaction Register
Adjustments Adjustment Register
Exceptions Invoice Exceptions Report
Applied Receipts
Applied Receipts Register (Identify
payments received from customers)
Unapplied
Receipts
Unapplied and Unresolved
Receipts Register (identify
payments received from customers)
Ending Balance
Aging report (as of the last day of
the accounting period)
Oracle Financials E-Business Suite Release 12 Period End Procedures 42
Attention: You can use the Invoice Exceptions Report to adjust the Transaction Register for any transactions, which are not open in Receivables, and therefore do not show up in the aging reports.
 
4. Review the Unapplied Receipts Register
Use the Unapplied Receipts Register to review detailed information about your customers’ on-account and unapplied payments for the date range that you specify. You can use this report to determine how much your customer owes after taking into account all on-account and unapplied amounts. Receivables displays information about your on-account or unapplied payment such as GL date, batch source, batch name, payment method, payment number, payment date, on-account amount, and unapplied amount. This report includes both cash and miscellaneous receipts. If any of the Receipts listed can now be applied to outstanding transactions, you can perform this action by re-querying the receipts and following the normal application procedure.
 
5. Reconcile Receipts

Ensure that Oracle Receivables receipts balance by running the following reports:
 
a) Receipts Journal Report
This report displays details of receipts that appear in the Journal Entries Report. The Journal Entries Report shows the receipt numbers that contribute to a particular GL account. Using the receipt number, you can review the detailed information on the Receipts Journal Report.

b) Receipt Register
Use this report to review a list of receipts for a specified date range.
Attention: Normally the total of the Receipts Journal report should equal the total of all the receipts in the Receipt Register for the same GL date range.

6. Reconcile Receipts to Bank Statement Activity for the Period

Once detailed bank statement information has been entered into Cash Management, the information must be reconciled with the subledger transactions. Cash Management provides two methods to undertake reconciliations:
 
a) Automatic
Bank statement details are automatically matched and reconciled with subledger transactions. This method is ideally suited for bank accounts which have a high volume of transactions.

b) Manual

This method requires a manual match of bank statement details with subledger transactions. This method is ideally suited to reconciling bank accounts which have a small volume of monthly transactions. The manual reconciliation method can also be used to reconcile any bank statement details, which could not be reconciled automatically.

7. Post to the General Ledger
Prior to posting to the General Ledger, the Receipts Journal Report and Sales Journal display the transactions that would be posted to the General Ledger (provided the posting process was run for the same GL date range). After internally reconciling the transactions and receipts using these two reports, it is possible to perform external reconciliation during and after the posting process. The posting process for Oracle Receivables involves a single step: Create Accounting This process can be submitted from the transactions screen to account for a specific receivables transaction or from the SRS screen to account for all receivables transactions. The accounting is done at the ledger level and the program has the ability to transfer and import into the General Ledger based on the parameters specified. If Create Accounting is submitted in the ‘Final’ mode without transferring it to the General Ledger, the entries will have to be transferred separately.
 
8. Reconcile the General Ledger Transfer Process
The Create Accounting program produces the Subledger Accounting Program report that shows you the subledger journal entries created for successful accounting events. Compare this report to the Journal Entries Report (run in Posted status mode) and verify that they match. Use the same General Ledger date ranges for the Journal Entries Report and the Create Accounting program. Create Accounting will generate a report which details the transferred transactions, transactions in error etc. Once transactions and receipts have been transferred to the GL tables, Oracle Receivables regards these items as having been ‘posted’ within the sub-ledger. Account balances for transactions and receipts can be reconciled by generating the Sales Journal by GL Account Report, the Receipts Journal Report (in ‘transaction’ mode) and the Journal Entries Report for posted items. The account totals in the Sales and Receipt journals should match the corresponding account balances in the Journal Entries Report.
Attention: The ‘Detail by Account’ version of the Journal Entries Report may be the most useful for reconciliation in this case. When running any Oracle Receivables reports that display accounting involving
transactions that have been posted to GL, the following statements apply: If SLA final accounting lines exist, then SLA accounting is displayed. If SLA accounting lines do not exist, then AR distribution accounting is displayed.
 
9. Reconcile the Journal Import Process
Create Accounting program submits Journal Import automatically when launched in ‘Mode = Final’ and ‘Transfer to GL = Yes’. Reconcile the Journal Import by manually reviewing the transactions in the Subledger Accounting Program Report, and comparing them with the Journal Entries Report output. The Journal Entries Report is a new Subledger Accounting BI Publisher report which is available from the subledger applications and can be run with parameter Posted = Yes, No or ALL, which users can copy and modify the report template according to their needs.

Attention: If the customer is using Reporting/Accounting sequences, they can run Journal Entries Report using Sequence Ranges created in the Create Accounting program run, and compare the total with the Journal Import Execution Report.

10. Print Invoices
Once you are satisfied that the customer balances are reconciled, ensure all the invoices generated during the month have been printed and issued. If the Balance Forward Billing functionality is used, ensure that the consolidated (BFB) invoices have been generated for the current period.
Note: Balance Forward Billing replaces consolidated billing invoices (CBI) feature of 11i. For more information on the setup of balance forward billing, refer to the Oracle Receivables Implementation Guide or the Oracle Receivables User Guide.

11. Close the Current Oracle Receivables Period
Close the current period in Oracle Receivables using the Open/Close Accounting Periods window.
Attention: Where there are multiple operating units within the same ledger all operating units must be ready to close at the same time. All of the operating units that share a ledger also share the same period statuses. When you update the period statuses to ‘Open’ in one operating unit, that period is opened for all
operating units within the ledger.
 
12. Review the Subledger Period Close Exceptions Report
The Subledger Period Close Exceptions Report lists all the accounting events and journal entries that fail period close validation. It is automatically submitted by General Ledger when closing a GL period if there are unprocessed accounting events or un-transferred journal entries.
You can also generate the Subledger Period Close Exceptions Report through a concurrent request as follows:
* For the application associated with the responsibility
* For all applications in the General Ledger responsibility
 
13. Third Party Balances Report
Run Third Party Balances Report from the SRS screen.
This report is used to display balance and account activity information for Suppliers and Customers. It retrieves the following information:
* Third party balances for third party control accounts
* Subledger journal entry lines that add up to the total period activity for each control account, third party, and third party site
* Third party and third party site information
* User transaction identifiers for the associated event
The balances in this report can be compared with the General Ledger balances for the same control accounts to reconcile.

14. Reconcile Posted Journal Entries
After running the GL posting process in Oracle General Ledger, for the transactions, which were transferred in FINAL mode and with Post in GL being set to NO, run the Journal Entries Report (with ‘Posted = Y’) to help reconcile the posted journals.
 
15. Review the Unposted Items Report
Oracle Receivables prints the Unposted Items Report for all items that are not posted for the specified GL date range. Run the request from the Submit Requests window. The output will consist of all items not posted to the General Ledger for the specified GL date range. Using the Submit Requests window to generate this report, submit with a GL date range for at least the current financial year. This report should not generate any output if all Receivables transactions have been successfully posted to the General Ledger. If there are any items not posted for the current or prior periods, then re-open both appropriate Receivables and General Ledger Periods and initiate another posting.
 
16. Review Account Analysis Report
The Account Analysis Report provides drill-down information about the activities relating to a particular account for a period or range of periods. It only includes journal entries transferred to and posted to the General Ledger. Review this report and compare it with the Third Party balances report.
Note: To avoid duplication with subledger journal entries, General Ledger journal entries imported from Subledger Accounting are not included in the report.
 
17. Open the Next Oracle Receivables Period
Open the next period in Oracle Receivables using the Open/Close Accounting Periods window.
 
18. Run Reports for Tax Reporting Purposes (Optional)
A variety of standard reports can be used to provide tax information, which is required to be reported to the relevant Tax Authority, including withholding tax. The E-Business Tax data extract draws tax information from each application and stores the data in an interface table. Output from the tax extract is designed to look as close to a simple tax report as possible.
The following tax registers are available:
a) Deferred Output Tax Register
b) Recoverable and Non-Recoverable Tax Registers
c) Single Cross Product Tax Register
d) Standard Input and Output Tax Registers
The following summary levels are available within each Tax Register:
* Transaction Header
* Transaction Line
* Accounting Line








FA To GL Reconciliation in R12

By // 1 comment:
FA To GL Reconciliation:

You can use reports to reconcile journal entries to your general ledger accounts. This
section illustrates the relationships among Oracle Assets accounting reports.
You can use reports to reconcile journal entries to your general ledger accounts. The
following sections illustrate the relationships among Oracle Assets accounting reports:
• Reconciling Journal Entries to General Ledger Accounts,
• Reconciling Asset Cost Accounts
• Reconciling CIP Cost Accounts
• Reconciling Reserve Accounts
• Reconciling Depreciation Expense Accounts
• Tracking and Reconciling Mass Additions

Reconciling Journal Entries to General Ledger Accounts
 

Use the Unposted Journals Report in Oracle General Ledger, to match GL batch totals
with the asset batch totals found in the Subledger Accounting Account Analysis report.
Related Topics
Unposted Journals Report, Oracle General Ledger
Account Analysis Report

Reconciling Asset Cost Accounts

Steps to reconcile asset cost accounts:

1. In Oracle General Ledger, match the ending balances in the Detail Trial Balance report with the ending balances in the ledger Subledger Accounting AccountAnalysis report.
2. Match the general ledger ending balances with those of the Cost Summary Report.
3. Match the ending balances of the Cost Summary Report with those of the Cost Detail Report.
Match the individual source amounts of the Cost Detail Report to the detail reports in the next steps.
4. Match additions to cost in the Asset Additions report.
5. Match adjustments to net change in the Cost Adjustment Report.
6. Match retirements to cost retired in the Asset Retirements Report.
7. Match reclasses to cost in the Asset Reclassification Reconciliation Report.
8. Match transfers to cost in the Asset Transfer Reconciliation Report.

   

Reconciling CIP Cost Accounts

Steps to reconcile CIP cost accounts:
1. In Oracle General Ledger, match the ending balances in the Detail Trial Balance Report with the ending balances in the Subledger Accounting Account Analysis report..
2. Match the general ledger ending balances with those of the CIP Summary Report.
3. Match the ending balances of the CIP Summary Report with those of the CIP Detail Report.
Match the individual source amounts of the CIP Detail Report to the detail reports in the next steps.
4. Match additions to CIP cost in the Asset Additions report.
5. Match adjustments to CIP net change in the Cost Adjustment Report.
6. Match retirements to CIP cost retired in the Asset Retirements Report.
7. Match capitalized to CIP cost in the CIP Capitalization Report.
8. Match reclasses to CIP cost in the Asset Reclassification Reconciliation Report.
9. Match transfers to CIP cost in the Asset Transfer Reconciliation Report.
10. Match ending balances to CIP cost in the CIP Asset Report.

   

Reconciling Reserve Accounts

Steps to reconcile reserve accounts:
1. In Oracle General Ledger, match the ending balances in the Detail Trial BalanceReport with the ending balances in the Subledger Accounting Account Analysis Report.
2. Match the general ledger ending balances with those of the Reserve Summary Report.
3. Match the ending balances of the Reserve Summary Report with those of the Reserve Detail Report.
Match the individual source amounts of the Reserve Detail Report to the detail reports in the next steps.
4. Match additions to accumulated depreciation in the Asset Additions report.
5. Match adjustments to reserve adjustment in the Reserve Adjustments Report.
6. Match retirements to cost retired and NBV retired in the Asset Retirements Report.
7. Match reclasses to accumulated depreciation in the Asset Reclassification Reconciliation Report.
8. Match depreciation to depreciation amounts in the Account Reconciliation Reserve Ledger report.
9. Match transfers to accumulated depreciation in the Asset Transfer Reconciliation Report.

   

Reconciling Depreciation Expense Accounts

In Oracle General Ledger, use the Detail Trial Balance Report to match with the ending balances for the Subledger Accounting Account Analysis Report.
Use the Journal Entry Reserve Ledger report to match the depreciation balances with the ending GL depreciation balances.



Tracking and Reconciling Mass Additions

You can use reports to track your mass additions from the time you bring them over from your accounts payable system to the time you post them into Oracle Assets:

Steps to reconcile Mass Additions:

1. Match asset journal amounts found in your general ledger with those in the Cost Clearing Reconciliation Report Oracle Assets automatically makes these journal entries for your general ledger.
2. Match amounts in the Cost Clearing Reconciliation Report with those in the Mass Additions Posting Report. Adjusting journal entries are necessary for account transfers and cost adjustments to posted invoice lines.
3. Match amounts in Mass Additions Posting Report with those of the Mass Additions Invoice Merge Report, Mass Additions Invoice Split Report, Unposted Mass Additions Report and Mass Additions Delete Report. Oracle Assets posts mass additions with a status of post. You can also match amounts in the Mass Additions Posting Report with those in Additions by Source Report and Cost Adjustments By Source Report. The Asset Additions Report includes posted mass additions as well as manual asset additions.
4. Match amounts in the Mass Additions Invoice Merge Report, Mass Additions Invoice Split Report, Unposted Mass Additions Report and Mass Additions Delete Report with amounts in the Mass Additions Create Report. Split, merge, delete, place on hold, or prepare for posting invoice line items brought over from accounts payable.

   
Use the Cost Clearing Reconciliation Report to match additions with those found in the Additions By Source Report.
Use the Cost Clearing Reconciliation Report to match adjustments with those found in the Cost Adjustment By Source Report.