6 Replies Latest reply: Nov 28, 2013 1:46 PM by Hussein Sawwan-Oracle RSS

    Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT

    48af20f2-ce4a-4cbb-a7bd-919648bb3555

      Hi Guys,

       

      I wonder if you can help.... i am getting the following error when i running the auto invoice import program.... any ideas what this could be...

       

      Errors:

      1) AR_COMPLETE_INT_TAX_ACCOUNT (..)

      2) Please complete your tax accounting flexfield (..)

       

      I have looked at many Oracle notes but i cant seem to pin point this issue...

       

      any help would be great.

       

       

      regards

      Bal

        • 1. Re: Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT
          Asif Muhammad

          Hi Bal,

           

          Please provide the complete log file and also check for any errors in the db alert logfile and confirm there are no errors.

           

          Thanks &

          Best regards,

          • 2. Re: Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT
            Hussein Sawwan-Oracle

            If you are on 12.1.x, you may need to have (Patch 9337544: European Union Value Added Tax (EU VAT) requirements) applied.

             

            Please see following docs for details:

             

            11i/R12 AutoInvoice Exception: Please complete your tax accounting flexfield (Also occurs in Trx Workbench) (Doc ID 1087263.1)

            Autoinvoice Error: ORA-00001: Unique Constraint (Doc ID 1219263.1)

             

            Thanks,

            Hussein

            • 3. Re: Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT
              48af20f2-ce4a-4cbb-a7bd-919648bb3555

              Hi Asif,

               

              Please find log file below, i am not sure where to find the db alert logfile ?

               

              +---------------------------------------------------------------------------+

              Receivables: Version : 12.0.0

               

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

               

              RAXTRX module: Autoinvoice Import Program

              +---------------------------------------------------------------------------+

               

              Current system time is 23-NOV-2013 17:19:59

               

              +---------------------------------------------------------------------------+

               

              org parameter (raamai) = ~83~

              raassc()+ Current system time is 23-NOV-2013 17:19:59

              org parameter (raassc) character = ~83~

              org parameter (raassc) numeric = ~83~

              raassc()- Current system time is 23-NOV-2013 17:19:59

              raagsp()+ Current system time is 23-NOV-2013 17:19:59

              Autoinvoice max memory set below recommended value, defaulted to 1048576 bytes

              raagsp()- Current system time is 23-NOV-2013 17:19:59

              Dumping data fetched from RA_BATCH_SOURCES

              batch_source_id = 1021

              batch_source_name = HM Cons - OM

              auto_trx_numbering_flag = Y

              copy_doc_number_flag = N

              cust_trx_type_rule = I

              sold_customer_rule = I

              bill_customer_rule = I

              bill_address_rule = I

              bill_contact_rule = N

              ship_customer_rule = I

              ship_address_rule = I

              ship_contact_rule = N

              memo_reason_rule = I

              term_rule = I

              invoicing_rule_rule = I

              accounting_rule_rule = I

              unit_of_measure_rule = I

              agreement_rule = I

              inventory_item_rule = I

              fob_point_rule = N

              ship_via_rule = N

              invalid_lines_rule = R

              salesperson_rule = I

              sales_credit_type_rule = I

              accounting_flexfield_rule = I

              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 = I

              receipt_method_rule = I

              customer_bank_account_rule = I

              related_document_rule = N

              memo_line_rule = I

              allow_sales_credit_flag = Y

              receipt_handling_option = N

              allow_duplicate_trx_num_flag = N

              raagixpfx = 0

              raagixtpf = 0

              raagixddf = 1

              raagixacf = 0

              raagixagd = 0

              raagixatn = 1

              raagixadn = 0

              raagixcte = 0

              raagixdfd =

              raagixctc = 0

              raagixrmx = T

              raagixfdx = 23-NOV-13

              raagixbix =

              raagixbsi = 1021

              raagixbnx = HM Cons - OM

              raagixoix = 83

              raagixrix = 838021

              raagixpix = 20428

              raagixpai = 222

              raagixuix = 1110

              raagixunx = HANDSONERP

              raagixanx = AR

              raagixlul = 494814

              raagixasc = 1

              raagixrho = N

              raagixrsf = 1

              raagixcbf = 0

              raagixuax = 1

              raagixsnf = 0

              raagixtao = 1

              raagixptf = 1

              raagixstf = 0

              raagixrfi = 0

              raagixtac = 0

              raagixcai = 50328

              raagixsbi = 2021

              raagixcpr = 2

              raagixmau =

              raagixmlx = 0

              raagixmbx = 1048576

              raagixafp =

              raagixifp =

              raagixtfp =

              Argbdf = 1

              Argddo = -9999

              crb->raaucrpn = RAXTRX

              crb->raaucrcr = 838021

              crb->raaucrnt = 0

              crb->raaucrml = 0

               

              Validating : Current system time is 23-NOV-2013 17:19:59

              raapem:  no errors recorded

              raapem:  no errors recorded

              raapem:  no errors recorded

              raapem:  no errors recorded

              raavgi()+ Current system time is 23-NOV-2013 17:20:00

              raavgi()- Current system time is 23-NOV-2013 17:20:00

              raapem:  no errors recorded

              raapem:  no errors recorded

              raapem:  no errors recorded

              Dumping the contents of struct raagtx ...

              raagtxnr = 1

              0    gtb->raagtxti = 1

              0    gtb->raagtxtc = 5

               

              Grouping : Current system time is 23-NOV-2013 17:20:01

              no_of_rows = 0

              raapem:  no errors recorded

               

              Transferring : Current system time is 23-NOV-2013 17:20:03

              raapem:  no errors recorded

              raapem:  no errors recorded

              AR_TAPI_ECB_BILLING_DATE_REQD

              Gen_line_lvl_bal_flag = N

              Second Commit after successful transfer -  Current system time is 23-NOV-2013 17:20:04

               

              Reporting : Current system time is 23-NOV-2013 17:20:04

               

              Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

              American_America.US7ASCII

               

              '.,'

               

              Enter Password:

              REP-0004: Warning: Unable to open user preference file.

               

              Report Builder: Release 10.1.2.3.0 - Production on Sat Nov 23 17:20:06 2013

               

              Copyright (c) 1982, 2005, Oracle.  All rights reserved.

               

               

              +---------------------------------------------------------------------------+

              Start of log messages from FND_FILE

              +---------------------------------------------------------------------------+

              rows inserted through zx_errors_gt 0

              +---------------------------------------------------------------------------+

              End of log messages from FND_FILE

              +---------------------------------------------------------------------------+

               

              Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

              American_America.US7ASCII

               

              '.,'

               

              Enter Password:

              REP-0004: Warning: Unable to open user preference file.

              MSG-00000: Start of debug

              MSG-00000: retrieved org_id 83

              MSG-00000: Start of before report trigger

              MSG-00000: After report trigger

               

              Report Builder: Release 10.1.2.3.0 - Production on Sat Nov 23 17:20:10 2013

               

              Copyright (c) 1982, 2005, Oracle.  All rights reserved.

               

               

              +---------------------------------------------------------------------------+

              Start of log messages from FND_FILE

              +---------------------------------------------------------------------------+

              +---------------------------------------------------------------------------+

              End of log messages from FND_FILE

              +---------------------------------------------------------------------------+

              +---------------------------------------------------------------------------+

              Start of log messages from FND_FILE

              +---------------------------------------------------------------------------+

              +---------------------------------------------------------------------------+

              End of log messages from FND_FILE

              +---------------------------------------------------------------------------+

               

               

              +---------------------------------------------------------------------------+

              No completion options were requested.

               

              +---------------------------------------------------------------------------+

              Concurrent request completed successfully

              Current system time is 23-NOV-2013 17:20:12

               

              +---------------------------------------------------------------------------+

              • 4. Re: Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT
                Hussein Sawwan-Oracle

                Did you review the MOS docs referenced in my previous reply?

                 

                Please find log file below, i am not sure where to find the db alert logfile ?

                 

                http://docs.oracle.com/cd/E24693_01/server.11203/e17120/diag005.htm

                 

                SQL> select value
                from V$DIAG_INFO
                where name = 'Diag Trace';
                

                 

                Look for alert_<SID>.log under the directory.

                 

                Thanks,

                Hussein

                • 5. Re: Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT
                  48af20f2-ce4a-4cbb-a7bd-919648bb3555

                  Hi Hassan, Asif,

                   

                  Fixed the issue the oracle error message (Please complete your tax accounting flexfield) was quite misleading. There was no Tax Account defined in the AR transaction type. Soon as i populated this value the Auto invoice import program imported the Sales Orders from OM to AR without any errors.

                   

                  Thanks for your help and assistance.

                   

                   

                  Kind regards

                  Bal

                  • 6. Re: Autoinvoice Import Program - Error AR_COMPLETE_INT_TAX_ACCOUNT
                    Hussein Sawwan-Oracle

                    Thanks for the update and for sharing the solution.

                     

                    Thanks,

                    Hussein