1 2 Previous Next 15 Replies Latest reply on May 24, 2012 7:00 AM by Atul R

    Loading Customer Invoices

    Atul R
      Dear Experts,

      I am loading Customer Invoices through Interface i.e. RA_INTERFACE_LINES_ALL.

      I populated the data in this table and then ran the "Autoinvoice Master Program" but in this program i can not see my batch source, I have taken one of the define batch source in the system (MANUAL-MUM), also for this batch source we are generating automatic trx number, but in interface i manually written "trx number".

      Please advice me, how should i upload the customer invoices through interface.

      Thanks,
      Atul Ramteke
        • 1. Re: Loading Customer Invoices
          vinitp
          Atul

          Ensure that the batch source is of the type imported and not manual.

          Hope this helps
          Vinit
          • 2. Re: Loading Customer Invoices
            Exception
            Hi Atul,

            What's your EBS version?

            If it’s Release 12, then check the following MOS Document. It will be helpful to you for creating Customer invoices via Autoinvoice.
            *AutoInvoice Setup for Release 12: A Case Study Using a Simple Script [ID 1067402.1]*_


            Regards
            Muhammad Ayaz
            • 3. Re: Loading Customer Invoices
              Atul R
              Thanks Guys For Replying..

              EBS version is R12.1.3..

              @Vinit : In Autoinvoice Import Program there is one parameter Transaction Source, there i can not see Any imported Batch Source.

              Do we need to created a different batch source to achive this.

              Thanks,
              Atul
              • 4. Re: Loading Customer Invoices
                vinitp
                Atul

                You need to check it in the Batch Source Defintion. Navigate to Setup --> Transactions --> Sources. Query the transaction source which you want and check the whether the same is imported or manual. It should be imported.

                Vinit
                • 5. Re: Loading Customer Invoices
                  Atul R
                  HI Vinit,

                  You mean to say, I need to create a different batch source for all the open transaction and set type of that batch source to Manual.

                  i will try it and let you know...

                  Thanks,
                  Atul
                  • 6. Re: Loading Customer Invoices
                    vinitp
                    Atul

                    The batch source type should be "Imported"

                    Vinit
                    • 7. Re: Loading Customer Invoices
                      Atul R
                      Hi Vinit,

                      I have created a batch source with Imported type.

                      I ran the Autoinvoice Master Program from the front end, the Autoinvoice Master Program completed successfully but Autoinvoice Import program goes into error.

                      Here is the log file of the same.

                      ---------------------------------------------------------------------------
                      Receivables: Version : 12.0.0

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

                      RAXTRX module: Autoinvoice Import Program
                      ---------------------------------------------------------------------------

                      Current system time is 21-MAY-2012 19:17:12

                      ---------------------------------------------------------------------------

                      org parameter (raamai) = ~86~
                      raassc()+ Current system time is 21-MAY-2012 19:17:12
                      org parameter (raassc) character = ~86~
                      org parameter (raassc) numeric = ~86~
                      raassc()- Current system time is 21-MAY-2012 19:17:12
                      raagsp()+ Current system time is 21-MAY-2012 19:17:12
                      Autoinvoice max memory set below recommended value, defaulted to 1048576 bytes
                      raagsp()- Current system time is 21-MAY-2012 19:17:12
                      raaini()+ Current system time is 21-MAY-2012 19:17:12
                      raaapx()+ Current system time is 21-MAY-2012 19:17:12
                      raaapx()- Current system time is 21-MAY-2012 19:17:13
                      raagbo()+ Current system time is 21-MAY-2012 19:17:13
                      Dumping data fetched from RA_BATCH_SOURCES
                      batch_source_id = 8003
                      batch_source_name = AR OPEN INV FR LEGACY
                      auto_trx_numbering_flag = N
                      copy_doc_number_flag = N
                      cust_trx_type_rule = R
                      sold_customer_rule = R
                      bill_customer_rule = R
                      bill_address_rule = R
                      bill_contact_rule = R
                      ship_customer_rule = R
                      ship_address_rule = R
                      ship_contact_rule = R
                      memo_reason_rule = R
                      term_rule = R
                      invoicing_rule_rule = R
                      accounting_rule_rule = R
                      unit_of_measure_rule = R
                      agreement_rule = R
                      inventory_item_rule = R
                      fob_point_rule = S
                      ship_via_rule = S
                      invalid_lines_rule = R
                      salesperson_rule = R
                      sales_credit_type_rule = R
                      accounting_flexfield_rule = R
                      invalid_tax_rate_rule = R
                      rev_acc_allocation_rule = P
                      gl_date_period_rule = R
                      create_clearing_flag = N
                      derive_date_flag = Y
                      sales_credit_rule = P
                      sales_territory_rule = R
                      receipt_method_rule = R
                      customer_bank_account_rule = R
                      related_document_rule = R
                      memo_line_rule = R
                      allow_sales_credit_flag = Y
                      receipt_handling_option = N
                      allow_duplicate_trx_num_flag = N
                      raagbo()- Current system time is 21-MAY-2012 19:17:13
                      raaggi()+ Current system time is 21-MAY-2012 19:17:13
                      raagixpfx = 0
                      raagixtpf = 0
                      raagixddf = 1
                      raagixacf = 0
                      raagixagd = 0
                      raagixatn = 0
                      raagixadn = 0
                      raagixcte = 0
                      raagixdfd =
                      raagixctc = 0
                      raagixrmx = T
                      raagixfdx = 31-MAY-12
                      raagixbix =
                      raagixbsi = 8003
                      raagixbnx = AR OPEN INV FR LEGACY
                      raagixoix = 86
                      raagixrix = 1157897
                      raagixpix = 20428
                      raagixpai = 222
                      raagixuix = 1155
                      raagixunx = BSIL FINANCE
                      raagixanx = AR
                      raagixlul = 793482
                      raagixasc = 1
                      raagixrho = N
                      raagixrsf = 0
                      raagixcbf = 0
                      raagixuax = 1
                      raagixsnf = 1
                      raagixtao = 1
                      raagixptf = 1
                      raagixstf = 0
                      raagixrfi = 0
                      raagixtac = 1
                      raagixcai = 50348
                      raagixsbi = 2021
                      raagixcpr = 2
                      raagixmau =
                      raagixmlx = 3
                      raagixmbx = 1048576
                      raagixafp =
                      raagixifp =
                      raagixtfp =
                      Argbdf = 1
                      Argddo = -9999
                      raaggi()- Current system time is 21-MAY-2012 19:17:13
                      raaseb()+ Current system time is 21-MAY-2012 19:17:13
                      raaseb()- Current system time is 21-MAY-2012 19:17:13
                      arcdsu()+ Current system time is 21-MAY-2012 19:17:13
                      arcdsu() error level: 3 array size: 1048576 insert array size: 1048576
                      arcdsu() Use Invoice Accounting For Credit Memo: Y
                      arcerr()+ Current system time is 21-MAY-2012 19:17:13
                      arcsai() Not all AutoAccounting types are defined
                      Current system time is 21-MAY-2012 19:17:13
                      APP-AR-11526: Current system time is 21-MAY-2012 19:17:13

                      APP-AR-11526: 0
                      arcerr()- Current system time is 21-MAY-2012 19:17:13
                      arcsai() Not all AutoAccounting types are defined
                      Error calling arcdsu_do_setup()
                      Error calling raaini()
                      ---------------------------------------------------------------------------
                      Start of log messages from FND_FILE
                      ---------------------------------------------------------------------------
                      ---------------------------------------------------------------------------
                      End of log messages from FND_FILE
                      ---------------------------------------------------------------------------


                      ---------------------------------------------------------------------------
                      No completion options were requested.

                      Output file size:
                      0
                      Concurrent program returned no reason for failure.

                      ---------------------------------------------------------------------------
                      Exceptions posted by this request:
                      Concurrent Request for "Autoinvoice Import Program" has completed with error.

                      ---------------------------------------------------------------------------
                      Concurrent request completed
                      Current system time is 21-MAY-2012 19:17:15

                      ---------------------------------------------------------------------------

                      Kindly tell me where i m going wrong.


                      Thanks,
                      Atul
                      • 8. Re: Loading Customer Invoices
                        vinitp
                        Atul

                        The log file says "Not all AutoAccounting types are defined Error". Please check if you have defined all the autoaccounting rules for all the events. You need to define the set up for all types, irrespective of whether you are using it or not.

                        Vinit
                        • 9. Re: Loading Customer Invoices
                          Atul R
                          Thanks Vinit,

                          For Autoinvoice Account, is there any need of Distribution module, I ask my functional consultant to do the same. But he is telling that we dont have OM module here, so we can not do autoinvoicing.

                          Is it so??

                          Pls reply.

                          Thanks,
                          Atul
                          • 10. Re: Loading Customer Invoices
                            Exception
                            Hi Atul,


                            see *AutoInvoice Error: Not all AutoAccounting types are defined [ID 1344503.1]*_



                            Rgrds
                            Muhammad Ayaz
                            • 11. Re: Loading Customer Invoices
                              Atul R
                              Dear Vinit & Exception,

                              Thanks a lot for your kind support, i have defined all the autoaccounting setup now.

                              Both the Program ie. autoinvoice master program and autoinvoice import program running normal now.

                              But when i see the log file of the same, the rows are going into error because of the following error.



                              Auto Invoice Request Id 1158086
                              Batch Source: AR OPEN INV FR LEGACY

                              Transaction Flexfield: ORDER ENTRY: 0007/11-12

                              Type Bill to Customer Name Item Description Currency Amount
                              -------------------- ---------------------------------------- ---------------------------------------- ----------- -----------------
                              Invoice TATA MOTORS LIMITED AR OPEN DATA INR 500,000.00

                              Errors: 1) All enabled segments of Transaction Flexfield must have a value (0007/11-12.............)

                              as i search over internet for theabove error, it was like if you dont have OM module install you cant populate data in coulumn

                              INTERFACE_LINE_CONTEXT

                              INTERFACE_LINE_ATTRIBUTE1 -- 10

                              Please guide me.


                              Thanks,
                              Atul Ramteke
                              • 12. Re: Loading Customer Invoices
                                Exception
                                Atul,

                                Did you check the below MOS Document?

                                _AutoInvoice Setup for Release 12: A Case Study Using a Simple Script [ID 1067402.1]_*

                                It includes all the required setup steps of Autoinvoice. So I suggest you to please check the above Doc. and follow its steps.



                                > Errors: 1) All enabled segments of Transaction Flexfield must have a value (0007/11-12.............)


                                see *Troubleshooting Transaction Flexfields in AutoInvoice [ID 1077555.1]*_




                                Regards
                                Muhammad Ayaz
                                • 13. Re: Loading Customer Invoices
                                  Atul R
                                  Hi,

                                  I read the given notes and it is very useful.

                                  I dont have Order Management install over here. and in RA_INTERFACE_LINES_ALL table, INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE1.

                                  Should i disable this dff because we are not using this dff and and this dff is enabled in the setup.

                                  THanks
                                  Atul
                                  • 14. Re: Loading Customer Invoices
                                    Atul R
                                    Finally Transaction is Loaded successfully.

                                    Thanks a lot Muhammad Ayaz & Vinit for your wholehearted support.

                                    Atul
                                    1 2 Previous Next