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
);
Previous Topic: Additional feilds from IGW patch: IGW.G for grants proposal is missing in the Create Proposal screen
Next Topic: data capture via COM1 in Oracle Form
Goto Forum:
  


Current Time: Tue Dec 06 06:33:07 CST 2016

Total time taken to generate the page: 0.05415 seconds