1 Reply Latest reply: Jun 5, 2013 1:37 AM by user5345 RSS

    Migration Issue (Legacy to Oracle 12.1.3)

    user5345
      Dear All,
      I am trying to migrate Invoice details from legacy to oracle apps 12.1.3 version.
      I am trying to insert into ra_interface_lines_all, this is the code used.

      INSERT INTO ra_interface_lines_all
      (interface_line_context, interface_line_attribute1, interface_line_id,
      amount, batch_source_name, conversion_rate,
      conversion_type, currency_code, cust_trx_type_id,
      description, gl_date, line_type,
      orig_system_bill_address_id, orig_system_bill_customer_id,
      quantity, unit_selling_price,
      term_id,
      set_of_books_id, org_id)
      VALUES
      ('Migration', 'REV-0001', ra_customer_trx_lines_s.nextval,
      1000, 'GMU_STUDENT_BS', 1,
      'User', 'AED', 1,
      'Tusiotion Fee', '04-JUN-2013', 'LINE',
      1201, 8040,
      10, 100.00,
      5, 2022, 163);

      Below is the error:

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

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

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

      Current system time is 05-JUN-2013 10:36:12

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

      org parameter (raamai) = ~163~
      raassc()+ Current system time is 05-JUN-2013 10:36:12
      org parameter (raassc) character = ~163~
      org parameter (raassc) numeric = ~163~
      raassc()- Current system time is 05-JUN-2013 10:36:12
      raagsp()+ Current system time is 05-JUN-2013 10:36:12
      Autoinvoice max memory set below recommended value, defaulted to 1048576 bytes
      Error calling afpoget() - AR_ALLOW_TRX_LINE_EXEMPTIONS
      raagsp()- Current system time is 05-JUN-2013 10:36:12
      raaini()+ Current system time is 05-JUN-2013 10:36:12
      raaapx()+ Current system time is 05-JUN-2013 10:36:12
      raaapx()- Current system time is 05-JUN-2013 10:36:12
      raagbo()+ Current system time is 05-JUN-2013 10:36:12
      Dumping data fetched from RA_BATCH_SOURCES
      batch_source_id = 2001
      batch_source_name = GMU_STUDENT_BS
      auto_trx_numbering_flag = Y
      copy_doc_number_flag = Y
      cust_trx_type_rule = I
      sold_customer_rule = I
      bill_customer_rule = I
      bill_address_rule = I
      bill_contact_rule = N
      ship_customer_rule = N
      ship_address_rule = N
      ship_contact_rule = N
      memo_reason_rule = R
      term_rule = I
      invoicing_rule_rule = I
      accounting_rule_rule = I
      unit_of_measure_rule = R
      agreement_rule = N
      inventory_item_rule = N
      fob_point_rule = N
      ship_via_rule = N
      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 = A
      gl_date_period_rule = R
      create_clearing_flag = N
      derive_date_flag = Y
      sales_credit_rule = A
      sales_territory_rule = N
      receipt_method_rule = I
      customer_bank_account_rule = R
      related_document_rule = N
      memo_line_rule = R
      allow_sales_credit_flag = N
      receipt_handling_option = N
      allow_duplicate_trx_num_flag = N
      raagbo()- Current system time is 05-JUN-2013 10:36:12
      raaggi()+ Current system time is 05-JUN-2013 10:36:12
      raagixpfx = 0
      raagixtpf = 0
      raagixddf = 1
      raagixacf = 0
      raagixagd = 0
      raagixatn = 1
      raagixadn = 0
      raagixcte = 0
      raagixdfd =
      raagixctc = 0
      raagixrmx = T
      raagixfdx = 05-JUN-13
      raagixbix =
      raagixbsi = 2001
      raagixbnx = GMU_STUDENT_BS
      raagixoix = 163
      raagixrix = 474258
      raagixpix = 20428
      raagixpai = 222
      raagixuix = 1390
      raagixunx = SIVA
      raagixanx = AR
      raagixlul = 137684
      raagixasc = 0
      raagixrho = N
      raagixrsf = 0
      raagixcbf = 0
      raagixuax = 1
      raagixsnf = 1
      raagixtao = 0
      raagixptf = 0
      raagixstf = 0
      raagixrfi = 0
      raagixtac = 1
      raagixcai = 50328
      raagixsbi = 2022
      raagixcpr = 2
      raagixmau =
      raagixmlx = 3
      raagixmbx = 1048576
      raagixafp = ACC
      raagixifp =
      raagixtfp =
      Argbdf = 1
      Argddo = -9999
      raaggi()- Current system time is 05-JUN-2013 10:36:12
      raaseb()+ Current system time is 05-JUN-2013 10:36:12
      raaseb()- Current system time is 05-JUN-2013 10:36:12
      arcdsu()+ Current system time is 05-JUN-2013 10:36:12
      arcdsu() error level: 3 array size: 1048576 insert array size: 1048576
      arcdsu() Use Invoice Accounting For Credit Memo: Y
      arcerr()+ Current system time is 05-JUN-2013 10:36:12
      arcsai() Not all AutoAccounting types are defined
      Current system time is 05-JUN-2013 10:36:12
      APP-AR-11526: Cannot read value for profile option ZX_ALLOW_TRX_LINE_EXEMPTIONS in routine &ROUTINE.

      APP-AR-11526: 0
      arcerr()- Current system time is 05-JUN-2013 10:36:12
      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.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 05-JUN-2013 10:36:12

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

      Please let me know any setup is missing.

      thnxs