Import de données depuis GL_interface
Bonjour, j'essaye d'importer des donnée dans la comptabilité depuis une sources extérieur, je remplie donc la tableGL_interface avec un insert/commit mais dans le menu: Journals->Import->run l'import ne se passe pas correctement et Oracle me précise que la table GL_interface est vide! Est-ce que quelqu'un peu m'aider?
---->Données envoyées dans GL_interface:
insert into gl_interface (status,set_of_books_id,accounting_date, currency_code,date_created,
created_by, actual_flag, user_je_category_name, user_je_source_name, segment1,segment2,segment3,
entered_dr, entered_cr,transaction_date,reference1 )
values ('NEW', '1609', sysdate, 'FRF', sysdate,1008009, 'A', 'xx jab payroll', 'xx jab payroll', '01','002','4004',111.11,0,
sysdate,'xx_finance_jab_demo');
insert into gl_interface (status,set_of_books_id,accounting_date, currency_code,date_created,
created_by, actual_flag, user_je_category_name, user_je_source_name, segment1,segment2,segment3,
entered_dr, entered_cr,transaction_date,reference1 )
values ('NEW', '1609', sysdate, 'FRF', sysdate,1008009, 'A', 'xx jab payroll', 'xx jab payroll', '01','002','1005',0,111.11,
sysdate,'xx_finance_jab_demo');
---->Oracle me répond cela apres une tentative d'import des données
General Ledger: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLLEZL module: Journal Import
Running in Debug Mode
>> gllsob() 14-MAR-2007 15:39:25
sob_id = 124
sob_name = Vision France
coa_id = 50569
num_segments = 6
delim = '.'
segments =
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
index segment is SEGMENT2
balancing segment is SEGMENT1
currency = EUR
sus_flag = Y
ic_flag = Y
latest_opened_encumbrance_year = 2006
pd_type = Month
<< gllsob() 14-MAR-2007 15:39:25
>> gllsys() 14-MAR-2007 15:39:25
fnd_user_id = 1008009
fnd_user_name = JAB-DEVELOPPEUR
fnd_login_id = 2675718
con_request_id = 2918896
sus_on = 0
from_date =
to_date =
create_summary = 0
archive = 0
num_rec = 1000
num_flex = 2500
run_id = 55578
<< gllsys() 14-MAR-2007 15:39:25
SHRD0108: Retrieved 51 records from fnd_currencies
>> gllcsa() 14-MAR-2007 15:39:25
<< gllcsa() 14-MAR-2007 15:39:25
>> gllcnt() 14-MAR-2007 15:39:25
SHRD0118: Updated 1 record(s) in table: gl_interface_control
source name = xx jab payroll
group id = -1
LEZL0001: Found 1 sources to process.
>> glluch() 14-MAR-2007 15:39:25
<< glluch() 14-MAR-2007 15:39:25
>> gl_import_hook_pkg.pre_module_hook() 14-MAR-2007 15:39:26
<< gl_import_hook_pkg.pre_module_hook() 14-MAR-2007 15:39:26
>> glusbe() 14-MAR-2007 15:39:26
<< glusbe() 14-MAR-2007 15:39:26
<< gllcnt() 14-MAR-2007 15:39:26
>> gllpst() 14-MAR-2007 15:39:26
SHRD0108: Retrieved 110 records from gl_period_statuses
<< gllpst() 14-MAR-2007 15:39:27
>> glldat() 14-MAR-2007 15:39:27
Successfully built decode fragment for period_name and period_year
>> gllbud() 14-MAR-2007 15:39:27
SHRD0108: Retrieved 10 records from the budget tables
<< gllbud() 14-MAR-2007 15:39:27
>> gllenc() 14-MAR-2007 15:39:27
SHRD0108: Retrieved 15 records from gl_encumbrance_types
<< gllenc() 14-MAR-2007 15:39:27
>> glldlc() 14-MAR-2007 15:39:27
<< glldlc() 14-MAR-2007 15:39:27
>> gllcvr() 14-MAR-2007 15:39:27
SHRD0108: Retrieved 6 records from gl_daily_conversion_types
<< gllcvr() 14-MAR-2007 15:39:27
>> gllfss() 14-MAR-2007 15:39:27
LEZL0005: Successfully finished building dynamic SQL statement.
<< gllfss() 14-MAR-2007 15:39:27
>> gllcje() 14-MAR-2007 15:39:27
main_stmt:
select int.rowid
,
decode(int.SEGMENT1|| int.SEGMENT2|| int.SEGMENT3|| int.SEGMENT4|| int.SEGMENT5|| int.SEGMENT6
, '', replace(ccid_cc.SEGMENT2,'.','
') || '.' || replace(ccid_cc.SEGMENT1,'.','
') || '.' || replace(ccid_cc.SEGMENT3,'.','
') || '.' || replace(ccid_cc.SEGMENT4,'.','
') || '.' || replace(ccid_cc.SEGMENT5,'.','
') || '.' || replace(ccid_cc.SEGMENT6,'.','
')
, replace(int.SEGMENT2,'.','
') || '.' || replace(int.SEGMENT1,'.','
') || '.' || replace(int.SEGMENT3,'.','
') || '.' || replace(int.SEGMENT4,'.','
') || '.' || replace(int.SEGMENT5,'.','
') || '.' || replace(int.SEGMENT6,'.','
') ) flexfield , nvl(flex_cc.code_combination_id,
nvl(int.code_combination_id, -4))
, decode(int.SEGMENT1|| int.SEGMENT2|| int.SEGMENT3|| int.SEGMENT4|| int.SEGMENT5|| int.SEGMENT6
, '', decode(ccid_cc.code_combination_id,
null, decode(int.code_combination_id, null, -4, -5),
decode(sign(nvl(ccid_cc.start_date_active, int.accounting_date-1)
- int.accounting_date),
1, -1,
decode(sign(nvl(ccid_cc.end_date_active, int.accounting_date +1)
- int.accounting_date),
-1, -1, 0)) +
decode(ccid_cc.enabled_flag,
'N', -10, 0) +
decode(ccid_cc.summary_flag, 'Y', -100,
decode(int.actual_flag,
'B', decode(ccid_cc.detail_budgeting_allowed_flag,
'N', -100, 0),
decode(ccid_cc.detail_posting_allowed_flag,
'N', -100, 0)))),
decode(flex_cc.code_combination_id,
null, -4,
decode(sign(nvl(flex_cc.start_date_active, int.accounting_date-1)
- int.accounting_date),
1, -1,
decode(sign(nvl(flex_cc.end_date_active, int.accounting_date +1)
- int.accounting_date),
-1, -1, 0)) +
decode(flex_cc.enabled_flag,
'N', -10, 0) +
decode(flex_cc.summary_flag, 'Y', -100,
decode(int.actual_flag,
'B', decode(flex_cc.detail_budgeting_allowed_flag,
'N', -100, 0),
decode(flex_cc.detail_posting_allowed_flag,
'N', -100, 0)))))
, int.user_je_category_name
, int.user_je_category_name
, 'UNKNOWN' period_name
, decode(actual_flag, 'B'
, decode(period_name, NULL, '-1' ,period_name), nvl(period_name, '0')) period_name2
, currency_code
, decode(actual_flag
, 'A', actual_flag
, 'B', decode(budget_version_id
, 1210, actual_flag
, 1211, actual_flag
, 1212, actual_flag
, 1331, actual_flag
, 1657, actual_flag
, 1658, actual_flag
, NULL, '1', '6')
, 'E', decode(encumbrance_type_id
, 1000, actual_flag
, 1001, actual_flag
, 1022, actual_flag
, 1023, actual_flag
, 1024, actual_flag
, 1048, actual_flag
, 1049, actual_flag
, 1050, actual_flag
, 1025, actual_flag
, 999, actual_flag
, 1045, actual_flag
, 1046, actual_flag
, 1047, actual_flag
, 1068, actual_flag
, 1088, actual_flag
, NULL, '3', '4'), '5') actual_flag
, '0' exception_rate
, decode(currency_code
, 'EUR', 1
, 'STAT', 1
, decode(actual_flag, 'E', -8, 'B', 1
, decode(user_currency_conversion_type
, 'User', decode(currency_conversion_rate, NULL, -1, currency_conversion_rate)
,'Corporate',decode(currency_conversion_date,NULL,-2,-6)
,'Spot',decode(currency_conversion_date,NULL,-2,-6)
,'Reporting',decode(currency_conversion_date,NULL,-2,-6)
,'HRUK',decode(currency_conversion_date,NULL,-2,-6)
,'DALY',decode(currency_conversion_date,NULL,-2,-6)
,'HLI',decode(currency_conversion_date,NULL,-2,-6)
, NULL, decode(currency_conversion_rate,NULL,
decode(decode(nvl(to_char(entered_dr),'X'),'X',1,2),decode(nvl(to_char(accounted_dr),'X'),'X',1,2),
decode(decode(nvl(to_char(entered_cr),'X'),'X',1,2),decode(nvl(to_char(accounted_cr),'X'),'X',1,2),-20,-3),-3),-9),-9))) currency_conversion_rate
, to_number(to_char(nvl(int.currency_conversion_date, int.accounting_date), 'J'))
, decode(int.actual_flag
, 'A', decode(int.currency_code
, 'EUR', 'User'
, 'STAT', 'User'
, nvl(int.user_currency_conversion_type, 'User'))
, 'B', 'User', 'E', 'User'
, nvl(int.user_currency_conversion_type, 'User')) user_currency_conversion_type
, ltrim(rtrim(substrb(rtrim(substrb(int.reference1, 1, 50)) || ' ' || int.user_je_source_name || ' 2918896: ' || int.actual_flag || ' ' || int.group_id, 1, 100)))
, rtrim(substrb(nvl(rtrim(int.reference2), 'Journal Import ' || int.user_je_source_name || ' 2918896:'), 1, 240))
, ltrim(rtrim(substrb(rtrim(rtrim(substrb(int.reference4, 1, 25)) || ' ' || int.user_je_category_name || ' ' || int.currency_code || decode(int.actual_flag, 'E', ' ' || int.encumbrance_type_id, 'B', ' ' || int.budget_version_id, '') || ' ' || int.user_currency_conversion_type || ' ' || decode(int.user_currency_conversion_type, NULL, '', 'User', to_char(int.currency_conversion_rate), to_char(int.currency_conversion_date))) || ' ' || substrb(int.reference8, 1, 15) || int.originating_bal_seg_value, 1, 100)))
, rtrim(nvl(rtrim(int.reference5), 'Journal Import 2918896:'))
, rtrim(substrb(nvl(rtrim(int.reference6), 'Journal Import Created'), 1, 80))
, rtrim(decode(upper(substrb(nvl(rtrim(int.reference7), 'N'), 1, 1)),'Y','Y', 'N'))
, decode(upper(substrb(int.reference7, 1, 1)), 'Y', decode(rtrim(reference8), NULL, '-1', rtrim(substrb(reference8, 1, 15))), NULL)
, rtrim(upper(substrb(int.reference9, 1, 1)))
, rtrim(nvl(rtrim(int.reference10), nvl(to_char(int.subledger_doc_sequence_value), 'Journal Import Created')))
, int.entered_dr
, int.entered_cr
, to_number(to_char(int.accounting_date,'J'))
, to_char(int.accounting_date, 'YYYY/MM/DD')
, int.user_je_source_name
, nvl(int.encumbrance_type_id, -1)
, nvl(int.budget_version_id, -1)
, NULL
, int.stat_amount
, decode(int.actual_flag
, 'E', decode(int.currency_code, 'STAT', '1', '0'), '0')
, decode(int.actual_flag
, 'A', decode(int.budget_version_id
, NULL, decode(int.encumbrance_type_id, NULL, '0', '1')
, decode(int.encumbrance_type_id, NULL, '2', '3'))
, 'B', decode(int.encumbrance_type_id
, NULL, '0', '4')
, 'E', decode(int.budget_version_id
, NULL, '0', '5'), '0')
, int.accounted_dr
, int.accounted_cr
, nvl(int.group_id, -1)
, nvl(int.average_journal_flag, 'N')
, int.originating_bal_seg_value
from GL_INTERFACE int,
gl_code_combinations flex_cc,
gl_code_combinations ccid_cc
where int.set_of_books_id = 124
and int.status != 'PROCESSED'
and (int.user_je_source_name,nvl(int.group_id,-1)) in (('xx jab payroll', -1))
and flex_cc.SEGMENT1(+) = int.SEGMENT1
and flex_cc.SEGMENT2(+) = int.SEGMENT2
and flex_cc.SEGMENT3(+) = int.SEGMENT3
and flex_cc.SEGMENT4(+) = int.SEGMENT4
and flex_cc.SEGMENT5(+) = int.SEGMENT5
and flex_cc.SEGMENT6(+) = int.SEGMENT6
and flex_cc.chart_of_accounts_id(+) = 50569
and flex_cc.template_id(+) is NULL
and ccid_cc.code_combination_id(+) = int.code_combination_id
and ccid_cc.chart_of_accounts_id(+) = 50569
and ccid_cc.template_id(+) is NULL
order by decode(int.SEGMENT1|| int.SEGMENT2|| int.SEGMENT3|| int.SEGMENT4|| int.SEGMENT5|| int.SEGMENT6
, ''
, rpad(ccid_cc.SEGMENT2,30) || '.' || rpad(ccid_cc.SEGMENT1,30) || '.' || rpad(ccid_cc.SEGMENT3,30) || '.' || rpad(ccid_cc.SEGMENT4,30) || '.' || rpad(ccid_cc.SEGMENT5,30) || '.' || rpad(ccid_cc.SEGMENT6,30)
, rpad(int.SEGMENT2,30) || '.' || rpad(int.SEGMENT1,30) || '.' || rpad(int.SEGMENT3,30) || '.' || rpad(int.SEGMENT4,30) || '.' || rpad(int.SEGMENT5,30) || '.' || rpad(int.SEGMENT6,30)
) , int.entered_dr, int.accounted_dr, int.entered_cr, int.accounted_cr, int.accounting_date
control->len_mainsql = 16402
length of main_stmt = 7428
upd_stmt.arr:
update GL_INTERFACE
set status = :status
, status_description = :description
, je_batch_id = :batch_id
, je_header_id = :header_id
, je_line_num = :line_num
, code_combination_id = decode(:ccid, '-1', code_combination_id, :ccid)
, accounted_dr = :acc_dr
, accounted_cr = :acc_cr
, descr_flex_error_message = :descr_description
, request_id = to_number(:req_id)
where rowid = :row_id
upd_stmt.len: 394
ins_stmt.arr:
insert into gl_je_lines
( je_header_id, je_line_num, last_update_date, creation_date, last_updated_by, created_by , set_of_books_id, code_combination_id ,period_name, effective_date , status , entered_dr , entered_cr , accounted_dr , accounted_cr , reference_1 , reference_2
, reference_3 , reference_4 , reference_5 , reference_6 , reference_7 , reference_8 , reference_9 , reference_10 , description
, stat_amount , attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 ,attribute7 , attribute8
, attribute9 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14, attribute15, attribute16, attribute17
, attribute18 , attribute19 , attribute20 , context , context2 , context3 , invoice_amount , invoice_date , invoice_identifier
, tax_code , no1 , ussgl_transaction_code , gl_sl_link_id , gl_sl_link_table , subledger_doc_sequence_id , subledger_doc_sequence_value
, jgzz_recon_ref , ignore_rate_flag)
SELECT
:je_header_id , :je_line_num , sysdate , sysdate , 1008009 , 1008009 , 124 , :ccid , :period_name
, decode(substr(:account_date, 1, 1), '-', trunc(sysdate), to_date(:account_date, 'YYYY/MM/DD'))
, 'U' , :entered_dr , :entered_cr , :accounted_dr , :accounted_cr
, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29
, reference30, :description, :stat_amt, '' , '', '', '', '', '', '', '', '' , '', '', '', '', '', '', '', '', '', '', ''
, '', '', '', '', '', '', '', '', '', gl_sl_link_id
, gl_sl_link_table
, subledger_doc_sequence_id
, subledger_doc_sequence_value
, jgzz_recon_ref
, null
FROM GL_INTERFACE
where rowid = :row_id
ins_stmt.len: 1818
>> glluch() 14-MAR-2007 15:39:27
<< glluch() 14-MAR-2007 15:39:27
LEZL0008: Found no interface records to process.
LEZL0009: Check SET_OF_BOOKS_ID, GROUP_ID, and USER_JE_SOURCE_NAME of interface records.
If no GROUP_ID is specified, then only data with no GROUP_ID will be retrieved. Note that most data
from the Oracle subledgers has a GROUP_ID, and will not be retrieved if no GROUP_ID is specified.
SHRD0119: Deleted 1 record(s) from gl_interface_control.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
No data was found in the GL_INTERFACE table.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 14-MAR-2007 15:39:27
+---------------------------------------------------------------------------+
Répondre avec citation
Partager