We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to extract Termination Notification details which are still under approval

Accepted answer
22
Views
7
Comments

Summary:

I am trying to create a query to extract Termination Notifications, which are still under approval.

Following is the query that I prepared.

But it's ending into error (ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: at line 1)

If I remove where condition from the query, it works.

Appreciate, if someone can help me to address this error or with any other workaround to get the required data

Content (required):

Query Text:

With SoaRequestData as(

Select 'FutureTermination' infoType

,XMLTYPE(txnd.DATA_CACHE).EXTRACT('//PersonId/text()').getNumberVal() personId

,XMLTYPE(txnd.DATA_CACHE).EXTRACT('//selectedPerson/text()').getStringVal() selectedPerson

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!