My Oracle Support Banner

For Resource Queries After Upgrade - 40735:WHEN-BUTTON-PRESSED Trigger Raised Unhandled Exception ORA-00920 (Doc ID 2546253.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

12.2.7
with Cum #3 - 28797421

Resource queries created in 12.1.3 are not working after upgrade to 12.2.7
Here our new findings:
-------------------------------------------
Create a new query in R12.2.7 with exactly the same criteria as the R12.1.3 query then the new query will run OK.
Attempting to run old R12.1.3 query via icon gives
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00920.
Attempting to run old R12.1.3 query via Right-Mouse exceute query gives
FRM-40735: Popup Menu trigger raised unhandled exception ORA-00920.

Study of data shows suggests oracle have failed to transform the R12.1.3 query to the new way of R12.2.7 working.

select * from msc_personal_queries
where query_type = 2
and query_name IN ('&q1','&q2')

This reveals a new field UNSAVED_FIELD which is NULL for R12.1.3 query and '2' for R12.2.7 query.
I don't think this is the issue.

select * from apps.msc_selection_criteria
where folder_id IN (&id1,&id2)
order by folder_id, sequence;

This reveals significant change in fields FIELD_TYPE and HIDDEN_FROM_FIELD.
R12.2.7 has new FIELD TYPE 'ORG' for ORGANIZATION_CODE and different store in HIDDEN_FROM_FIELD.
R12.2.7 has store of first among value in HIDDEN_FROM_FIELD for RESOURCE_GROUP_NAME.

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!


In this Document
Symptoms
Cause
Solution
References


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