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

IN below query working in production but not in testing

Received Response
11
Views
5
Comments

Hi Team,

when i do query in testing suite national id number is coming with data but in testing suite having data and coming production working find could please assist on where my condition wrong.


 ppnf.Full_Name,


  pni.NATIONAL_IDENTIFIER_NUMBER,


  Pn.PASSPORT_NUMBER,


  pp.attribute3 as "Business Card Title",


  to_char(ppos.ORIGINAL_DATE_OF_HIRE, 'DD-MM-YYYY') Hire_Date,


  to_char(CURRENT_DATE,'DD-MM-YYYY')


from


  --PER_PERSON_SECURED_LIST_V papf,


  per_all_people_f papf,


   PER_PERSON_NAMES_F ppnf,


 --PER_ASSIGNMENT_SECURED_LIST_V paaf,


 per_all_assignments_f paaf,


 PER_PERSONS pp,


 PER_NATIONAL_IDENTIFIERS pni,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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