SYMPTOMS
On : 12.1.1 version, Transaction Entry
When attempting to enter a new item in Orders Workbench, the following error occurs.
ERROR
-----------------------
FRM-40212: Invalid value for field ORDERED_ITEM_DSP
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Master Items > Entered Item in Item Master with correct parameters for Order Management tab:
Customer Ordered
Internal Ordered
Customer Orders enabled
Internal Orders Enabled
Shippable
OE Transactable
Returnable
3. Assigned to All Orgs
4. Add Item to Sales Order Line
5. Enter an order for the item and receive error:
FRM-40212: Invalid value for field ORDERED_ITEM_DSP
When attempting to enter a new item in Orders Workbench, the following error occurs.
ERROR
-----------------------
FRM-40212: Invalid value for field ORDERED_ITEM_DSP
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Master Items > Entered Item in Item Master with correct parameters for Order Management tab:
Customer Ordered
Internal Ordered
Customer Orders enabled
Internal Orders Enabled
Shippable
OE Transactable
Returnable
3. Assigned to All Orgs
4. Add Item to Sales Order Line
5. Enter an order for the item and receive error:
FRM-40212: Invalid value for field ORDERED_ITEM_DSP
CAUSE
The issue is caused by the following setup: profile "OM: Use Materialized View for Items LOV (Honors Item Orderability Rules)" to "Yes" at site level.
SOLUTION
To implement the solution, please execute the following steps:
From the Diagnostics Apps Check output customer has set the profile "OM: Use
Materialized View for Items LOV (Honors Item Orderability Rules)" to "Yes" at
site level.
That means when ever customer does any changes to the Items Master or adds
new Items, they have to run the "Refresh Order Management Materialized Views"
concurrent programs for the Items to be available in the Items LOV of Sales
Order form.
Alternatively, customer can set the profile "OM: Use Materialized View for
Items LOV (Honors Item Orderability Rules)" to "No", then the Items will be
immediately be available in the LOV.
Please refer to 12.1 user guide for complete details on this profile usage.
1. Go into the responsibility: Order Management Super User.
2. Navigate to Setup > Profiles > set the profile "OM: Use Materialized View for Items LOV to "No" at the site level.
3. If changing the profile is not preferred, please run the "Refresh Order Management Materialized Views" concurrent programs for the Items to
be available in the Items LOV of Sales Order form.
4. Retest the issue.
5. Migrate the solution as appropriate to other environments.
From the Diagnostics Apps Check output customer has set the profile "OM: Use
Materialized View for Items LOV (Honors Item Orderability Rules)" to "Yes" at
site level.
That means when ever customer does any changes to the Items Master or adds
new Items, they have to run the "Refresh Order Management Materialized Views"
concurrent programs for the Items to be available in the Items LOV of Sales
Order form.
Alternatively, customer can set the profile "OM: Use Materialized View for
Items LOV (Honors Item Orderability Rules)" to "No", then the Items will be
immediately be available in the LOV.
Please refer to 12.1 user guide for complete details on this profile usage.
1. Go into the responsibility: Order Management Super User.
2. Navigate to Setup > Profiles > set the profile "OM: Use Materialized View for Items LOV to "No" at the site level.
3. If changing the profile is not preferred, please run the "Refresh Order Management Materialized Views" concurrent programs for the Items to
be available in the Items LOV of Sales Order form.
4. Retest the issue.
5. Migrate the solution as appropriate to other environments.
No comments:
Post a Comment