E1: 44H: Bid Contract Extended Price Incorrect in Lot Start Workfile P44H711 After Assignment of TBD Bids Defined with Percentage Factor on the Bid Contract (P44H601) Detail Line (Doc ID 2897506.1)

Last updated on JUNE 05, 2023

Applies to:

Symptoms

Bid Contract Extended Price is incorrect on assigned TBD Bids that utilize Percentage Factor on the detail lines.  This is seen after assigning the supplier for a TBD bid containing Percentage Factor values.  The TBD bid records created in the LSWF show the percentage factor adjusted amounts, but after assigning a supplier, the actual bid records have the full original Bid Total Unit Price, not the percentage adjusted Bid Amount.

Set up and steps needed to duplicate this issue:

1. P44H601 Enter Bids - Create a TBD Bid Contract with the following details:
   1. The Subcontractor on the Header should be a TBD Placeholder supplier, not an actual supplier.
   2. Preferred Subcontractor, Supplier TBD and Recalculate TBD Cost boxes are all checked, (and Unique Document is checked by default).
   3. On the Bid Detail, create 2 lines for 2 different Cost Codes.  On each line use Bid Total Unit Price = 3212.00. 
   4. On the first of the 2 detail lines, set the Percentage Factor field with a value of .90000 to calculate an amount of 2890.80.
   5. On the second of the 2 detail lines, set the Percentage Factor field with a value of .10000 to calculate an amount of 321.20.
2. P44H601 Enter Bids - Create 2 additional bids for the potential, actual suppliers with bid details matching the TBD bid.
   1. Each of these bids will have an actual supplier number, not the TBD supplier number.
   2. The Preferred Subcontractor, Supplier TBD and Recalculate TBD Cost boxes should all remain unchecked. (Unique Document can be checked or unchecked, does not matter for this test.)
   3. On the Bid Detail, create 2 lines for 2 different Cost Codes.  On each line use Bid Total Unit Price = 3212.00.
   4. On the first of the 2 detail lines, set the Percentage Factor field with a value of .90000 to calculate an amount of 2890.80.
   5. On the second of the 2 detail lines, set the Percentage Factor field with a value of .10000 to calculate an amount of 321.20.
3. P44H604 Supplier Assignment - Create Supplier Assignment records for the 2 potential supplier (in step 2) and the Trade Code associated to the Cost Code of the detail lines.  These Supplier Assignment records should be set with Assignment Status = 1.
4. Run R44H700 - Lot Start Workfile Generation to pull the TBD bids into the Lot Start Workfile (LSWF).
5. P44H711 Lot Start Workfile Review - Should now show 2 records in Blue (TBD) text, one for each of the 2 Cost Codes/detail lines of the TBD Bid Contract.
6. P44H711 Lot Start Workfile Review - Select the first of the 2 detail records and use the Assign Supplier row exit to access the P44H704 - Supplier on the Fly where the TBD Bid is assigned to the first of the potential suppliers, (in step 2).
7. P44H711 Lot Start Workfile Review - Press Find to refresh and you should now see additional records in black text for the supplier to which the TBD bid was assigned.  These new records should have the same detail, amounts, etc. as seen on the Blue text TBD bid records.
8. New, actual supplier LSWF records are created, but have the full Bid Total Unit Price = 3212.00, not the Percentage Factor adjusted amounts of 2890.80 & 321.20.

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.