Which are Fusion Business Unit & EBS Operating Unit (BU or OU) specific modules? AP: Accounts Payables AR: Accounts Receivables PO: Purchasing OM: Order Management PC: Project Costing PB: Project Billing
Flexfield Qualifier is “which segment qualifies for which attribute“. Each Segment can have one of the following Qualifying attributes attached to it. Some of them are mandatory others are optional. Cost Center: Usually assigned to Department Segment. This qualifying segment is used by Oracle Assets. Natural Account: This […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 