Unable to Change 'Hold Criteria' LOV in Seeded Lookup 'HOLD_ENTITY_DESC' (Doc ID 1918720.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Hold Criteria's are defined in Sales Order Form, based on the seeded Lookup 'HOLD_ENTITY_DESC':
    Navigation to see the Hold Criteria LOV in Order Management:
1. Order Organizer > 'Holds Information' tab > Tools > Create Holds Source
2. Enter any 'Hold Name' from the LOV > Click on LOV for 'Hold Criteria and see the list of values.
We are unable to change the available LOV, by making records disable or end dated in the setup for this Lookup.
 
Navigation in Order Management to see the setup for the LOV:
1. Setup > QuickCodes > Order Management > Query for 'HOLD_ENTITY_DESC'.
2. Try to uncheck the 'Enabled' box and get an error:
  FRM-40200: Field is protected against update

We want same number of Hold Sources available in R12 , which is 11i.
  11i has:
Bill to Site
Customer
Blanket Number
Item
Blanket Line Number
Order
Ship to Site
Warehouse
  R12 has in addition to the above:
Created By
Creation Date
Customer Number
Deliver to Site
End Customer
End Customer Location
End Customer Number
Item Category
Line Type
Option Item
Order Type
Payment Type
Price List
Project Number
Sales Channel Code
Shipping Method Code
Source Type Code
Source Type Code
Task Number
Transaction Currency Code
Top Model

How can we make the Hold LOV the same in R12 as it was in 11i?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms