My Oracle Support Banner

POR_CUSTOM_PKG.CUSTOM_DEFAULT_REQ_LINE Does Not update Null To Need_by_date field on Shopping Cart (Doc ID 3004717.1)

Last updated on FEBRUARY 19, 2024

Applies to:

Oracle iProcurement - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

On iProcurement, while creating requisition, user is not able to customize to update NULL value into need_by_date field using POR_CUSTOM_PKG.CUSTOM_DEFAULT_REQ_LINE procedure. This is working in 12.1.3 but not in 12.2.12.

STEPS
-----------------------
1. Follow Doc ID 397248.1 and modify procedure POR_CUSTOM_PKG.CUSTOM_DEFAULT_REQ_LINE to pass NULL to need_by_date.
2. Compile the package
3. Set the profile option POR: Enable Requisition Line Customization to Yes at SITE level
4. Now go to iProcurement and create catalog or non-catalog requisition. Add lines and click on "View Cart and Checkout" button
5. Observe that the need_by_date is still displaying default date instead of NULL on Shopping Cart Pop-up.

Changes

 Upgrade to 12.2.12

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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