E1: 43: Supplier Catalog (P41061) Does Not Populate Short Item Number in Supplier Price/Catalog File (F41061) (Doc ID 2860309.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Symptoms

When using Supplier Catalog Maintenance (P41061) to create a new non-stock item that does not currently exist in the Item Master (F4101) the Short Item Number is not populated in the Supplier Price/Catalog File (F41061). This causes a problem during PO Entry (P4310) because the Item Cost cannot be retrieved from the Supplier Price/Catalog File (F41061).

The client reproduced the issue with the following steps:

1. Setup processing options for Supplier Catalog Maintenance (P41061)
   1. Item Master Creation Processing = 1 (allow the creation of an Item Master Record but issue a warning)
   2. Stocking Type = N (Non-stock)
   3. Line Type = B (Item Number & Account Number Required)
   4. G/L Class = NS40
2. Select any supplier and catalog already entered.
3. Select the row to display Supplier Catalog Revisions.
   1. Go to the last line and enter an item number that is not already in the item master.
   2. Note the warning message is displaying correctly on the form.
   3. Save the change accepting the warning message.
4. This will return to the Work with Supplier Catalog form.
5. Filter again for your supplier and catalog.
6. Note that the item exists in the catalog with the 2nd and 3rd item number populated but the short item number is not populated on the Supplier Catalog Screen.
7. Check Item Master (P4101).
   1. The Short Item Number is populated on the Item Master (P4101) screen.
8. Create a new purchase order for the supplier in any branch plant.
   1. On the Order Detail form take the form exit to catalogs and select the FASTENER catalog on the Search and Select Form.
   2. The item just created is not displayed in the Catalogs - Item Selection Screen
   3. That is because the short item number has not been populated into the item catalog (F41061) table.
9. Enter the item on it’s own into the Order Detail grid
   1. The description is retrieved but not unit cost from the catalog.
   2. Again this is because the short item number is not populated in the F41061 supplier catalog table.
      
      

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.