E1: 41: Supplier Catalog Mass Update (R41061M) Returns False Branch/Plant Invalid (0964) Error (Doc ID 2794410.1)

Last updated on AUGUST 24, 2021

Applies to:

Symptoms

Supplier Catalog Mass Update (R41061M) Returns Branch/Plant Invalid (0964) Error, even though the Branch Plant does exist in Branch/Plant Constants (P41001) and the Item Branch Records have been setup in the Item Branch (F4102) tale. Records are not added to the Supplier Catalog (F41061) table because of the error.

ERROR
Branch/Plant Invalid (0964)
CAUSE . . . . Branch/Plant is not set up in the Constants file.
RESOLUTION. . Set up Branch/Plant in the Constants file.

1. Create two new Suppliers (5796 & 6975)
2. Create three new items (41061M-1, 41061M-2, 41061M-3). Make sure all items use Purchase Price Level 2 (SupplierItemBranch Level)
3. Create and save a .CSV spreadsheet containing the following columns with 6 prices for different combinations of Supplier and Item, but do not populate (or remove) column headers in the first row. Paste the file into the desired directory on the Enterprise Server.
   1. Supplier
   2. Catalog
   3. 2nd Item Number
   4. Unit Cost
   5. Currency
   6. Quantity Break
   7. Unit of Measure
   8. Effective From Date
   9. Effective Through Date
   10. Branch Plant
   11. 3rd Item Number
   12. Short Item Number
4. 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 with the full directory path where the file is located on the Enterprise Server.
5. Run Supplier Catalog Mass Update (R41061M). Error Report (R41061E) shows a Branch/Plant Invalid Error.
6. No message appears in the Work Center
7. Debug Logs show Branch/Plant Invalid (0964) error in VerifyAndGetItemMaster (X4101.c) Business Function
8. Item Branch (F4102) records do exist for all the items.
9. Further Log Analysis shows SQL Query fails to find Branch Plant 30 in Branch Plant Constants (F41001)
10. Branch Plant Constants (P41001) shows branch plant 30 does exist.
    1. This error should not appear because the Branch Plant IS valid.

Cause

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