E1: 43: Error 0252 - Extended Price Invalid Generates when a Purchase Order is Partially Moved to STK Using Receipt Routing (P43250) Causing Fields, Amount Received (F43121.AREC) and Open Amount (F43121.AOPN) to be Incorrectly Calculated (Doc ID 2713997.1)

Last updated on DECEMBER 16, 2024

Applies to:

Symptoms

When partially transacting a receipt routing for a purchase order in multiple locations and lots, the Amount Received (F43121.AREC) value is incorrectly calculated and the last step of the process "Move to STK" finishes with the error <Extended Price Invalid> (error id 0252). Also, the F43121.AOPN is incorrect.

Steps to reproduce:

1. Set Receipt Routing Definition (P43091): Route code = RAND
2. Set the route code for a supplier in the Supplier/Item Information (P43090) application.
3. Activate Receipt Routing in the processing options of Receipts by PO(P4312) application.
4. Create a purchase order (P4310) with an item where the Purchase UOM (CA) is different from Primary (EA) for a quantity = 1000CA.
5. Run Receipt the purchase order (P4312) and move into receipt routing flow. For this step use LOTA and primary location. This creates receipt record in F43121.
6. Go to P43250_ ZJDE0001 application and move a partial quantity (600 CA) into next bucket (TRAN to DOCK) as per setup receipt routing . The system will move this quantity (600 CA) into DOCK bucket and the rest (400 CA ) will remain in TRAN stage. No new lines will be added in F43121 as there is not use of multiple location.
7. Go to P43250_ ZJDE0001 application and move another partial quantity (200 CA) into DOCK with different location/lot by using multiple location screen. Notice that there is new line created for this quantity (200 CA) in F43121 with correct Amount Received F43121.AREC value. However, notice that for the parent line, the F43121.AREC is incorrect and AOPN is blank.
8. Go to P43250_ ZJDE0001 application and move the rest of quantity from TRAN to DOCK and again all the quantity from DOCK to INSP . Notice that the F43121.AREC is incorrect and AOPN is blank.
9. Go to P43250_ ZJDE0001 application and try to move the order from INSP to  the last step of receipt routing flow STK. The system throws the error <Extended Price Invalid> (error id 0252).

F43121.AREC and AOPN have to be calculated correct when it runs partially receipt routing for a purchase order using multiple locations and lots and also to be able to move the item into STK successfully without the <Extended Price Invalid> error.

Cause

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