{"id":31176,"date":"2026-01-06T08:26:08","date_gmt":"2026-01-06T08:26:08","guid":{"rendered":"http:\/\/kovaion-new1.local\/generation-of-letter-from-document-of-records-when-using-hdl\/"},"modified":"2026-01-06T12:50:38","modified_gmt":"2026-01-06T12:50:38","slug":"generation-of-letter-from-document-of-records-when-using-hdl","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/generation-of-letter-from-document-of-records-when-using-hdl\/","title":{"rendered":"Generation of Letter from Document of Records When using HDL"},"content":{"rendered":"

 <\/p>\n

With the 20B upgrade, Oracle has provided a feature to Generate Letters Based on Document Records.<\/p>\n

Read More<\/strong>: Automated Generation of Employee Letter from DOR<\/a><\/strong><\/p>\n

Now with the recent 23A update, Oracle has further refined the process of generating letters and storing them as document record attachments in Oracle HCM Cloud. So, users can download letters, even when document records are created using HCM DATA LOADER\/REST API. Also, users can utilize this feature as a repository to conveniently download any necessary letters while on the go and utilize them as needed.<\/p>\n

 <\/p>\n

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

To understand the functionality of the “Generate Letter Based on Document Record when using HDL” feature, let’s consider an example. Imagine that a group of employees from an organization are traveling abroad for a business meeting or customer event. These employees are required to provide their visa details, after which the organization can provide an authentication letter to each employee. This feature is especially convenient for generating bulk letters on-the-fly for employees in such situations.<\/p>\n

 <\/p>\n

Steps to Enable:<\/strong><\/h2>\n

Step 1:<\/strong> To begin, access the Setup and Maintenance work area.<\/p>\n

\"Generation
Fig.1 Navigation for Setup and Maintenance work area<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 2:<\/strong> Next, locate and select the task named Manage Enterprise HCM Information.<\/p>\n

\"Generation
Fig.2 Manage Enterprise HCM Information Task search area<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 3:<\/strong> Then, choose the document record source for the Letter Generation Configuration based on the EFF context of the document.<\/p>\n

\"Generation
Fig.3 Letter Generation Configuration Based on Document Record Source<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Note<\/strong>: It is important to note that the options available in the Document Record Source column are populated from the ORA_PER_DOR_SOURCE lookup and only the supported values will be displayed in the list. This ensures the validity of the selection.<\/p>\n

 <\/p>\n

Step 4:<\/strong> Navigate to Reports and Analytics and create a report using the RTF template with the source as a basic query (as per requirement) provided below. Make sure to create reports under Custom -> Human Capital Management.<\/p>\n

\"Generation
Fig.4 SQL code execution area for report creation<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Select distinct
\npapf.person_number
\n,ppnf.display_name
\n,’Tourist Visa’ Visa_Type
\n,HDOR.ISSUING_AUTHORITY
\n,HDOR.ISSUING_COUNTRY
\n,HDOR.ISSUING_LOCATION
\n,to_char(HDOR.ISSUED_DATE,’YYYY\/MM\/DD’) ISSUED_DATE
\n,to_char(HDOR.DATE_FROM,’YYYY\/MM\/DD’) Valid_From
\n,to_char(HDOR.DATE_TO, ‘YYYY\/MM\/DD’) Valid_To
\n,pplf.SEX Gender
\n,to_char(pp.DATE_OF_BIRTH,’YYYY\/MM\/DD’) DATE_OF_BIRTH
\n,pplf.MARITAL_STATUS<\/p>\n

from
\nper_all_people_f papf
\n,per_person_names_f ppnf
\n,Per_persons pp
\n,PER_PEOPLE_LEGISLATIVE_F pplf
\n,HR_DOCUMENTS_OF_RECORD HDOR
\n,HR_DOCUMENT_TYPES_TL HDT
\nwhere
\n1=1
\nand pp.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 = HDT.DOCUMENT_TYPE_ID
\nand HDT.DOCUMENT_TYPE = ‘VISA Letter’
\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)) and sysdate BETWEEN papf.EFFECTIVE_START_DATE AND papf.EFFECTIVE_END_DATE and sysdate BETWEEN ppnf.EFFECTIVE_START_DATE AND ppnf.EFFECTIVE_END_DATE and sysdate BETWEEN pplf.EFFECTIVE_START_DATE AND pplf.EFFECTIVE_END_DATE<\/p>\n

 <\/p>\n

Step 5:<\/strong> Create a report using the RTF template. The report looks as below.<\/p>\n

\"Generation
Fig.5 Report Path<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 6:<\/strong> Navigate to Set up and Maintenance. Search for the \u201cDocument Type\u201d task.<\/p>\n

\"Generation
Fig.6 Document Type Task Search area<\/strong><\/figcaption><\/figure>\n

Step 7:<\/strong> Click on “+” to create a document.<\/p>\n

\"Generation
Fig.7 Document Creation area<\/strong><\/figcaption><\/figure>\n

Step 8:<\/strong> Furnish all the details. And, make sure the created report path is accurate. Next, click on Save and Submit.<\/p>\n

\"Generation
Fig.8 Document creation with required details area_1<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"Generation
Fig.9 Document creation with required details area_2<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 9:<\/strong> Prepare an HDL (sample below) of the DocumentsOfRecord business object to create a VISA document under documents of record for employees.<\/p>\n

METADATA|DocumentsOfRecord|PersonNumber|DocumentType|DocumentCode|DocumentName|DateFrom|DateTo|IssuedDate|IssuingAuthority|IssuingCountry|IssuingLocation MERGE|DocumentsOfRecord|197963|VISA Letter|VISA_Letter_197963|VISA Letter_197963|2023\/01\/01|2023\/12\/31|2023\/01\/15|Government Of India|IN|Bangalore<\/p>\n

 <\/p>\n

Step 10:<\/strong> Go to My Client Group > Data Exchange > Import and Load Data > Import File and wait till loading success.<\/p>\n

\"Generation
Fig.10 HCM Data Loader File Import and Load work area<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"Generation
Fig.11 HCM Data Loader Result<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 11:<\/strong> Navigate to the Documents of Records page where employees can see created document and download it.<\/p>\n

\"Generation
Fig.12 Document Of Record page<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 12:<\/strong> Click on Preview and download, once the document is downloaded you can view the generated Letter.<\/p>\n

\"Generation
Fig.13 Generation of Letter from Document of Records When using HDL<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Business Benefits<\/strong><\/p>\n

Here are the business benefits for the generation of letters from documents of records when using HDL (HCM Data Loader)<\/p>\n

    \n
  • Eliminate Employee dependency on any letter generation.<\/li>\n
  • Automatically, the letter will be stored as an attachment in the person’s document record.<\/li>\n<\/ul>\n

     <\/p>\n

    Author<\/strong>: Kishore Kolluru, Senior Consultant<\/p>\n","protected":false},"excerpt":{"rendered":"

      With the 20B upgrade, Oracle has provided a feature to Generate Letters Based on Document Records. Read More: Automated Generation of Employee Letter from DOR Now with the recent 23A update, Oracle has further refined the process of generating letters and storing them as document record attachments in Oracle HCM Cloud. So, users can […]<\/p>\n","protected":false},"author":1,"featured_media":25122,"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-31176","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-hcm"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31176","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=31176"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31176\/revisions"}],"predecessor-version":[{"id":31177,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31176\/revisions\/31177"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/25122"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=31176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=31176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=31176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}