Purchased Vs Purchasable : Purchasing attribute behavior in Items form (INVIDITM) (Doc ID 886734.1)

Last updated on NOVEMBER 24, 2016

Applies to:

Oracle Item Master - Version: 11.5.10.0 to 11.5.10.0 - Release: 11.5 to 11.5
Information in this document applies to any platform.
INVIDITM.fmb
This document includes all versions of Oracle EBS 11i and R12 and later

Goal

Item Status should control "Purchasable" flag so when item status is ACTIVE, the flag is enabled and can not be changed. That control works as designed. However, if you uncheck "PURCHASED" flag, the "Purchasable" flag is also unchecked and item can be saved even when Item Status is ACTIVE (Purchasable is under status control as sets value).

Setup
------
Item Attribute Controls :
Purchased > Controlled at Master level
Status Attributes > Purchasable > controlled at org level > sets value
Item Status > Active (all enabled)

1) Create an Item with Purchasing Template.
2) When tried to uncheck purchasable attribute get warning that attribute is under status control (which works fine)
3) When tried to uncheck purchased attribute, form allows (purchasable also unchecked) and can be saved. Which is not correct because purchasable is under status control and and form should not allow attribute update as in point 2 which conflicts with status control functionality.

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