This discussion is archived
1 Reply Latest reply: Jun 4, 2013 11:37 PM by user5345 RSS

Migration Issue (Legacy to Oracle 12.1.3)

user5345 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points