Skip to main content

Powered Search Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications Get Updates! Subscribe to the OracleAppsHub to receive notifications when there are new posts: Enter your email address get RSS feed Categories 11i Advance Collection AOL API Integration ASC606 Basic Accounting Beginner Beyond Apps Blogroll Cash Management Centrestage Conversion Depot Repair EBS Suite EDI Emerging Technologies Finance Functional Fusion Fusion Application General Interest HRMS Hyperion Implementations Integration InterCompany JumpStart Localizations MDM Methodology/Process Misc News OPM Oracle Application Oracle Asset Oracle Cloud * Oracle Credit Management Oracle Diagnostics Oracle E-Business Tax Oracle eAM Oracle Footprint Oracle General Ledger Oracle ICM Oracle Legal Entity Configurator Oracle Manufacturing Oracle Order Management Oracle Payable Oracle Payment Module Oracle Pricing Oracle Product Oracle Property Manager Oracle Purchasing Oracle Receivable Oracle TCA Oracle Treasury Personalizations R12 Release12 Security SEPA Service Contracts Subledger Accounting Technical Tool Uncategorized Web ADI XBRL Archives March 2018 February 2018 December 2017 October 2017 September 2017 July 2017 June 2017 May 2017 March 2017 February 2017 November 2016 October 2016 August 2016 July 2016 June 2016 January 2016 November 2015 October 2015 August 2015 July 2015 June 2015 May 2015 March 2015 January 2015 December 2014 October 2014 August 2014 July 2014 May 2014 March 2014 February 2014 January 2014 December 2013 November 2013 October 2013 September 2013 August 2013 July 2013 June 2013 May 2013 April 2013 March 2013 February 2013 January 2013 December 2012 November 2012 October 2012 September 2012 July 2012 June 2012 May 2012 April 2012 March 2012 February 2012 January 2012 December 2011 November 2011 October 2011 September 2011 August 2011 July 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009 July 2009 June 2009 May 2009 April 2009 March 2009 February 2009 January 2009 December 2008 November 2008 October 2008 September 2008 August 2008 July 2008 June 2008 May 2008 April 2008 March 2008 February 2008 January 2008 December 2007 November 2007 October 2007 September 2007 August 2007 July 2007 June 2007 May 2007 April 2007 March 2007 February 2007 January 2007 December 2006 October 2006 August 2006 Links Metalink Oracle Oracle Integration Repository Disclaimer Disclaimer Meta: RSS Comments RSS Valid XHTML eMail Ad Feature Topic Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management Grab Free Copy Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications Search Powered Search Recent Posts Finding your Ikigai Oracle Adaptive Intelligent Applications for ERP How Blockchain Technology Will Impact Accounting. Study: ASC 606 Might Slow IPOs in 2018 ?? Vertex and Oracle Cloud Blogroll David Haimes Floyd Teter Steven Chan Tim Dexter Trioragroup Blog Total Page View StatCounter - Free Web Tracker and Counter News & Views This RSS feed URL is deprecated Healthcare IT Market Survey Report 2018 with Forecast by McKesson Corporation, Oracle Corporation, Allscripts … – Digital Journal Ford's all but getting out of the car business in North America – CTV News Oracle whips out the swatter, squishes 254 security bugs in its gear – The Register User Onlines 108 Users AR : Back to Basic(Technical Foundation)

This post is more on basic table structure of Oracle Account Receivable.
1.Table that holds AR Invoice data
The following tables can give most of the invoice information.
  • RA_CUSTOMER_TRX_ALL stores invoice header information. RA_CUSTOMER_TRX_LINES_ALL stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines.
  • The AR_PAYMENT_SCHEDULES_ALL table stores all transactions except adjustments and miscellaneous cash receipts.
  • RA_CUST_TRX_LINE_GL_DIST_ALL stores accounting distribution records for all transaction lines except bills receivable.The RA_CUST_TRX_LINE_GL_DIST_ALL table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line.
  • RA_CUSTOMERS - Customer information
  • RA_CUST_TRX_TYPES_ALL - Customer Transaction Type
  • AR_PAYMENT_SCHEDULES_ALL
  • RA_CUSTOMER_TRX_LINES_ALL - Transaction Line information
  • MTL_SYSTEM_ITEMS - Base table for item
The ER Diagram for a customer Transaction can be easily understood as:
CustomerInvoice
2.Customer PaymentThese are the main tables which holds Customer Payment information
  • AR_CASH_RECEIPTS_ALL stores one record for each receipt entry.
  • AR_CASH_RECEIPT_HISTORY_ALL stores all of the activity that is contained for the life cycle of a receipt.
  • Each row represents one step., Possible statuses are Approved, Cleared,Confirmed, Remitted, and Reversed.
  • AR_MISC_CASH_DISTRIBUTIONS_ALL stores all accounting entries for miscellaneous cash applications.
  • AR_DISTRIBUTIONS_ALL stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments,credit memo applications, cash receipt applications, and bills receivable transactions.
  • AR_RECEIVABLE_APPLICATIONS_ALL stores all accounting entries for cash and credit memo applications.
  • Each row includes the amount applied, status, and accounting flexfield information.
The ER Diagram for a customer Payment can be easily understood as:
Customerpayment
3. Accounting Link between the tables
  • For Invoice:
ra_customers (This is for capturing customers information)
ra_customer_trx_all,
ra_cust_trx_types_all,
ar_payment_schedules_all,
ra_customer_trx_lines_all
and joins are customer_trx_id for ar_payment_schedules_all & ra_customer_trx_all & ra_customer_trx_lines_all .
ra_cust_trx_types_all.type IN ('INV')
  • For the Receipts:
ar_receivable_applications_all,
ra_customer_trx_all,
ra_customer_trx_lines_all,
ar_cash_receipts_all
ar_receivable_applications_all.application_type = 'CASH',
ar_receivable_applications_all.cash_receipt_id = ar_cash_receipts_all.cash_receipt_id,
ar_receivable_applications_all.applied_customer_trx_id = ra_customer_trx_all.customer_trx_id
Labels:

Comments

Post a Comment

Popular posts from this blog

Oracle Subledger Accounting (SLA) Tables, Views

Oracle Subledger Accounting (SLA) Tables, Views Oracle Subledger Accounting Tables: TABLE NAME DESCRIPTION XLA_AAD_GROUPS The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis.  All application accounting definitions with the same GROUP_NUM must be merged together. XLA_AAD_HDR_ACCT_ATTRS The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. XLA_AAD_HEADER_AC_ASSGNS Store the analytical criteria for the application accounting definitions. XLA_AAD_LINE_DEFN_ASSGNS This table stores the journal lines definitions for the application accounting definitions. XLA_AAD_LOADER_DEFNS_T The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. XLA_AAD_LOADER_LOGS The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. XLA_AAD_SOURCES XLA_AAD_SOURCES table stores a...
1 comment
Read more

Public API’s for FA Transactions

Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's:   Additions API if you have requirement to add assets directly via PL/SQL then use  FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using  FA_ADJUSTMENT_PUB.DO_ADJUSTMENT  for any  process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...
Post a Comment
Read more

Unbilled Receivables and Unearned Revenue Accounting in Oracle Projects

Unbilled Receivables and Unearned Revenue Accounting in Oracle Projects Introduction When it comes to contractual billing, invoice and revenue generation are two separate processes, which during the lifespan of a project may or may not always coincide with each other and so do the balances in revenue and receivables accounts.  This interim difference between revenue and invoice account balances is bridged using Unbilled Receivables (UBR) and Unearned Revenue (UER) Accounts. Unearned Revenue (UER) Unearned Revenue (also termed as deferred revenue or UER) signifies money received for the goods or services, which are yet to be delivered.  As per the principles of Revenue Recognition, UER is recorded as on the balance sheet unless it is converted to Revenue upon delivery of goods or services For Example XYZ Consulting Ltd. receives an annual maintenance contract of $ 12,000 on Dec 31, 2014 for the period of Jan 01, 2015 to Dec 31, 2015. At the start of the contract as of Dec 31, 2...
2 comments
Read more