AR Auto Invoice Interface for Beginers - A very useful starter article

in ; Oracle E-Business Suite R12 You have been tasked with developing an interface to AR and you’ve never used Oracle’s Auto ...
+ Post Reply + Post New Topic
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
  1. #1
    Ramji's Avatar
    Ramji is offline Forum Guru
    Points: 18,080, Level: 85
    Join Date
    14 Jan 2012
    Location
    Nomad
    Posts
    523
    Points
    18,080

    AR Auto Invoice Interface for Beginers - A very useful starter article

    Oracle E-Business Suite R12
    You have been tasked with developing an interface to AR and you’ve never used Oracle’s Auto Invoice before. What do you do?

    This gives you an overall understanding of the process and pitfalls that one should be aware of.

    What is Auto Invoice?

    Auto Invoice is a very powerful process in Oracle EBS that provides a mechanism to import receivable transactions from external systems. Similar to other modules within EBS, Oracle provides a set of interface tables and concurrent processes to import receivable transactions into Oracle AR performs. The processes validate the transactions and import them into AR.

    Pre-requisites
    To successfully interfacing the external systems’ invoices to Oracle AR, the following setups/configurations are required. Failure to complete these setups will result in invoices being rejected during the validation stage of Auto Invoice
    Transaction Source – The transaction source is specific to the operating unit. The transaction sours defines how values in invoice lines will be interpreted and validated, such as grouping rules and customer information.
    Transaction Type – The transaction type defines the accounting information for the lines and how each line will be validated and processed.
    Line Transaction Flexfield – The line transaction flexfield defines how invoices will be grouped.
    Grouping Rules – The grouping rules allow you to customize how credit and revenue lines should be grouped to form an invoice
    Customers
    Currencies
    Items
    Payment Terms
    What are the tables utilized by Auto Invoice?
    Depending upon the type of transactions that are being imported, the Auto Invoice process populates the following tables:
    RA_CUSTOMER_TRX_ALL – Stores invoice information
    RA_CUSTOMER_TRX_LINES_ALL – Invoice line information can be found here
    RA_PAYMENT_SCHEDULES_ALL – Oracle records an entry here, except for adjustments and miscellaneous cash receipt transactions
    RA_RECEIVABLE_APPLICATIONS_ALL – The accounting entries for cash and credit memos are stored here
    RA_INTERFACE_ERRORS_ALL – All errors encountered during the Auto Invoice process are written to this table.
    Here is the list of tables that the Auto Invoice process utilizes:
    RA_INTERFACE_LINES_ALL
    RA_INTERFACE_DISTRIBUTIONS_ALL
    RA_INTERFACE_SALESCREDITS_ALL

    Post Setup data flows through the tables. What’s next?

    The interface looks simple and easy to use, but it gets tricky. The requirements for populating the interface tables depend on how the application is configured. For example, let’s the transaction source is defined as ‘My Company US Transaction Source’ for the US Operating Unit. If you use this source for a different operating unit, the invoices will not be selected for validation. Similarly, how the customer information is validated is dependent on how the transaction source is setup. If the transaction source is setup to use “ID”, then usage of internal IDs is required in the interface tables. If the transaction source is setup to use ‘Value’, then the Auto Invoice will not look for the actual value of the customer but the reference fields for the customer and the site.
    After populating the interface tables, now how do I run Auto Invoice?

    The Auto Invoice process consists of three concurrent programs:
    Auto Invoice Master program – Selects and marks invoices in the interface tables for processing based on the parameters, and calls the Auto Invoice Import program
    Auto Invoice Import program – Validates the selected invoice lines and distributions and when all are validated, creates the invoices or else populates the error table
    Auto Invoice Purge program – Removes processed records from the interface tables. If the system is setup to remove processed records after each run then this process is not necessary.
    The Auto Invoice interface performs the following tasks:
    Validates all lines
    Calculates tax
    Determines the GL period
    GL accounts are assigned to Auto Accounting
    Groups and orders invoice lines
    Links credit memos, tax or freight to invoice lines, if applicable
    Transfers the invoices to AR tables
    After a successful completion of the Auto Invoice Interface process, the Auto Invoice Execution Results Report will list the lines that were successfully transferred and the lines that failed. The errors can be corrected either manually or via the Interface Exceptions window. Once corrected the Auto Invoice process can be resubmitted to pick up the previously rejected transactions. Even if invoices are successfully created, you should validate invoices from the front-end to ensure the fields have been properly brought over to their rightful place and the accounting entries were created as desired.
    Attached Files
    Last edited by Ramji; 02-29-2012 at 08:50 PM.
    Sadik, tomloera, Bharat and 3 others say Thanks.


  2. #2
    Yumna is offline Member
    Points: 870, Level: 15
    Join Date
    02 May 2013
    Posts
    31
    Points
    870

    Re: AR Auto Invoice Interface for Beginers - A very useful starter article

    Hi,

    is auto invoicing is also for lockbox in AR???

  3. #3
    Nizbleseehife is offline Junior Member
    Points: 10, Level: 1
    Join Date
    29 Aug 2013
    Location
    Đîńńč˙
    Posts
    1
    Points
    10

    спасибо вам

    Скажите мне, пожалуйста - где я могу найти больше информации по этому вопросу?

  4. #4
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    сонник матрас

    Вы наверное уже слишком давно на пенсии и еще по совковски думаете, а не нынешней реальностью. Факт тот что не к дебилам идут, не говорят им что по помойкам лазить нельзя, что жрать говно нельзя, что спать нельзя в канализации. матрас вегас 5

  5. #5
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    матрас ролл

    Так что всё, что он говорил вовсе не юмор, а вполне профессиональная работа. Есть в стране небольшие городки в которых 90е никуда и не исчезали. матрасы lovia

  6. #6
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    матрас кокос &

    А эти спектакли с повышением пенсии уже устарели. Но не вокруг когото человека зачастую могут запугать, подкупить и т. постельные матрасы

  7. #7
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    матрас люкс

    Уж и нам надоело ждать не отключают. Но этого не произошло. интернет магазин матрасы кровати

  8. #8
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    ортопедическ

    А кого же теперь за ваучеры ругать в канун нового этапа прихватизации? Дело в том, что вокруг них начинают образовываться глубокие морщины, которые придают женскому выражению лица особую озлобленность. матрасы немецкие

  9. #9
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    матрасы в кор&

    Они только такие меры понимают. В ходе перестрелки пятеро преступников были убиты, трое задержаны. матрасы мемори

  10. #10
    tutfluenlyfar is offline Junior Member
    Points: 70, Level: 1
    Join Date
    02 Sep 2013
    Location
    Poland
    Posts
    7
    Points
    70

    матрасы

    Лука хотя бы не аллах. Она ловится практически во всех уголках нашей страны, там где не ловится ничто другое. матрасы на заказ

Page 1 of 2 1 2 LastLast
Other Solutions
  1. Replies: 3
    Last Post: 02-01-2012, 08:55 PM
  2. Replies: 1
    Last Post: 12-02-2011, 11:37 AM
  3. Replies: 1
    Last Post: 10-31-2011, 06:43 AM
  4. How to allocate Expense Invoice to 'Match to Receipt' Invoice
    By Indra Stp in forum Oracle Financials
    Replies: 0
    Last Post: 02-17-2011, 04:37 AM
  5. Auto Data Backup !
    By ah.yasar in forum Oracle Webcenter Suite (formerly Oracle ECM)
    Replies: 1
    Last Post: 11-19-2009, 12:33 PM