top of page

Tags

Archive

Bank Statement Import and rejected Query - Oracle ERP Cloud

Imported Query :

select hp.party_name "Bank Name",

cba.bank_account_name,

cba.bank_account_num,

csh.statement_number,

csl.trx_type,

csl.flow_indicator,

csl.amount


from ce_statement_headers csh,

ce_statement_lines csl,

ce_bank_accounts cba,

hz_parties hp

where csl.statement_header_id = csh.statement_header_id

and cba.bank_account_id = csh.bank_account_id

and hp.party_id = cba.bank_id

and hp.party_name = :pBankName

and (TRUNC(csh.creation_date) = TRUNC(sysdate)

or csh.statement_number = :statement_number)



Error Query:


select hp.party_name,

cba.bank_account_name,

cshi.bank_account_num,

cshi.statement_number,

cshi.statement_date,

csie.error_msg,

csie.creation_date

from ce_statement_headers_int cshi,

ce_stmt_import_errors csie,

ce_bank_accounts cba,

hz_parties hp

where csie.statement_header_int_id = cshi.statement_header_int_id

and cba.bank_account_num = cshi.bank_account_num

and hp.party_id = cba.bank_id

and hp.party_name = :pBankName

and TRUNC(csie.creation_date) = TRUNC(SYSDATE)


Hope this Helps!

585 views0 comments

Recent Posts

See All

Business units Query-Oracle Fusion

The below Query will be handy while fetching Business unit name in r13 instance. SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS, FUBU.MODULE_NAME, FUBU.CONFIGURATION_STATUS, TO_CHAR(HOU.DATE_FROM,

Supplier and Site Query Oracle ERP Cloud

SELECT psv.vendor_name supplier_name, psv.vendor_id supplier_id, psv.segment1 supplier_number, psv.enabled_flag, psv.vendor_type_lookup_code, psv.one_time_flag, psv.start_date_active, psv.end_date_act

Other Posts you may Interested