My Oracle Support Banner

Metro2 File Generation Issue (Doc ID 2976897.1)

Last updated on OCTOBER 01, 2023

Applies to:

Oracle Financial Services Lending and Leasing - Version and later
Information in this document applies to any platform.


Metro2 File Generation Issue

Metro2 file creation process fails in the batch job (CBUUTL_BJ_100_03).  

Issue 1.  In C version program. It allows only 80 chars of Company Join variable. Hence this fails.

Issue 2. In PLSQL program version system only allows 30 chars of Company Join variable. Hence this fails too.

Issue 3. In PLSQL. If we fix the PLSQL Issue#2, File generated doesn't match with C file generated.

  1. Header and Trailer Data field differs between C file creation and PLSQL file creation.
  2. C program deletes the empty files vs PLSQL doesn't
  3. C program end of line is LF vs PLSQL program CR LF
  4. PLSQL program generated multiple headers

Note: Currently customer in 14.5, customer using the C version of the metro2 file creation. Customer planning to upgrade, hence want to ensure the C program file output matches 100% to PLSQL version.

Metro2 File Generation should match exactly between the C and PLSQL version of program files.

The issue can be reproduced at will with the following steps:

1) Create 10 Portfolio company for generating the metro2 file with company code C-1000, C-1001, C-1004 etc. Put accounts in metro_ii_data table I.e... make sure you have accounts with Status Record = 'R'   System Parameter: METRO_II_PROGRAM_MODE_CD = C

2) Run the batch process Metro2 file creation process (CBUUTL_BJ_100_03)

3) Do the same setup


To Reset the Accounts for Metro2 file: update metro_ii_data set met_record_status_code = 'R' where met_id IN ( xxxxxx, xxxxxx ).

4) Run the batch process Metro2 file creation process (CBUUTL_BJ_100_03)

5) File generated between C program and PLSQL should be 100% match.

The issue has the following business impact:
Due to this issue, users cannot have the Metro2 File Generation accurate.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.