E1: 45: Supplier Catalog Mass Update (R41061M) Ignores Flat File and Reports All Records (Doc ID 2796378.1)

Last updated on DECEMBER 15, 2023

Applies to:

Symptoms

When running Supplier Catalog Mass Update (R41061M) to import new supplier catalog records from a .csv file, the program does not insert any new records from the .csv file. Instead it prints a report of all the existing records in the Supplier Price/Catalog File (F41061).

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

1. Go into Work with Batch Versions, Find batch Application R41061M, select the test version and Row Exit to Processing Options
   1. Update tab Option #1 (Mode) is set to 1 (Final Mode)
   2. Adjustments Tab Options are all set to Blank.
   3. Flat File pathname is populated
2. Verify the file exists in the correct location
3. Review the lines in the file. These are records that are not currently in the Supplier Catalog (P41061) which they intend to add.
4. Pick one record to look for in the Supplier Catalog.
5. Enter the information in Work with Supplier Catalogs (P41061) and click Find. The record is not found because it does not exist in the file yet.
6. Run the Job. After several minutes the Job is done.
7. The report PDF looks normal but is 1,730 pages long. It appears that the report prints out all the previously saved records and that none of the new records added that were in the .csv file.
8. Scroll to the end of the report. There are no error messages.
9. Check Work Center. No messages there either.

Changes

Cause

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