Home » Applications » Oracle Fusion Apps & E-Business Suite » CE_STATEMENT Loading (CE, R12)
CE_STATEMENT Loading [message #387706] |
Fri, 20 February 2009 06:05 |
jaganerp@gmail.com
Messages: 63 Registered: April 2008
|
Member |
|
|
Hai Everybody
I am loading the Bank statement data into the interface tables CE_STATEMENT_HEADERS_INT ,CE_STATEMENT_LINES_INTERFACE ,after loading data into the interface table i can view the data in frentend screen.But after submitting the concurrent program (Bank Statement Import) concurrent program runig sucess fully , data deleted form interface tables, but it not storinging the base tables CE_STATEMENT_HEADERS,CE_STATEMENT_LINES,i cont ab-ul to find-out where i did mistake , me very new in this module
my pl/sql script
______________
INSERT INTO ce_statement_headers_int(statement_number,
bank_account_num,
statement_date,
bank_name,
bank_branch_name,
record_status_flag,
currency_code,
org_id,
created_by,
creation_date,
last_updated_by,
last_update_date
)
VALUES
('04-APR-06'
,'10271-17621-619'
,'12-JAN-2006'
,'Bank of America'
,'New York'
,'N'
,'USD'
,204
,Fnd_Profile.VALUE('USER_ID')
,sysdate
,Fnd_Profile.VALUE('USER_ID')
,sysdate
) ;
INSERT INTO ce_statement_lines_interface(statement_number,
bank_account_num,
line_number,
trx_date,
trx_code,
-- bank_trx_number,
amount,
created_by,
creation_date,
last_updated_by,
last_update_date)
VALUES
('04-APR-06'
,'12345'
,1
,sysdate
,'10010'
,100000
,Fnd_Profile.VALUE('USER_ID')
,sysdate
,Fnd_Profile.VALUE('USER_ID')
,sysdate
);
|
|
|
Goto Forum:
Current Time: Sat Sep 07 06:56:29 CDT 2024
|