Technology Stack - EBS (MOSC)

MOSC Banner

Applying R12.TXK.C_R12 30735865 patch; got error ORA-01422 in log

edited Sep 1, 2021 9:59PM in Technology Stack - EBS (MOSC) 2 commentsAnswered

We are on EBS 12.2.6 Linux and I am applying TXK patch 30735865 in a test environment where I have a primary and a secondary DMZ application node setup. The adop screen is showing success on both nodes, but when I looked in each node's patch log, I saw this error:

Determining SEQ for permission: java.lang.RuntimePermission * NULL

Unexpected error encountered:ORA-01422: exact fetch returns more than requested number of rows

--

ORA-06512: at line 66

I believe it's running this query in the file adjvaprm.sql. When I run that via Toad, I do see two records returned as in my below screenshot. My question is, do I have to worry about this logged error, especially since the adop log is saying the patch application was successful?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS TechStack Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center