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

AR Invoice API (Application Program Interface )

Posted on September 1st, 2008 by Sanjit Anand ||Email This Post Email This Post

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

AR Invoice API allows users to create an invoice using simple calls to PL/SQL functions. The Invoice Creation API is another options for Transaction creation does not mean replacement of Transaction workbench, AutoInvoice, or the Transaction API program.

dgreybarrowWith this API’s you can manage

  • Single or multiple invoice(s) creation when you required
  • This will extensive defaulting which minimizes the programming effort
  • Validation ensures quality data
  • You can use debug messages in a central repository that improves coding efficiency
  • You can get immediate results

dgreybarrowHow to start with API’s Usage

Very similar to AutoInvoice , you need following setup.

  • Payment Terms
  • Invoice Transaction Type
  • Transaction Batch Source
  • Currency
  • Customer
  • Remit to Address
  • AutoAccounting

Optional Setup

  • Salesperson
  • Document Numbering
  • Inventory or Memo line id

Additionally you need to make sure these should be used


dbms_application_info.set_client_info(‘&Org_id’); — if using TOAD or sqlplus



dgreybarrowWhat are the API’S


This API will have 2 routine call, which you can either create single/multiple in batch or single invoice.

  • tickar_invoice_api_pub.create_invoice: Creates multiple invoices in a batch.
  • tickar_invoice_api_pub.create_single_invoice: Creates a single invoice and return customer trx id.

dgreybarrow Important Tips and notes

  1. These API can only be used to create new transactions, not use for update existing ones.
  2. This API can only create ‘INV’ type transactions. It is not desgined to create Debit Memos/credit memo.
  3. When you load via the AR_INVOICE_API_PUB it populates the temp tables AR_TRX_HEADER_GT, AR_TRX_LINE_GT
  4. The transaction number is populated when automatic transaction numbering is selected on the transaction batch source.
  5. The Publically supported transaction API is AR_INVOICE_API_PUB have source file ARXPINVB.pls , ARXPINVS.pls.
  6. You can take advantage of parameter p_commit, very similar way the HR API’s are using. If you want to make just a validation, always start with p_commit=false

dgreybarrowAutoinvoice Vs Transactions API
Its depends , what is comfortable level. Autoinvoice is one of such robust tool that cater the external interfacing need, therefore is always advisable to use an Interface as it is available.

dgreybarrowOracle Documentation

dgreybarrowSimilar Post

Related Posts

Posted in Oracle Receivable | 3 Comments »Email This Post Email This Post |

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

    Can we add Item/memo line to an already existing Invoice.

    I know that it cant be done if the Invoice is completed. But can we add it if the invoice is in Imcomplete stage.

  2. Sanjit Anand Says:

    Laxmi, not sure what you are asking, from front end or back end.

    Front end is easy to do…
    just incomplate and modify the transaction.

    I donot think , API’s or autoinvoice will have capablity to update.

    To update item/memo line , see what api’s Oracle is using, but i guess that is not public.

    I am suspecting, program is also link with auto accounting.

  3. Vikas Kumar Says:

    i am using AR_INVOICE_API_PUB.create_invoice API to create invoice.
    invoice is generating and API populates the AR_TRX_HEADER_GT, AR_TRX_LINE_GT tables.
    my problem is the data is not populating in the ra_customer_trx_all. please provide the solution

Leave a Comment

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