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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Use cast on OTBI extract attribute

in Human Capital Management 1 comment

Summary:


Content (please ensure you mask any confidential information):

Hello everyone,

I'm customizing the extraction of an otbi and therefore I'm having problems using the LISTAGG and CAST functions.

I would need to use the cast on this attribute so that it is translated into "char" or "string" so that I can use the "LISTAGG" function.

Could you provide me with advice or tips on how to syntactically write this thing.

example:

  • i have a need convert this attribute "LISTAGG("Workforce Management - Checklist Real Time"."Allocated Checklist"."Allocation Date" BY "Allocated Checklist"."Allocated Checklist Identifier")" in char
  • i have a need convert this attribute "LISTAGG("Workforce Management - Checklist Real Time"."Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_PERCENTUALE_"BY "Allocated Checklist"."Allocated Checklist Identifier")" in char
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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