R12/CE: 11i BS_CE_NUM_DOCUMENTO_PKG To Populate Bank Transaction Number By "Bank Statement Import" Obseleted in R12 (Doc ID 2274075.1)

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.

Goal

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.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms