Unable End Date Price List Lines Where Item Attribute 'Customer Ordered' Is Disabled After R12 Upgrade (Doc ID 2064794.1)

Last updated on JULY 09, 2021

Applies to:

Symptoms

On : 12.1.3 version, Price List

ACTUAL BEHAVIOR
---------------
We upgraded from 11.5.10.2 to R12.1.3 and noticed a change with the end date of price list lines.
In release 11i we were able to end date price list lines regardless if the OM attribute Customer Ordered was enabled.
It appears this behavior has changed in R12.

EXPECTED BEHAVIOR
-----------------------
Expects to be able to end date price list lines regardless if the OM attribute Customer Ordered was enabled on release 12.

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

For Oracle Applications Release 11.5.10.2
=================================
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Inventory > Items > Master Items
3. Query item
4. Click on order management tab
5. Uncheck Customer Ordered
Receive Error:
 Cannot propagate Master controlled attribute value of Customer Order Enabled Flag to child organizations.

 Cause: This operation would result in attribute dependency
 conflict of Customer Order Flag (Value: N) and the
 Customer Order Enabled Flag (value: Y) in one of the child
 organizations.

 Action: Check the Attribute Control settings on these flags.

6. Exit the form.
7. Navigate to: Inventory > Items > Organization Items (Select appropriate org)
8. Query item
9. Click on order management tab
10. Uncheck Customer Order Enabled Flag
11. Save.

12. Navigate to: Inventory > Items > Master Items
13. Query item
14. Click on order management tab
15. Uncheck Customer Ordered and Customer Order Enabled Flag
16. Save.

17. Oracle Pricing Manager Responsibility
18. Navigate To: Price List > Price List Setup
19. Query the price list
20. Add an end date to the price list line.
21. Save.
--Allowed to save without issue.



For Oracle Applications Release 12.1.3
=================================
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Inventory > Items > Master Items
3. Query item
4. Click on order management tab
5. Uncheck Customer Ordered
Receive Error:
 Cannot propagate Master controlled attribute value of Customer Order Enabled Flag to child organizations.

 Cause: This operation would result in attribute dependency
 conflict of Customer Order Flag (Value: N) and the
 Customer Order Enabled Flag (value: Y) in one of the child
 organizations.

 Action: Check the Attribute Control settings on these flags.

6. Exit the form.
7. Navigate to: Inventory > Items > Organization Items (Select appropriate org)
8. Query item
9. Click on order management tab
10. Uncheck Customer Order Enabled Flag
11. Save.

12. Navigate to: Inventory > Items > Master Items
13. Query item
14. Click on order management tab
15. Uncheck Customer Ordered and Customer Order Enabled Flag
16. Save.

17. Oracle Pricing Manager Responsibility
18. Navigate To: Price List > Price List Setup
19. Query the price list
20. Add an end date to the price list line.
21. Save.
Receive Note:

The item is invalid because this item does not exist or belong
to a different operating unit than the one defined in profile "QP: Item Validation Organization".

--Does not allow me to save the end date which was added to the price list line.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.