No new Email channel Activities exist in table jtf_ih_interactions after upgrade to R12
unable to see the all the interaction
my query is
SELECT jii.interaction_id interaction_id,
jii.creation_date interaction_date, -- ITG 69428
jii.last_update_date last_update_date,
jii.object_id object_id,
DECODE(jii.object_type, 'AMS_CSCH', 'CSCH', jii.object_type) object_type,
jii.source_code source_code,
jii.source_code_id source_code_id,
jii.party_id contact_id,
hp_o.party_id organization_id,
hp_o.party_name organization_name,
hp_p.party_id person_id,
hp_p.party_name person_name,