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

Power of Autoinvoice

Posted on May 21st, 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

Here is note on one of most efficient tool used in Oracle application. It is Auto Invoice, most industry accepted tool in Oracle apps.

 

What is Auto Invoice??

Auto Invoice is a tool that can be used to import and validate transaction data from other financial systems from which one can create invoices, debit memos, credit memos, and on-account credits. It rejects transactions with invalid information to insure the integrity of the data.Ratax

Where its fits 

 This fits well with in Oracle ERP or to integrate with any third party application< ?xml:namespace prefix ="" o />

 

What Module data can be integrated?

  • Oracle Order Management
  • Oracle Project Accounting
  • Oracle services

 

To make fully functional  what else required

  • Loader program
  • Validation program

Top 10 reasons for using Auto Invoice

 

1. Powerful Interface Tool

2. Supports Oracle & Non-Oracle Systems

3. Import Large Amount of Data

4. Calculate or Import Tax

5. Group Lines & Invoices

6. Online Error Correction

7 .Lines Validation

8. Derive GL Date

9 .Import Flex fields

10.Import or Derive Accounting Info

 

 

What is inside AutoInvoice

 

AutoInvoice is a tool consists of 3 main programs. Each program will have unique nature of work to do and they are called internally except Purge program whose execution is derived on the setup otherwise ready to execute stand alone.

§         Master (RAXMTR)

§         Import (RAXTRX)

§         Purge (RAXDEL)

 

1.       Auto Invoice Master program RAXMTR

Selects and marks records in the interface tables to  be processed based on the parameters the user entered and then calls the AutoInvoice Import program. Auto Invoice Master program has no report output.

 

•Gathers statistics, it means it gathers the stats on interface tables and set the stats on certain indices on interface tables

•Marks interface records for processing by marking request_id

•Submits multiple workers for Parallel Processing by creating instances for request.

 

2.       Auto Invoice Import Program Validates the selected record and creates transaction if it passes validation. Any record that fails validation is left in the interface table with an error code. Depending on the setup, related records may be rejected as well. This program has an output file called Auto Invoice Execution report, which you can view by clicking the View Report button in the Requests window.

 

  • Workhorse of Auto invoice
  • Validates data
  • Inserts records
  • Deletes interface data
  • Only when system option purge set to ‘Y’

 

3.       Auto Invoice Purge Program Deletes records from the interface tables. If you set the Purge Interface Table system option to No in Define System Option window, Auto Invoice does not delete processed records from the interface tables after each run,and we must submit Auto Invoice Purge Program periodically to clean up the interface tables. This program only deletes transaction lines that have been successfully imported.

•Deletes all rows where interface_status =‘P’

•Ra_interface_lines

•Ra_interface_distributions

•Ra_interface_salescredits

 

How to start

 

FeederAs discussed above, oracle Receivable’s Auto Invoice program will be used to import and validate Invoices.

 

A custom feeder program is required to transfer data from the Advantage extract files and populate the Auto Invoice interface tables (RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL).If there is need to run populate sales credit into RA_INTERFACE_SALESCREDITS_ALL table.

 

When run, AutoInvoice produces the AutoInvoice Execution Report and the AutoInvoice Validation Report.

Any entries which failed validation can be reviewed in Oracle Receivables’ AutoInvoice Interface Exceptions window. Depending on the error, changes may need to be made in Receivables, the feeder program or the imported records in the interface tables.

 

 

 

 

 

 

 

 

 

 

How Autoinvoice Execution works

Normally, Auto Invoice can be divided into three major phases

 

  • Pre-grouping: here the validates all of the line level data takes place
  • Grouping: groups lines based on the grouping rules and validates header level data
  • Transfer :validates information that exists in Receivables tables

 What happen when Auto invoice run

 

Once the Auto invoice Program gets called, the following activity takes place is part of execution process. This can be analyzed by debug options.

 

  • Line, accounting, and sales credit information for each line populates 3 interface tables
  • Lines are ordered and grouped
  • Tax is calculated
  • GL date is determined
  • GL accounts are assigned using Auto Accounting
  • Tax, freight, commitments, and credit memos are linked to transaction lines
  • All transactions are batched
  • Validated lines are used to create the transaction

 How Data is flowing

Select, insert and update and delete take place on certain tables once it is logged out.

Selects

            – RA_INTERFACE_LINES_ALL

            – RA_INTERFACE_DISTRIBUTIONS_ALL

            – RA_INTERFACE_SALESCREDITS_ALL

 

Updates/Insert

            – RA_INTERFACE_ERRORS_ALL

            – RA_CUSTOMER_TRX_ALL

            – RA_CUSTOMER_TRX_LINES_ALL

            – AR_PAYMENT_SCHEDULES_ALL

            – AR_RECEIVABLE_APPLICATIONS_ALL

Inserts

            – RA_INTERFACE_ERRORS_ALL

 

 

AutoInvoice Exception Handling

 

Records that fail validation are called ‘Exceptions’

  • Exceptions stay in Interface Tables which is RA_INTERFACE_ERRORS_ALL
  • Errors can be corrected in the Exception Handling window
  • Once corrections are made, Auto invoice must be resubmitted
  • Records that pass validation get transferred to Receivables tables 

AutoInvoice Exception Handling Windows

  • Interface Exception window displays exception messages associated with all invalid records
  • Interface Lines window displays records that fail validation, provides an error message and can be used to correct the errors
  • The Line Errors windows displays errors associated with a specific line, and can only be opened from Interface Lines window
  • Interface Exceptions window displays Interface Id, Exception Type, Error Message and Invalid Value associated to the error
  • Data cannot be edited in this window, but error can be viewed and corrected by clicking the Details button
  • Error Message and Column name with invalid data are displayed in the Message column, and the invalid value that needs to be corrected is displayed in the Invalid Value column

 

Next post, I would summarize more information for Transaction Flexfield,Grouping , profile options and parameter setting.

Related Posts

Posted in API Integration, Oracle Receivable | 43 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
43 Responses
  1. Arvinda Says:

    Hi Anand,

    Thanks a lot for the document compiled in such clarity and simplicity. I am a techno-functional consultant for AR in my company, but my experience is just two years, and such literature helps me a great deal in reinforcing my concepts.

    Please keep writing, I will be a regular visitor! :)

    Regards,
    Arvinda.

  2. koushik Says:

    Hi Anand,

    It was excelent and nicely explained…. thanks a lot …its really a great help .

    best wishes
    koushik

  3. Oracle API Availability - Oracle Receivables (AR) Says:

    […] into the Oracle Applications by the AutoInvoice Import process.You can also refer my old post for autoinvoice […]

  4. Hassan Says:

    AR open interface / AutoInvoice to import customer transaction lines.
    Can Any one help on this issue.
    I need to import some customers transactions lines (invoice, credit) using AR interface table then AutoInvoice.
    The customers are supposed to be in AR.
    Transactions lines are :

    1 Customer (Unique on the source system, not in AR) VCHAR(10)
    2 Item_no (transaction Ref. in the source system)
    VCHAR(10)
    3 Transaction_date Date
    4 kind (transaction type) CHAR(10)
    4 Amount Number

    Thank you for your prompt reply and help.

  5. Anand Says:

    I am not very sure , what exactly you are looking for, what i guess you need to figure out how to set the transaction flexfield to do invoice and credit memo transaction

    if my assumption is correct, here are the steps you need to perform:

    Make setup steps required:

    1) Define Invoice Sources
    Name : TestHassan
    Type : Imported
    Status : Active
    Standard Transaction Type: Invoice
    -Autoinvoice Processing Options
    Allow Sales Credit No
    -Autoinvoice Data Validation:
    Accounting Flexfield : Segment
    Revenue Account Allocation: Amount

    2)Now next you have to set the two Descriptive Flexfield Segments:

    a)Title: Line Transaction Flexfield
    Context Field Values:TestHassan
    Description: TestHassan invoice and cr memo line
    Segment1: Enabled: Yes – Column : INTERFACE_LINE_ATTRIBUTE1
    Name : INVOICE SOURCE – Number 1 -Description : Invoice source
    Value Set …
    Required No – Enable Security No – Display No

    Segment2: Enabled: Yes – Column : INTERFACE_LINE_ATTRIBUTE2
    Name : Customer – varchar -Description : Customer
    Value Set ….
    Required No – Enable Security No – Display No

    Segment3: Enabled: Yes – Column : INTERFACE_LINE_ATTRIBUTE3
    Name : Item_no – -Description : Item_no
    Value Set :…
    Required No – Enable Security No – Display No

    i donot think additional you need to create the other 3, as they are already in some other column…
    Indeed, you have some room there make use for 4..5..6

    Similary you need to define for your creditmemo transaction like

    b) Title: Link-to Transaction Flexfield
    Context Field Values: TestHassan – Enabled Yes
    Description: TestHassan invoice and cr memo line
    Segment1: Enabled: Yes – Column : LINK_TO_LINE_ATTRIBUTE1
    Name : INVOICE SOURCE – Number 1 -Description : Invoice source
    Value Set …
    Required No – Enable Security No – Display No

    Segment2: Enabled: Yes – Column : LINK_TO_LINE_ATTRIBUTE2
    Name LIST ID – Number 2 – Description : List id
    Value Set blank
    Required No – Enable Security No – Display No

    Segment3: Enabled: Yes – Column : LINK_TO_LINE_ATTRIBUTE3
    Name TRANSACTION NUMBER – Number 3- Description : Transaction no
    Value Set blank
    Required No – Enable Security No – Display No

    Segment4: Enabled: Yes – Column : LINK_TO_LINE_ATTRIBUTE4
    Name LINE NO Number 1 Description : Line no
    Value Set blank
    Required No – Enable Security No – Display No

    make sure you have freezed your flexfield when all the set up is done.

    3) orig_system_bill_address_id : your address reference id
    orig_system_bill_customer_id : the customer_id of the customer you want to use

    This is part which is directly linked to your

    and finally try to create a record into interface table and then run the import

    INSERT INTO ra_interface_lines_all (
    amount,
    * 1) batch_source_name,
    currency_code,
    cust_trx_type_id,
    cust_trx_type_name,
    description,
    interface_line_attribute1,
    interface_line_attribute2,
    interface_line_attribute3,
    * 2a) interface_line_context,
    line_type,
    * 3) orig_system_bill_address_id,
    orig_system_bill_customer_id,
    set_of_books_id,
    term_name,
    term_id,
    trx_date,
    gl_date,
    trx_number,
    created_by,
    creation_date,
    last_update_date,
    last_updated_by)
    ( ….)

    …for Credit
    INSERT INTO ra_interface_lines_all (
    amount,
    batch_source_name,
    currency_code,
    cust_trx_type_id,
    cust_trx_type_name,
    description,
    interface_line_attribute1,
    interface_line_attribute2,
    interface_line_attribute3,
    * 2b) interface_line_context,
    line_type,
    link_to_line_attribute1,
    link_to_line_attribute2,
    link_to_line_attribute3,
    link_to_line_attribute4,
    link_to_line_context,
    orig_system_bill_address_id,
    orig_system_bill_customer_id,
    purchase_order,
    sales_order,
    set_of_books_id,
    term_name,
    term_id,
    trx_date,
    gl_date,
    trx_number,
    tax_code,
    created_by,
    creation_date,
    last_update_date,
    last_updated_by)

    Incase if you need any further info let me know..

  6. Murali Says:

    Hi ,

    This notes is too good and is very much helpful, but i have a doubt with this auto-invoice process like where does the validation take place? is it after the autoinvoice pgm is run or before even that? can anyone get me that point cleared?

  7. Veena Says:

    Hello, How do you run the autoinvoice program? Is it a button or menu?

    Thanks,

    Veena

  8. Anand Says:

    there is 2 options.
    1. with AR responsiblity , there is menu for autoinvoice

    2. other is you can called standard submit requset(SRS) screen and select master import program.

  9. umesh Says:

    hi,

    I wanna my invoice to get generated such that accout code will get populated from ra_interface_distributions_all table not from accounting rule which we defined for different account class. What changes i should do n wht entry i should pass in ra_interface_distribution_table please suggest..

    rgds,
    Umesh

  10. Michelle Says:

    Hi anand,
    The code you have written insert into(…) is that the code we write to migrate from legacy to Oracle receivables using SQL loader?? Your response is greatly appreciated!!

  11. Rohit Says:

    Hi All…

    I am working on the AR Receipts conversion….& I need to extract the data from one instance in the ‘CONVERT’ transmission format….

    Can anybody help me????

    Waiting for reply

    Rohit

  12. kartikey Says:

    Hi,
    Nice doc.I have scheduled my auto invoice prog now there are 2 requirments:
    1.I can not see the output of my PA tieback and PA interface prog (which comes on my mail through notification) more then one time
    while opening it second time it give error “Authentication failed.” So can I see the output more then one time
    2.how can I send the output of autoinovice import programe through notification to my mail.How should i configure it so that i can see the output of import prog on my mail.
    Plz reply asap.

    Thanks in advance
    kartikey

  13. Ajeet Says:

    I wish to be a techno-functional consultant. By education I am a technical one, however, I am keen to shift my career to apps, anybod please advice, thank you

    ajeet

  14. Yugandhar A Says:

    Hi
    It was excelent and good information .

    Regards
    Yugandhar A

  15. oszel Says:

    Hi Anand,

    I’m working with oracle AR. I’m Techno Functional for just about a year only.

    My current task is to interface Data from a Revenue Management system (SQIVA) to Oracle. I get te concept of Autoinvoce and Set up needed but my problem is with the Mapping of data from SQIVA to Oracle and DFF that are to be used.

    Thanks for your help.

  16. Sanjit Anand Says:

    autoinvoice is not so difficult once you done the mapping from feeder system to interface table. Only 2 Flex field you can define in the system, plus some of setup options like autoaccounting rule set , transaction type,Transaction source.

    Did you able to load for couple of records or not.if not try to load few records with the query in above comment , and once it is done, you can frame everything in your package.

    If you need any help in term of mapping, code do hesitate to contact me offline, I will assit you.

    sanjit

  17. udi Says:

    Hi,

    I have bulk of invoices to load, what is the order that the open interface load the invoices into the AR tables ?
    is it by gl_date?creation_date? or some other field ?

    Thanks,

    Udi.

  18. Sanjit Anand Says:

    Not sure what is meant by “bulk Load”, it is migrating invoices from other system or interfacing with other billing system, in both the case , you should be very careful in putting GL_DATE, for Receivable and Revenue recognition might get conflicting:

    The order in which you should suppose to load is:
    a)RA_INTERFACE_LINES_ALL
    b)RA_INTERFACE_DISTRIBUTIONS_ALL
    c)RA_INTERFACE_SALESCREDITS_ALL( if you have sales credit info, then use this table)
    the link between a, b should be established.

    >>>Donot get confused with GL_DATE and creation_date

    Creation_date is part of who column requirement just for audit, as EBS is capturing, and keeping.

    GL_date is one for which the transaction is booked agaist that period.A date within a month window is booked.

    More importantly, when the “Derive date” Check Box is checked in the Import Source Defination, then it will pick the date from RA_INTERFACE_LINE_ALL

    More over here is the rule for Rules for Deriving GL Date:

    1. If you populate gl_date in RA_INTERFACE_LINES_ALL, AutoInvoice will give your transactions the GL Date you provided.

    2. If you set up transactions with accounting rules, Autoinvoice will use the rule_start_date for the GL Date
    as long as the Invoicing Rule is ‘Bill In Advance’. If you use the Invoicing Rule ‘Bill In Arrears’, you must use an Accounting
    Rule with a fixed duration since AutoInvoice uses the Rule Start Date as the GL Date. If you have created many Rule Start Dates,
    the earliest date will be used as the GL Date for the transaction.

    3. AutoInvoice will use the Default Date you enter at runtime under the following conditions:

    i. You didn’t populate gl_date in RA_INTERFACE_LINES_ALL.
    ii. You unchecked ‘Derive Date’ in the Batch Source definition, as discussed above.
    iii. You are not using Accounting Rules.

    4. If you checked ‘Derive Date’, Autoinvoice will search the following columns for a date to use as the GL Date, stopping at
    the first one that provides a date:

    i. Ship_date_actual in RA_INTERFACE_LINES_ALL.
    ii. Sales_order_date In RA_INTERFACE_LINES_ALL.
    iii. Default Date from the AutoInvoice submittal.

    If you set ‘GL Date in a Closed Period’ in the Batch Source to Reject, AutoInvoice rejects transactions whose GL Date isn’t in an open
    or defined period. You must have the period open in AR, GL, and INV if INV is fully installed. AutoInvoice will also reject a transaction
    if you open overlapping periods.

    If you set ‘GL Date in a Closed Period’ in the Batch Source to Adjust,Autoinvoice determines the GL Date as follows:

    A. The last day of the last open prior period.

    B. The first day of a subsequent open period. BUT, if you have more than one subsequent period open, Autoinvoice rejects the transaction.

    C. If you have no subsequent open period AutoInvoice uses the first Future Enterable period. If you have more than one Future Enterable period, AutoInvoice rejects the transaction.

    Hope this helps..
    sanjit

  19. Prasad B Says:

    Hi,

    How do I ignore invoice lines for one customer till the end of Month and group all lines for given customer at the end of month.

    Regards,

    Prasad

  20. Payal Says:

    Hi,

    I want to import cash on account using autoinvoice program.
    Is it doable? of so, how do I do it?

  21. Sanjit Anand Says:

    not sure , why you are trying to get invoice cash on account. I donot think autoinvoice can handle cash on account. There are public API which can figure out.

    Normally autoinvoice is designed to import transactions as complete. The functionality you seek is not available in that program atleast as far as know.

    You might consider using lockbox to import the data as receipts by customer and then Oracle will apply the cash to On Account.

    -sanjit

  22. Girish Says:

    Hi,
    Have done all set up in R12 for auto invoice. but getting error:
    Invalid legal entity id;
    Please supply both an invoicing rule and an accounting rule for this invoice.
    Can somebody please help,
    Thanks
    Girish

  23. Girish Says:

    Sajit,
    If you can throw light on this problem please with your expertise,
    Thanks
    Girish

  24. Sanjit Anand Says:

    Girish,

    The error seems to be Because of some missing setup..

    Please check your setup , i am suspecting the Legal entity setup conflicts with autoinvoice here , more over the LE is one who drivs the whole flow.

    The setup of LE is part of your accounting setup manager, which I am hoping you have already done correctly.

    I have already covered LE uptake in AR and you should understand, all AR activity must have a legal owner, so Legal Entity is stamped on every transaction. Receivables stamps each transaction (invoice, debit memo, etc) and each receipt header with the Legal Entity information.

    Moreover you should also note that each transaction can only belong to one Legal Entity,and in the case when multiple legal entities exist, either the system or the user will assign the LE to the activity.

    The question is how:

    The answer of the question is best understood in two dimesnion :

    1)Legal Entities and Accounting
    2)Legal Entity Description Defaulting for Transactions

    if you see the Oracle documentation, There are two accounting environments, exclusive and shared.In this case ,The legal entity can be derived from the operating unit because the operation unit and the LE point to the same ledger and there is a one to one relationship between legal entity and ledger.In the case of other like shared accounting model,typically understood as multiple LE’s point to the same ledger,by this AR narrows down the list of applicable LE’s, based on the LE’s associated with the ledger that the operating unit is assigned to.

    When multiple LE are available, then a hierarchy is needed to supply the default LE on the transaction. The default value can be updated on the transaction.

    You should also note the defaulting hierarchy for a transaction comes from the setup of the Transaction Type and Transaction Batch Source. Receivables will look first to the Transaction type. If a LE has not been assigned, then Receivables will look to the Batch Source.( This is the answer of your first part)

    Secondly, the assignment of the LE to the Transaction Type and Transaction Batch Source is optional, so if Receivables cannot find a default LE, then it is up to the user to provide the LE value. what you have to do you need to recheck the setup, what is there.

    Normally AR creates a list of values for LE based on the LE’s mapped to the same Ledger as the OU. This list is available to the Transaction Type and Transaction Batch Source.

    Here is the steps you have to go throw:

    From Responsibility: Receivables
    Navigation: Setup:Transactions > Transaction Types

    The key setup steps are optional and only needed in a Shared Accounting environment (more than one Legal Entity pointing to a ledger)(Adopted from Oracle User Guide)

    1)Optionally update transaction type to default the LE value onto transactions when using a shared accounting environment.

    2)Optionally update transaction batch source to default the LE value onto transactions when using a shared accounting environment.

    3)When deciding whether to assign the LE to the Transaction Type and Transaction Batch Source, considering only assigning it to one level; either the transaction type or the batch source, but not both. Receivable will not look to Batch Source if transaction type has a value, the user could be performing more setup than necessary if the assignment is made at both levels.

    The process is then executed as follows:

    (i)Run AutoInvoice to import . It will accept whatever LE is passed as long as it is an active LE.

    (ii)If the Legal Entity is not provided by the feeder system, AR will attempt to default the LE first from the Transaction Type assigned to invoice lines

    (iii)If no LE exists on the transaction type, AR will attempt to default the LE from the transaction Batch Source

    (iv)If no LE exists on the batch source, AutoInvoice will error, indicating valid LE could not be found.

    (v)The user must update the AutoInvoice record with a valid LE. This can be done via the Interface Lines Form the same as other corrections.

    (vi)If the invoice is created with a LE that is valid, but incorrect, the user would need to do a credit and rebill. This would credit the original transaction with the incorrect LE, and create the new invoice with the correct LE.

    (vii)If the invoice can be incompleted after import (no activity is against it, or it has not been printed), the Legal Entity can be modified by the user.

    (viii)If a legacy system passes the LE, then AutoInvoice will check to see if it is valid, and error out if it is not.

    While importing invoices ,AutoInvoice assumes the LE is correct, and should be active, and If LE is not passed, AutoInvoice attempts to default the LE
    AutoInvoice Validation report displays “Invalid Legal Entity”
    If Legal Entity is not valid, or Legal Entity cannot be determined.

    Hope you have a clear picture on what’s happening inside.

    I would rather advice, read this post from Dave’s Blog, who put some architectural consideration of OU and LE.
    http://davidhaimes.wordpress.com/2007/12/11/can-i-assign-an-operating-unit-to-2-legal-entities/

    Let me know, in case if this does not work.

    thanks
    sanjit

  25. Dave Noble Says:

    Great stuff.Just got Autoinvoicing working using your document as my core info

    Thanks

  26. Sanjit Anand Says:

    Thanks Dave…

  27. Venkata Krishna Peram Says:

    Very Nice. I have lot of confusion so far on auto invoice. After reading this article I am clear. Thanks alot for the posting your notes.

  28. Maha Says:

    i have inserted into one record into
    a)RA_INTERFACE_LINES_ALL
    b)RA_INTERFACE_DISTRIBUTIONS_ALL

    and it gave me this error
    pleaaaaaaaaas help me

    Receivables: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    RAXMTR module: Autoinvoice Master Program
    +—————————————————————————+

    Current system time is 05-JUN-2008 16:57:35

    +—————————————————————————+

    crb->raaucrpn = RAXTRX
    crb->raaucrcr =
    crb->raaucrnt = 0
    crb->raaucrml = 0
    No data found

    Total rows for current operating unit: 1
    Batch source [irshad]: 0
    +—————————————————————————+
    Start of log messages from FND_FILE
    +—————————————————————————+
    +—————————————————————————+
    End of log messages from FND_FILE
    +—————————————————————————+

    +—————————————————————————+
    Executing request completion options…

    +————- 1) PRINT ————-+

    Printing output file.
    Request ID : 438468
    Number of copies : 0
    Printer : noprint

    +————————————–+

    Finished executing request completion options.

    +—————————————————————————+
    Concurrent request completed successfully
    Current system time is 05-JUN-2008 16:57:35

    +———————————————-

  29. Maha Says:

    please iam making autoinvoice API Receivables: Version :12.0.0
    and since 2 days i coudnt make anything.
    and this is my first time that i wrok AR api.
    please help me

  30. satish kumar Says:

    Sir,

    Iam tech-functional in my company . Very useful document.

    I want to know how to get the delivery id option in auto invioce master programm

    kindly advice me

  31. Lakshmi Says:

    Hello Sanjit Anand,

    Your notes for the Autoinvoice is really very nice,thanks to give such a good Functional Understanding.I feel you can help me out.I have to write this Autoinvoice Interface and load the data from the legacy system.Could you plz help me to send me code for Autoinvoice Program.it will be a great help for me if you could send me soon,i am trying to write it now.
    my mail id is lakshmi_ses@yahoo.com
    Regards
    Lakshmi

  32. Sanjit Anand Says:

    Lakshmi,

    check it out to your mailbox.

    thanks
    sanjit

  33. Mouly Says:

    Hi Sanjit,
    When running the autoinvoice, I am getting this error,
    “Please correct the revenue account assignment (100……)”
    The autoaccounting is not able to derive the accounting segments and so the error. Actually i have verified the sales account set at item, but that is not getting populated by the autoaccounting.
    In the autoaccounting, for Revenue type, i have set the table name as ‘Standard Lines’.
    Pls let me know what i m missing here. thx a lot for ur help!

  34. Sanjit Anand Says:

    I am suspecting some of the missing setup which cause this issue:

    In summary these kind of issue is beacuse of
    1) Autoaccouting setup
    2) Memo line Setup
    3) Item defination setup

    quick check 1:
    Go in Receivables Responsiblity
    Setup > Transactions > Sources
    Query the source that you are importing
    Go in the Other Information tab
    Check the setup for Memo Line Rule.

    Quick check 2:
    Other way to do you can analayze the log and try to find the root cause.
    1) Make sure you have done the proper setup for the source for your autoaccounting in AR
    Go to Setup->Transactions->Autoaccounting
    Pay particular attention to the REVENUE sources and write them down. .

    2) Go to each line that was rejected and manually walk through how each segment is built (fetch them from the proper sources as identified in step 1.

    Make sure that the accounts shown on the Autoinvoice Execution report (in the validation errors) are truly the correct accounts based on your setup.

    3) Go into GL and verify that those accounts (the results of step 2) are valid, enabled, and that there are no problems with them (there probably are some recent changes that caused this)

    4) If you still think they are valid after doing steps 1-3, go ahead and enter a new transaction and attempt to override the distributions to one of the invalid accounts and see if the form lets it pass. When the form rejects an account, it often puts the cursor on the bad segment -and that can be helpful in tracking down what is causing the rejections.

    Couple of other things you should also quick check:
    If it has transaction type, then you have to check the transaction type you are using and make sure that you have assigned a revenue account.

    If it has standard lines, then you have to check the standard lines you are using and make sure that you have assigned a sales account.

    Check it out in the Item defnition endable invoiceble flag, anmd check the how Sales account are linked with Revenue account.

    Send me the screen snapshoot sanjitanand@yahoo.com

    1)Standard Lines – For an Inventory Item navigate to
    Menu: Setup>Transactions>Items>Inventory items,
    verify the ‘Sales Account’ is populated in the ‘Invoicing’ alternate region.
    For a Memo Line,
    navigate to Setup =>Transactions =>Memo Lines, and make sure that ‘Revenue Account’ is populated.

  35. Gayatri Says:

    Hi Anand,

    Thank you for explaining the Auto Invoice process. I am working on importing open AR from a legacy system to Oracle R11i.
    I was planning on importing the data into RA_INTERFACE_LINES_ALL using SQLLoader then run the Autoinvoice Import Progam. Does this work?. Am I required to have data into AR_INERFACE_DISTRIBUTIONS_ALL for the Autoinvoice Import to work?

    Appreciate your input.

    Thanks Gayatri

  36. Milan Naik Says:

    Hi Anand

    Very nice article. I am totally new ( 5 months ) into Oracle applications and trying to import invoices. I have added a test record in the ra_interface)lines_all table only. I am getting errors. IS it possible you can send me your email and we can talk ?

  37. krs Says:

    When you run the Auto Invoice, where does it get the order details from ?

  38. Q Haque Says:

    hai dear,
    i wanna know that may i create invoice fortnightly through Autoinvoice Master Programme ??
    and i want to make one invoice for one customer fortnightly grouping by sales agreement. is it possable through Autoinvoiceing ?
    please help.

  39. api Says:

    hi,
    I understood the flow of api.can i know me the flow through a sample code.It would be helpful.

  40. Dumitru Says:

    Hi,
    Is there any way to get transactions from interface with complete_flag set to ‘N’.
    Thank you.

  41. Sanjit Anand Says:

    Hi Dumitru ,

    there is no column which you can map it to make transaction incomplete status after autoinvoice.

    If Customer want the status incomplete , what you have to do, you need to have a post update process which will makes transaction incomplete.

    The details are discussed previouly in one of the comment.

    checj it out else let me know if you stuck.

    thanks
    sanjit

  42. Abid Ali Says:

    Hi
    Nice Help artical for bigneers
    can any one help me from basic how i can integrate my app (AR) to RMS (SQL Server) , i need basic help .
    I am new in Apps.
    Thanks

    Abid Ali
    tomianabidpk@yahoo.com
    oracledeveloper@styloshoes.com.pk
    0092-3434726428

  43. Alencar M Oliveira Says:

    Hi, I need to import 30.000.000 of itens to AR using autoinvoice and i have only 3 days to this. How to improve high performe to autoinvoice process ? Tks for help !!!

Leave a Comment

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