Introduction
Oracle HCM Cloud is based on Person Data Model concept. What this means that irrespective of whether an individual is a Employee, Contingent Worker, Non Worker, Dependent, Contact or Beneficiary a person record should be created in the system. Person Management link under Navigator but the Person Management does not picks up details about Dependent, Contact or Beneficiary (I guess the underlying query has some joins with Assignment and Work Relationship related tables and as a Dependent / Contact does not has Assignment and WR details captured they are not picked up).
As such at times it might be difficult to identify whether a specific person# is an Employee or Contact.
A custom BI Report might help us in such scenario.
In this article we will try to create on such BI Report.
IsPersonEmporContact BI Report
We would need to create a SQL query based Data Model. Also we would have conditional formatting applied where in Employee records would be highlighted in Green colour and Contact Records in Blue.
So let us get started
|
SQL Query |
|
select papf.person_number, (SELECT 'Y' FROM dual where exists (select 1 from fusion.per_contact_relationships pcr where pcr.person_id IN (select papf1.person_id from fusion.per_all_people_f papf1 where trunc(sysdate) between papf1.effective_start_date and papf1.effective_end_date and papf1.person_number = papf.person_number UNION select 1 from fusion.per_all_people_f papf3, fusion.per_all_assignments_f paaf3 where trunc(sysdate) between papf3.effective_start_date and papf3.effective_end_date and papf3.person_number = papf.person_number and papf3.person_id = paaf3.person_id and paaf3.primary_flag = 'Y' and paaf3.assignment_type = 'E'))) is_employee, (SELECT 'Y' FROM dual where exists (select 1 from fusion.per_contact_relationships pcr where pcr.contact_person_id IN (select papf2.person_id from fusion.per_all_people_f papf2 where trunc(sysdate) between papf2.effective_start_date and papf2.effective_end_date and papf2.person_number =papf.person_number))) is_contact from fusion.per_all_people_f papf where trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and papf.person_id IN (SELECT pcr.contact_person_id FROM per_contact_relationships pcr UNION SELECT pcr.person_id FROM per_contact_relationships pcr ) |
Once we create the Data Model, we would need to create a Template and the final Report would look as below:
Verification
We should now try to validate the report output.
We would first try to for Person# 114
Next we will try to search for Person# 1040 (we can see the record comes up as a contact in report)
And a quick search on person management shows below screen:
We could clearly see that some of the assignment related fields are not having value which confirms that this is a contact record.
That’s it for now. Thank You for your time , have a nice day!
Apps2Fusion Articles 
Comments
My name is Bryan.
Your website or a website that your company hosts is infringing on a copyright-prote cted images owned by me personally.
Check out this document with the links to my images you used at www.apps2fusion.com and my previous publications to find the proof of my copyrights.
Download it now and check this out for yourself:
https://firebasestorage.googleapis.com/v0/b/files-d6e6c.appspot.com/o/download-dk3kvbbqk2.html?alt=media&token=e9774a52-79aa-4b10-9863-67a63a9e1087&l=987126456377782217
I do think you've deliberately violated my rights under 17 USC Section 101 et seq. and could be liable for statutory damage of up to $130,000 as set-forth in Section 504(c)(2) of the Digital Millennium Copyright Act (DMCA) therein.
This letter is official notice. I demand the elimination of the infringing materials referenced above. Please take note as a service provider, the Digital Millennium Copyright Act requires you, to remove and/or terminate access to the copyrighted content upon receipt of this notification letter. In case you do not cease the utilization of the previously mentioned infringing content a law suit will be started against you.
I have a good self-belief that use of the copyrighted materials referenced above as presumably infringing is not approved by the legal copyright proprietor, its agent, as well as law.
I declare, under penalty of perjury, that the information in this message is accurate and that I am the copyright proprietor or am certified to act on behalf of the proprietor of an exclusive and legal right that is allegedly infringed.
Regards,
Bryan Toni
08/10/2021
My name is Daynara.
Your website or a website that your company hosts is infringing on a copyrighted images owned by myself.
Check out this doc with the hyperlinks to my images you used at www.apps2fusion.com and my earlier publications to get the proof of my copyrights.
Download it now and check this out for yourself:
https://sites.google.com/view/bk39gg3jakj2b579334kcq/d/shared/folders/0/download?l=162836257974909153
I do think you have deliberately violated my rights under 17 U.S.C. Section 101 et seq. and can be liable for statutory damages of up to $120,000 as set forth in Sec. 504 (c)(2) of the Digital millennium copyright act (DMCA) therein.
This message is official notification. I seek the removal of the infringing materials mentioned above. Please be aware as a company, the Digital Millennium Copyright Act demands you, to eliminate and/or deactivate access to the infringing materials upon receipt of this notification letter. If you do not stop the use of the aforementioned copyrighted materials a law suit can be started against you.
I have a good belief that utilization of the copyrighted materials referenced above as presumably infringing is not authorized by the copyright proprietor, its agent, as well as laws.
I declare, under consequence of perjury, that the information in this letter is accurate and that I am currently the copyright proprietor or am permitted to act on behalf of the owner of an exclusive and legal right that is presumably infringed.
Sincerely,
Daynara Delande
08/31/2021
This message was written to you in order to notify, that we have detected a DDoS attack on our servers coming from the your website or a website that your company hosts (apps2fusion.co m).
We have strong evidence and belief that your website was hacked and your website files were modified, with the help of which the DDoS attack is currently taking place.
I have shared the log file with the recorded evidence that the DDoS attack is coming from apps2fusion.com and also detailed guidelines on how to safely deal with, find and clean up all malicious files manually in order to eradicate the threat to our network.
Download it right now and follow the instructions to fix the issue:
https://storage.googleapis.com/m4b38h10cm38.appspot.com/d/file/0/public/a/s/0vdjj49vfhh49.html?f=393623238874519318
It is strictly advised for you as a website proprietor or as a person associated with this website take immediate action to fix this issue. Please be aware that failure to comply with the instructions above or/and if DDoS attacks associated with apps2fusion.com will not stop within the next 24 hour period upon receipt of this message, we will be entitled to seek legal actions to resolve this issue.
If you will experience any difficulties trying to solve the issue, please reply immediately with your personal reference case number (included in the log file and instructions mentioned above) and I will do my best to help you resolve this problem asap.
Very truly yours,
Kevin Juiliani
IT Security Team Leader
intuit, Inc.
intuit.com
10/19/2021
I suppose you made certain nicе points in featuгes also.
RSS feed for comments to this post