Status code and Phase code in fnd_concurrent_requests We always keep getting confused about the meanings of status_code and phase_code columns in fnd_concurrent_requests table. Here is the brief descriptions of statuses columns in the table. Table […]
Brief Overview of Fixed Asset Accounting Depreciation Additions and Capitalizations Adjustments Transfers and Reclassifications Revaluations Retirements and Reinstatements Tax Accumulated Depreciation Adjustments A. Journal Entries for Depreciation When you run depreciation, Oracle Assets creates journal […]
How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger? For transactions like Additions, Adjustments, and Retirements etc. the mapping is: XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_ADJUSTMENTS.TRANSACTION_HEADER_ID XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_ADJUSTMENTS.ADJUSTMENT_LINE_ID For Depreciation event transaction rows: XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_CHAR_4 = […]
Why XLA_DISTRIBUTION_LINKS table cannot be used while reconciling to GL This table contains the link between transactions and subledger journal entry lines. Provide more accurate information as how GL lines or XLA_AE_LINES are derived from […]
How to Make a Cost Adjustment to an Asset in Oracle R12? A cost adjustment includes any adjustment that affects the recoverable cost, including a change in cost, salvage value, depreciation, and cost, depreciation expense, […]
Amortized vs Expensed Adjustments in Fixed Assets In the period you add an asset or for CIP assets, changing financial information does not adjust depreciation, since no depreciation has been taken. But while changing financial […]
Revaluation in Oracle Fixed Assets 1. Introduction Revaluation of fixed assets is the process of increasing or decreasing their carrying value in case of major changes in fair market value of the fixed asset. International […]
How Subledger Accounting (XLA) Tables are link to General Ledger (GL) Tables Assumption is GL Entry Summarization: Summarize (By GL Date or Period) JLT – Transfer to GL: Detail Expected behavior is: Summarize Entries at […]
Auto Lockbox in Oracle Receivables Introduction AutoLockbox is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. This feature eliminates the need for manual data entry […]
Depreciation in Fixed Assets Fixed Asset Configuration that Impact Depreciation Calculation Depreciation cannot be explained without brief explanation of following terms Depreciation Calendar, Prorate Calendar, Prorate Convention. So for brief explanation of these terms […]
Enterprise Resource Planning and Integrations BlogSpot 