http:\/\/www.oracleappshub.com\/accounts-receivable\/ar-invoice-api-application-program-interface\/
\n
\nHave you joined Hub Community Network Forums of OracleaApps professionals? Don’t wait. Do it today<\/p>\n
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.<\/p>\n
dgreybarrowWith this API’s you can manage<\/p>\n
Single or multiple invoice(s) creation when you required
\n This will extensive defaulting which minimizes the programming effort
\n Validation ensures quality data
\n You can use debug messages in a central repository that improves coding efficiency
\n You can get immediate results<\/p>\n
dgreybarrowHow to start with API’s Usage<\/p>\n
Very similar to AutoInvoice , you need following setup.<\/p>\n
Payment Terms
\n Invoice Transaction Type
\n Transaction Batch Source
\n Currency
\n Customer
\n Remit to Address
\n AutoAccounting<\/p>\n
Optional Setup<\/p>\n
Salesperson
\n Document Numbering
\n Inventory or Memo line id<\/p>\n
Additionally you need to make sure these should be used<\/p>\n
tickR11i<\/p>\n
fnd_global.apps_initialize
\n dbms_application_info.set_client_info(’&Org_id’); — if using TOAD or sqlplus<\/p>\n
tickR12<\/p>\n
fnd_global.apps_initialize
\n mo_global.set_policy_context
\n xla_security_pkg.set_security_context<\/p>\n
dgreybarrowWhat are the API’S<\/p>\n
AR_INVOICE_API_PUB<\/p>\n
This API will have 2 routine call, which you can either create single\/multiple in batch or single invoice.<\/p>\n
tickar_invoice_api_pub.create_invoice: Creates multiple invoices in a batch.
\n tickar_invoice_api_pub.create_single_invoice: Creates a single invoice and return customer trx id.<\/p>\n
dgreybarrow Important Tips and notes<\/p>\n
These API can only be used to create new transactions, not use for update existing ones.
\n This API can only create 'INV’ type transactions. It is not desgined to create Debit Memos\/credit memo.
\n When you load via the AR_INVOICE_API_PUB it populates the temp tables AR_TRX_HEADER_GT, AR_TRX_LINE_GT
\n The transaction number is populated when automatic transaction numbering is selected on the transaction batch source.
\n The Publically supported transaction API is AR_INVOICE_API_PUB have source file ARXPINVB.pls , ARXPINVS.pls.
\n 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<\/p>\n
dgreybarrowAutoinvoice Vs Transactions API
\nIts 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.<\/p>\n","protected":false},"excerpt":{"rendered":"
http:\/\/www.oracleappshub.com\/accounts-receivable\/ar-invoice-api-application-program-interface\/<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/453"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=453"}],"version-history":[{"count":3,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions"}],"predecessor-version":[{"id":457,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions\/457"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}