Metro2 File Generation Issue (Doc ID 2976897.1)

Last updated on OCTOBER 01, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
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.

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

STEPS
-----------------------
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

METRO_II_PROGRAM_MODE_CD = PLSQL

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.

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

Cause

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