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

Person details are coming as blank in the report

Received Response
31
Views
3
Comments

Hi Team,


We have a requirement to build a query with Card program name,Transaction Amount,Transaction Date, Employee Name and Employee Number.

We used below in the query:

EXM_CARD_PROGRAMS

EXM_CREDIT_CARD_TRXNS

exm_cards

Per_all_people_f

Per_person_names_f

When we add person tables with card tables the person_id is coming as blank.



Kindly help us on to build a query for the above mentioned columns.



Thanks,

Thirumala Rao

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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