Prorate Conventions in Fixed Assets Before we discuss depreciation it is worth to discuss prorate conventions as there are wide variety of prorate conventions and each of those prorate conventions has implication on depreciation calculation. […]
AR Receipts to SLA Link R12 Accounting Data Model – Receipts •Where POSTABLE_FLAG <> ‘N’ •EVENT_ID should exist •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH and RA) •Debit & credit amounts should match
AR Miscellaneous Receipt to SLA Link R12 Accounting Data Model – Miscellaneous Receipts •Where POSTABLE_FLAG <> ‘N’ •EVENT_ID should exist •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH & MCD) •Debit & credit amounts should match
Ref: Oracle Webcast – Oracle receivables posting & Reconciliation in R12
Rebuild AP Trial Balance in R12 To rebuild xla_trial_balances table or create a new report definition. For better performance of Data Manager run, increase the number of workers to 16,32 or 64 Navigate : Subledger […]
How to reconcile AP Trial Balance with Payable Transactions for a given period Get the output of the following for account and period where the difference was observed (In Detail); Now run following reports within […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]
AP Trail Balances SQL Query for R12 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 […]
Lists all products and their Installation Status 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT fat.application_name, fa.application_id, fpi.patch_level, Decode(fpi.status, ‘I’, ‘Licensed’, ‘N’, ‘Not Licensed’, ‘S’, ‘Shared’, ‘Undetermined’) STATUS FROM […]
Introduction:- Oracle GRC term is relatively new word compared to Oracle E Business Suite, but it is getting hot day by day. Where GRC Stands for Governance – Risk Management – Compliance. GRC takes cares […]
