AUTHID_CURRENT_USER Inserted Into Package Code After Patch Application or Running ADADMIN (Doc ID 975506.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Order Management - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Oracle Shipping Execution - Version 11.5.10.0 to 11.5.10.CU2 [Release 11.5.10]
Information in this document applies to any platform.


Symptoms


Find after application of patch,
modifiers were no longer being applied. We are concerned
that the patch install process (not the patch itself) affected more
than this custom package with AUTHID CURRENT_USER.
Custom code integrates orders and call Pricing Engine via API.
QP: Maintains the Denormalized Data in QP Qualifiers has been run.
Build Attribute Mapping Rules has been run.

Issue is present on production and the test instance.
Issue was not found until it was moved to production.

EXPECTED BEHAVIOR
-----------------------
Expect no issues in pricing when a costing patch is applied
since these are separate modules.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Oracle Process Manufacturing patch 8617201,
2. Enter order and modifiers are not applied.

### Workaround ###
Removed inserted line AUTHID CURRENT_USER
from custom code and reintegrated order.
All necessary modifiers applied

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, concern is raised on the patching process and what it impacts
on custom code.
.

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