My Oracle Support Banner

After Patch# 25140542, View Only Function Of PO_POXSCASL Disabled (Doc ID 2391836.1)

Last updated on MAY 03, 2018

Applies to:

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

Symptoms

Problem Summary
---------------------------------------------------
After <patch 25140542>, view only function of PO_POXSCASL disabled

Problem Description
---------------------------------------------------
There is custom function defined for use in the Define Approved Supplier list form with a parameter of Query_only= "YES".
 Its purpose is to make the fields in this form inquiry only for a specific view only responsibility.

After applying patch# 25140542 found the function in no longer query only and permits updates to the fields


STEPS
-------------------
1. Create function xx_PO_POXSCASL with the parameter QUERY_ONLY="YES"
2. Assign function to an inquiry menu
3. Assign inquiry menu to a view only responsibility
4. Query item # from the view only responsibility, note update access to fields

BUSINESS IMPACT
-----------------------
Expectation is that Should not allow updates to fields

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!


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