Skip to Main Content
Forums

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Manage Messages - Message User Details not showing in the Warning/Error Message in Oracle HCM Cloud

Sugata BagchiJan 30 2020 — edited Jan 31 2020

The Message User Details section defined in Manage Messages in Oracle HCM Cloud is not getting displayed in the warning/error message.

As per Oracle documentation, I have also enabled the Profile Option FND_MESSAGE_MODE for Level as Site and Value as User.

Please suggest how to get the Message User Details displayed in the Warning / Error Message.

Comments

We use the pl/sql profiler to get code coverage stats. Try observing the sql going across the wire in the View > Log > Statements panel for insight for what might be going wrong in your scenario.

Narmada T

Thank you so much for your response JeffSmith. Here is the error I could see in log

Error : "java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

" building UT_TEST_COVERAGE_STATS_PK, executing sql:

SELECT /*OracleDictionaryQueries.ALL_INDEX_METADATA_QUERY*/

       SYS.DBMS_METADATA.GET_XML('INDEX', ?, ?) XML

FROM   SYS.DUAL

thatJeffSmith-Oracle

I would open a service request with My Oracle Support - include those details. Also, be sure to tell them your version of oracle DB.

Narmada T

I think the issue here is access/privileges to run this query

SELECT /*OracleDictionaryQueries.ALL_INDEX_METADATA_QUERY*/

       SYS.DBMS_METADATA.GET_XML('INDEX', ?, ?) XML

FROM   SYS.DUAL.

SYS.DBMS_METADATA.GET_XML requires SELECT_CATALOGUE role. When i run this query alone  SELECT DBMS_METADATA.GET_XML('TABLE','EMP','SCOTT')FROM DUAL; on my Unit Test Repo schema, i get Invalid Identifier error.

The same query on schema that has select_Catalogue role runs successfully and returns the xml. So i have to try giving SELECT_CATALOGUE role to Unit test repo schema and try to gather statistics to test if that works.

1 - 4

Post Details

Added on Jan 30 2020
#cloud-applications, #hcm-cloud-service
4 comments
401 views