E1: 90CD: Manage Work Order Parts - P90CD015 Calls Work Order Billing Workfile Generation - R1775 with Incorrect Values for Actual Billable Units and Actual Billable Amount Fields (Doc ID 3051132.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

When changing the Customer Number from Work Order Revisions - P90CD015 from one having a price adjustment schedule defined, to another one with no price adjustment schedule, after the parts were issued (e.g. Actual Quantity is populated), Work Order Billing Workfile Generation - R1775 incorrectly keeps and displays the Actual Billable Units and Actual Billable Amounts of the old customer (with a % discount).
The Estimated Billable Unit amount are correct, updated on the fly.

The issue can be reproduced at will with the following steps:

1. Set Advance pricing for Customer Number 875. P40073 – Define Preference Hierarchy for the Advanced Pricing setup.
2. P4092 – Create a Type 5 - S&WM Order Detail Group; Use Company and Work Order Cat Code 02 as triggers for the Price Group.
3. P4071 – Define the price adjustment: Target Application = 2 – Service & Warranty Management. Use the previous Order Detail Group and the above Preference Hierarchy. Check the Override Price flag.
4. P4072 – Create the price adjustment detail. Set the field From Level = -99999, Factor Value Numeric = 200, BC = 5 – Add on Amount, Customer, Currency Code, and effectivity dates.
5. P4070 – Define the Adjustment Schedule. Use the previous price adjustment detail defined for e.g. Seq. No. 80.
6. P1782 – Set the Customer Number 875 to use the above Adjustment Schedule during service order creation.
7. P90CD020 – Click on Add button to create a service order with Customer Number 875; P90CD002 application will be called from the P90CD020 screen.
8. P90CD002 – Add the details of the service order created for the above equipment record.
9. P90CD015 - Enter Part list with Line Type B, with Estimated Quantity and Actual Quantity, Estimated Billable Unit and Actual Billable Unit populates based on the P4072 - Adjustment detail. Billable amount is 2072.83 after the 12% discount.
10. P90CD015 - By using ‘Change Customer info’ from the header, change the customer 875 to 876 (no schedule, no discount), the Billable amount is 2355.45 without Discount.
11. P90CD015 - Click on OK button and call R1775 report, which changed the estimated Billable Unit with the new amount. However, thr Actual Billable Unit & Amount fields are still populated with previous values, which is not correct.
12. P90CD015 - If the user deletes the Actual Billable Amount and movse the cursor to the next line, it populates the correct value. This is not the correct behavio, because the Actual Billable Unit amount has to change on the fly, along with Estimated Billable Unit amount.

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.