Querying Pricing Agreements Errors with FRM-40735 "PRE-QUERY Trigger Raised Unhandled Exception" ORA-06502 (Doc ID 2015559.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
QPXSSDAF
QPXSSDAF.fmb - Pricing Agreements

Symptoms

On : 12.1.3 version, Agreements/Blankets/Contracts

Tried to Query price agreement headers one by one, could only get to about 6 before it started to give the error ORA-01403 - no data found.
Close out of pricing agreements search and form, back to navigator requery Find agreements, they would then show up.
Could use the flashlight another 6 times and it would give the same error and have to start again.



ERROR
-----------------------
ORA-01403 - no data found

FRM-40735:PRE-QUERY Trigger raised unhandled exception ORA-06502



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Pricing Manager
2. Pricing Agreements
3. Query a Pricing Agreement
4. Click on Flash Icon on the pricing agreement screen.
5. Select one agreement from the Lov and click on Find.

Repeat the steps from 3 to 5 with out closing the screen and after querying 6 records systems says no data found even data exists.

Error
ORA-01403 - no data found

Details
FRM-40735:PRE-QUERY Trigger raised unhandled exception ORA-06502



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