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.
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.
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