My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

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


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.

ORA-01403 - no data found

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

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.

ORA-01403 - no data found

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


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

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