When Attempting End Date An Obsolete Item On A Price List In Purchasing Get ORA-06503 Error (Doc ID 2297274.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Purchasing - Version 11.5.10.2 and later
Oracle Advanced Pricing - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Price List

When attempting to end date the item on the price list line,
upon saving, the following error occurs.

ERROR
-----------------------
ORA-06503: PL/SQL Function returned without value in Package Qp_Validate_pll_pricing_attr Procedure Entity


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Item added to parts list
1. Navigate to: Price Lists > Price List Setup
2. Query price list
  Two records are shown for a particular part / item number
  1. Start: 01-JUL-2017 End: 01-JUL-2017 unit price = 1
  2. Start: 02-JUL-2017 End: unit price = 2
3. Navigate to: Inventory > Items > Organization items
4. Query the item and make status = obsolete
5. Attempt to end date the item on price list
6. When committing the record error is raised
  ORA-06503: PL/SQL Function returned without value in Package Qp_Validate_pll_pricing_attr Procedure Entity


Cause

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