Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 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
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle API Availability – Oracle Receivables (AR)

Posted on June 23rd, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

This is in continuation to API’s availability,Here are the API’s availability in AR.

handInvoices

  • Manual Entry and Updating: Manual entry or update of invoices requires the user to have access to the Oracle Application's Accounts Receivable module and specifically the Enter Invoices form. You can enter and update invoices for valid customers. AR uses AutoAccounting to create the revenue accounting combination based on the invoice line information.
  • AutoInvoice Interface: AutoInvoice interface provides a mechanism for transferring large volumes of invoices, credit memos, debit memos, and on-account credits from third-party and legacy systems into Receivables. Information is loaded into the RA_INTERFACE_LINES_ALL (which stores information about each interface line imported) and RA_INTERFACE_SALESCREDITS_ALL (containing the sales credit information) tables then imported into the Oracle Applications by the AutoInvoice Import process.You can also refer my old post for autoinvoice details.

handReceipts

  • Manual Entry and Updating: Manual entry or update of receipts requires the user to have access to the Oracle Application's Accounts Receivable module and specifically the Enter Receipts form. You can enter and update receipts for open and future accounting periods.
  • AutoLockbox Interface: AutoLockbox interface provides a mechanism for transferring large volumes of payments from bank files or third party systems into Receivables. Information is loaded into the AR_PAYMENTS_INTERFACE_ALL table then imported into the Oracle Applications by the AutoLockbox Import process.
    The AR_PAYMENTS_INTERFACE_ALL table stores imported lockbox information that has not been validated. AutoLockbox creates one row in this table for each record in a transmission. When the validation step of AutoLockbox is run, Oracle Receivables transfers the information from the AR_PAYMENTS_INTERFACE_ALL tables to the AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL tables.

handCustomers

  • Manual Entry and Updating: Manual entry or update of customers requires the user to have access to the Oracle Application's Accounts Receivable module and specifically the Enter Customers form. You can enter and update customers, multiple customer addresses (sites), and multiple contact(s) for each address.
  • Customer Interface: The customer interface provides a mechanism for transferring large volumes of customers from third party and legacy systems into Receivables. Information is loaded into the RA_CUSTOMER_INTERFACE, RA_CONTACT_PHONES_INTERFACE, RA_CUSTOMER_PROFILES_INTERFACE, RA_CUSTOMER_BANKS_INTERFACE, and RA_CUST_PAY_METHOD_INTERFACE tables then imported into the Oracle Applications by the Customer Import process.
  • TCA API's: The customer information can also be loaded into application by TCA API's.

handSales Tax Rates

  • Manual Entry and Updating: Manual entry or update of sales tax data requires the user to have access to the Oracle Application's Accounts Receivable module and specifically the Tax Locations and Rates form. You can enter and update location and rate information through this form.
  • Sales Tax Rate Interface: The Sales Tax Rate Interface lets you load sales tax records into your Oracle Receivables application from your sales tax feeder system. Information is loaded into the AR_TAX_INTERFACE table then imported into the Oracle Applications by the Sales Tax Rate Interface process.
    The AR_TAX_INTERFACE table is used to import location, postal code and sales tax rate information into Oracle Receivables. Rows are inserted in this table and then the Sales Tax Interface Program is run to create records in AR_LOCATION_VALUES and AR_LOCATION_RATES. Each row can define a new location and assign to it multiple postal code and effectively date ranges, and each range may have an optional sales tax rate.

handTax Vendor Extension

Oracle provides a Tax Vendor Extension to integrate external tax calculation programs with the Oracle Application's Accounts Receivable module. This extension allows you to provide for complex tax calculation requirements while retaining the full power of Receivables to create and store other tax data. The tax extension is called whenever a tax rate is calculated by the Receivables Tax Engine.

 

Related Posts

Posted in API Integration, Oracle Receivable | 12 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
12 Responses
  1. Rajesh Says:

    It is greate to read your blogs. Would you please tell me how can I get screen shot for AR AutoInvoice Interface table.

    Thank you
    Rajesh
    ITSPIN INC

  2. Raj Says:

    You can try getting into AR TRM and try looking for the structure of the AutoInvoices interface tables

  3. shashi Says:

    Thanks for sharing information

  4. AR Invoice API (Application Program Interface ) Says:

    […] Oracle API Availability – Oracle Receivables (AR) […]

  5. Usman Says:

    I want to load the AR memo lines. What interface/API or method i can use?

    Regards,

    Usman

  6. Sanjit Anand Says:

    Usmaan,
    as there is no public API’s for memo line.

    You can useby Data loader for migrating this else, if you are highly exposed to API’s i can give you the list of ORACLE api which is used by form to create memo line. You can utilize , but this is bit risker than data loader.

  7. Led Smith Says:

    Nice Blog,

    My company has implemented CONVIFACE , with this interface system. it is easy to apply this knowledge.

  8. Bob V Says:

    Is there an API to merge customer parties or relate them?

  9. Sanjit Anand Says:

    hi Bob,

    My understanding is as of now,there is no as such public API, in Oracle. The seeded function is there from front end.

    the vanila merger works in differently, check it out these url.

    http://www.oracleappshub.com/accounts-receivable/party-merge/

    http://www.oracleappshub.com/accounts-receivable/ar-customers-merging-utility/

    If you intend to use, you can can try the private API for merging which is attached and used by Form itself.

    This is bit risky to use private API’s, but if business need you can opt.

    sanjit

  10. Philippe Says:

    Hello all,
    I would like to automate Transaction types creation, is an API exuisting for this ?

    Thanks

  11. Preeti Says:

    Is there any API available to convert icollection notes (JTF_NOTES_B) to receiveables notes (AR_NOTES)?

    Thanks in advance,

  12. Ramgopal Says:

    Wonderful notes.
    Do we have any API to updated the “Due Date” on the transaction? Applications allow us to change the due date on the transaction when profile option” AR: Update Due Date” is set to Yes. However we want to update the due-date of many transactions programatically, irrespective of payment terms.
    Appreciate any help

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.