{"id":31088,"date":"2026-01-06T07:25:46","date_gmt":"2026-01-06T07:25:46","guid":{"rendered":"http:\/\/kovaion-new1.local\/automated-generation-of-employee-letter-from-document-of-records\/"},"modified":"2026-01-06T12:58:46","modified_gmt":"2026-01-06T12:58:46","slug":"automated-generation-of-employee-letter-from-document-of-records","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/automated-generation-of-employee-letter-from-document-of-records\/","title":{"rendered":"Automated Generation of Employee Letter from Document of Records"},"content":{"rendered":"

User can use this feature as a repository to generate any letters on the go and to store it as well. Oracle update of 20B, it\u2019s very easy to generate letter based on the Document Record in Oracle HCM Cloud. Data entered by user at the time of document creation can also be included in the letter and the generated letter will be automatically stored as a PDF file attachment under the same document of record.<\/p>\n

Case Study:<\/strong><\/p>\n

Let\u2019s take an example to comprehend the functionality of Generate Letter Based on the Document Record to make your understanding much clearer. Suppose that few of the Employee of our Organization are going to some different country for the business meeting and customer events for that employee must provide his visa details based on that Organization provide an authentication letter to the Employee. This feature comes as a handy to facilitate such on the fly letter generation to Employees.<\/p>\n

Steps to enable:<\/strong><\/p>\n

Step 1<\/strong>: Navigate to reports and aanalytics and create a report using RTF template with source as basic query (as per requirement) provided below. Make sure reports are created under Custom > Human capital Management.<\/p>\n

\"\"<\/p>\n

Select distinct papf.person_number,\nppnf.display_name,\nHDOR.DEI_ATTRIBUTE1 Visa_Type,\nHDOR.DATE_FROM,\nHDOR.DATE_TO,\nHDOR.ISSUING_COUNTRY,\nHDOR.ISSUING_LOCATION,\nHDOR.ISSUED_DATE,\nHDOR.ISSUING_AUTHORITY,\npp.DATE_OF_BIRTH,\npplf.SEX Gender,\npplf.MARITAL_STATUS\nfrom\nper_all_people_f papf,\nPer_persons pp,\nPER_PEOPLE_LEGISLATIVE_F pplf,\nper_person_names_f ppnf,\nHR_DOCUMENTS_OF_RECORD HDOR\nwhere\npp.person_id = papf.person_id\nand papf.person_id = pplf.person_id\nand papf.person_id = ppnf.person_id\nand papf.person_id = HDOR.PERSON_ID\nand HDOR.DOCUMENT_TYPE_ID = '300003063872411'\nand HDOR.LAST_UPDATE_DATE = (select max(HDOR1.LAST_UPDATE_DATE) from HR_DOCUMENTS_OF_RECORD HDOR1 where HDOR1.PERSON_ID=HDOR.PERSON_ID and trunc(HDOR1.LAST_UPDATE_DATE) <= trunc(sysdate))\nand sysdate BETWEEN papf.EFFECTIVE_START_DATE AND papf.EFFECTIVE_END_DATE\nand sysdate BETWEEN ppnf.EFFECTIVE_START_DATE AND ppnf.EFFECTIVE_END_DATE\nand sysdate BETWEEN pplf.EFFECTIVE_START_DATE AND pplf.EFFECTIVE_END_DATE<\/pre>\n
Step 2<\/strong>: Create a report using RTF template. Report looks as below<\/p>\n
\"\"<\/p>\n
Step 3<\/strong>: Navigate to\u00a0Set up and Maintenance\u00a0<\/strong>and search for task \u201cdocument type\u201d<\/p>\n
\"\"<\/p>\n
Step 4<\/strong>: Click on + to create a document<\/p>\n
\"\"<\/p>\n
Step 5<\/strong>: Provide all the details. Make sure created report path is correct. After that providing all details click on save and close.<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
Step 6:\u00a0<\/strong>Go to Navigator >> Me >> Personal Information click on Document for Record.<\/p>\n
\"\"<\/p>\n
Step 7<\/strong>: Click on\u00a0Add\u00a0<\/strong>Search with\u00a0Visa From<\/strong>, then fill the details and click on\u00a0View Document\u00a0<\/strong>to view generated letter.<\/p>\n
Then click on\u00a0Submit\u00a0<\/strong>to submit the Document.<\/p>\n
\"\"<\/p>\n
Step 8<\/strong>: View of generated letter before submission of Document. Watermark will be embossed on the document, to ensure the data authenticity.<\/p>\n
\"\"<\/p>\n
Step 9<\/strong>: Navigate to Documents of Records page where employee can download Document.<\/p>\n
\"\"<\/p>\n
Step 10<\/strong>: Once document is downloaded you can View the generated Letter.<\/p>\n
\"\"<\/p>\n
Business Benefits:<\/strong><\/p>\n
    \n
  • Completely driven by Self-service mode<\/li>\n
  • Eliminate HR\u2019s dependency on any letter generation.<\/li>\n
  • Ensure data integrity and security<\/li>\n
  • Supports all custom templates.<\/li>\n<\/ul>\n
    Author
    \nKishore Kolluru
    \nOracle HCM Cloud Team<\/p>\n","protected":false},"excerpt":{"rendered":"
    User can use this feature as a repository to generate any letters on the go and to store it as well. Oracle update of 20B, it\u2019s very easy to generate letter based on the Document Record in Oracle HCM Cloud. Data entered by user at the time of document creation can also be included in […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-31088","post","type-post","status-publish","format-standard","hentry","category-oracle-hcm"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=31088"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31088\/revisions"}],"predecessor-version":[{"id":31089,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31088\/revisions\/31089"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=31088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=31088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=31088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}