TRX_CODE_ID is getting populated with null value through Bank Statement Interface in Oracle Apps R12

While Importing Bank Statement Data through Bank Statement Interface from 11i data is imported successfully in R12 but when validated data TRX_CODE_ID column in CE_STATEMENT_LINES table is blank where as value is there in 11i Instance.

This is intended functionality in R12. On Release 12 the transaction code for bank statement lines is now stored and displayed from the TRX_CODE column of the CE_STATEMENT_LINES table. On prior releases the CE_STATEMENT_LINES table did not have a TRX_CODE column and the transaction code was stored in the TRX_CODE_ID.

To get the transaction code prior to R12 one has to join with CE Statement lines table with the CE_TRANSACTON_CODES table to get the description for the transaction code. The transaction code is displayed in the Bank Statement Lines window under the Transaction Code field using the TRX_CODE column of the CE_STATEMENT_LINES table.

The Bank Statement Loading and Import Programs load the TRX_CODE to the CE_STATEWMENT_LINES from Interface table from the Bank file. The TRX_CODE_ID is commented. The TRX_CODE_ID is used internally for processing the data in R12.