R12/CE: 11i BS_CE_NUM_DOCUMENTO_PKG To Populate Bank Transaction Number By "Bank Statement Import" Obseleted in R12
Last updated on JUNE 06, 2017
Applies to:Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.
Q1: In 11i, User never used Format option for BANK_TRX_NUMBER setup in Bank statement Mapping, in R12 this does not work?
Q2: Bank Statement Import program uses BS_CE_NUM_DOCUMENTO_PKG to populate CE_STATEMENT_LINES.BANK_TRX_NUMBER.
BS_CE_NUM_DOCUMENTO_PKG.num_documento API finds match from ce_200_transactions_v and ce_200_batches_v against the statement line record.
On successful match, it updates bank_trx_number in ce_statement_lines table.
Q3: In R12, bank_trx_number not populated as it used to be in 11i by Bank Statement Import program.
Also User do not see any code for BS_CE_NUM_DOCUMENTO_PKG.num_documento API. Suspect, this feature has been removed in R12.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms