Error in Price Adjustment screen : Invalid value for the field ADJUSTMENT_NAME


Error in Price Adjustment screen : Invalid value for the field ADJUSTMENT_NAME

While doing one of the forms personalization in Service contracts in Price Adjustment screen, I have encountered this strange behavior of the form. The form personalization is related to defaulting the value of the Modifier Number field, whenever the user navigates to the Price Adjustment screen in R12. Following which, I have raised a SR with Oracle and fix was provided for the issue.

This topic is related to that behavior in Price Adjustment screen.

Here are the navigation steps for the error :

1. Login to Oracle EBS and select the Customer Service Management responsibility.Open any existing Service Contract.

2. Navigation: Service Contracts -> Lines.

3. Click on Tools -> Price Adjustments
4. Enter: Price Adjustment in the Modifier Number field and tab out.
You will receive the following error :
FRM-40212: Invalid Value for Field ADJUSTMENT_NAME

5. Now click on the Modifier Number LOV
6. Click on ‘Cancel’ button
7. Now Tab out (without doing any changes), the values are populated correctly

8. As per the screen, there are following values being populated:
Level, Modifier Type, List Line, Lump sum, Bucket N


This was the issue, even though the Modifier Number was same in both the case, but still the error existed whenever the Modifier Number was entered manually without selecting the LOV.

For this issue, I have raised a SR with Oracle. This was resolved succesfully by applying the required patch which was provided by Oracle and I was able to proceed with my Forms Personalization for the requirements.

Refer the Bug No : 10429102 in Metalink for same issue.

No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...