E1: 43: 45: Repricing (R45750) a Purchase Order To Apply Order Level Prcing Adjustments Ends in an Invalid Item Number Error (Error ID 4738) (Doc ID 2976785.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

Basket / Order Level Pricing for Procurement (R45750) to Add a Detail Line to a Purchase Order returns the following error.

This will occur if the Line Type of the line being added has the “Edit Item Master for Non-Stock Item” checkbox checked in the Line Type Constants (P40205).

Steps to Duplicate

1. In Line Type Constants (P40205) Line Type N is configured as follows:
   1. Line Type Description = “Non-Stock”.
   2. Edit Item Master for Non-Stock Item checkbox is checked.
2. The Price Adjustment Definition (P4071) is set as follows:
   1. Target Application = 1 (Procurement)
   2. Adjustment Control Code = 9 (Add to Purchase Detail).
   3. Order Level Adjustment radio button selected.
   4. Preference Hierarchy = IG (Item Group).
   5. Line Type for the Added Line = N (Non-Stock).
3. The Item Branch (P41026) record has been setup with an Order Reprice Group populated on the Additional Info. Tab.
4. The Price Adjustment Detail (P4072) is set as follows:
   1. Order Reprice Group matches Item Branch Record
   2. Basis Code 5 (Add on Amount)
   3. Supplier Address is populated
5. Create a Price Adjustment Schedule (P4070) schedule with the one adjustment on it.
6. Add the Adjustment Schedule to the Supplier Master (P04012) on the Purchasing 1 Tab.
7. Create a Purchase Order (P4310) for the Supplier and Item.
8. Select the Line and Row Exit to Additional Info 1.
   1. Verify the Price Adjustment Schedule is populated on the order. Close the form.
9. When you return to the Order Detail, take the Form Exit to Apply Reprice.
   1. The system returns the “Invalid Item Number” Error ID 4738.
10. Recreate the Order without the Added Line.
11. Rerun Basket / Order Level Pricing for Procurement (R45750) in Batch Versions with Debug Logs activated.
    1. The same error is sent to the Work Center.
12. Check the Debug Logs.
13. A SQL Query against the Item Master (F4101) fails because it cannot find an Item with a Second Item Number (LITM) = Blank.

Edit Item Master Checkbox is Checked for Adjustment Line Type



Error Returned by Reprice Form Exit

Work Center Error Sent from Basket / Order Level Pricing for Procurement (R45750)

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.