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

is pivot functionality works good in all environments?

Summary: Hi, I am trying to convert data rows into columns using pivot function in BIP Reports. i tried to use in test environment the pivot functionality working good. when i got to development the pivot functionality is not working well. it is not giving some of the output attribute values as compared to test environment.

I used below pivot functionality in BIP REPORTS for both environments

select * from (

  select LOAN_NUMBER, DOCUMENT_TYPE, DOCUMENT_ID

  from my_table t

)

pivot 

(

  MIN(DOCUMENT_ID)

  for DOCUMENT_TYPE in ('Voters ID','Pan card','Drivers licence')

)


Please let me know , if need any changes in development?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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