My Oracle Support Banner

FAQ: POR_CUSTOM_PKG (PORCUSTB.pls) For Implementing Default and Validate Customizations in iProcurement Requisition Headers, Lines, and Distributions (Doc ID 1942913.1)

Last updated on JUNE 21, 2023

Applies to:

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

Purpose

FAQ to clarify use of POR_CUSTOM_PKG

Questions and Answers

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
Purpose
Questions and Answers
 1. What are the profiles relevant to POR_CUSTOM_PKG?
 2. Is it necessary to bounce oc4j (iAS/Apache) for the 'POR: Enable Req%Customization' profile changes to take effect?
 3. How can the custom package be used to default DFF line level attributes from header level DFF attribute values?
 4. How do you modify the POR_CUSTOM_PKG code?
 5. Is the POR_CUSTOM_PKG used only for updating DFF attributes, or can it be used for updating other values on requisitions?
 6. Is it necessary for the user to navigate to a page where the DFF attributes or other field values are enabled in order for the POR_CUSTOM_PKG to be called?
 7. How is personalization implemented to show DFF attributes referenced in the POR_CUSTOM_PKG?
 8. Are the POR_CUSTOM_PKG.CUSTOM_DEFAULT... procedures called when there is an update to the requisition header, line, or distribution?
 9. Can the POR_CUSTOM_PKG.CUSTOM_VALIDATE... procedures be used to UPDATE values?
 10. When using POR_CUSTOM_PKG is it okay to retrieve values directly from the requisition tables PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL?
 11. Is there any option to give a Warning message rather than Error message from POR_CUSTOM_PKG, and allow the user to acknowledge and ignore the warning and complete checkout?
References


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