OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » CE

Home » Applications » Oracle Fusion Apps & E-Business Suite » CE_STATEMENT Loading (CE, R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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
);

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 04:03:59 CDT 2024