{"id":32019,"date":"2026-01-06T08:57:33","date_gmt":"2026-01-06T08:57:33","guid":{"rendered":"http:\/\/kovaion-new1.local\/bulk-import-of-lookup-types-codes-using-file-based-loader-in-hcm-cloud\/"},"modified":"2026-05-01T17:40:24","modified_gmt":"2026-05-01T17:40:24","slug":"bulk-import-hcm-cloud","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/blog\/bulk-import-hcm-cloud\/","title":{"rendered":"Bulk Import of Lookup Types\/Codes Using File Based Loader in HCM Cloud"},"content":{"rendered":"<p>Entering all the values of the lookup type and code into the application manually will consume a significant effort during data migration. It may result in wrong data entry which could lead to other application issues. Apart from this, the data entry activity has to be repeated in other instances of applications.<\/p>\n<p>In Oracle fusion\u2019s File import and export feature provides\u00a0<span class=\"TextRun Highlight SCXW259817208 BCX8\" lang=\"EN-US\" xml_lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW259817208 BCX8\">(file import and export in Oracle Fusion)<\/span><\/span>\u00a0a faster way of loading the lookup type and codes which helps consultants overcome the issues that come with manual data entry.<\/p>\n<p><span class=\"TextRun Highlight SCXW66474845 BCX8\" lang=\"EN-US\" xml_lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW66474845 BCX8\">This\u00a0<\/span><span class=\"NormalTextRun SCXW66474845 BCX8\">feature\u00a0<\/span><span class=\"NormalTextRun SCXW66474845 BCX8\">not only\u00a0<\/span><span class=\"NormalTextRun SCXW66474845 BCX8\">expedites<\/span><span class=\"NormalTextRun SCXW66474845 BCX8\">\u00a0the loading process but also ensures data accuracy and uniformity. By mitigating the risks associated with manual entry, such as errors and redundancy, this approach enhances the efficiency of data migration. This efficiency, in turn, empowers consultants to\u00a0<\/span><span class=\"NormalTextRun SCXW66474845 BCX8\">allocate<\/span><span class=\"NormalTextRun SCXW66474845 BCX8\">\u00a0more time to strategic responsibilities, contributing to a seamless implementation of Oracle HCM Cloud.<\/span><\/span><span class=\"TextRun SCXW66474845 BCX8\" lang=\"EN-US\" xml_lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW66474845 BCX8\">\u00a0<\/span><\/span><span class=\"EOP SCXW66474845 BCX8\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559738&quot;:0,&quot;335559739&quot;:150,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2>Here are the steps detailing how to import lookup values in Oracle Fusion:<\/h2>\n<p>&nbsp;<\/p>\n<h3><strong>Step 1<\/strong>:<\/h3>\n<ul>\n<li>Prepare the Import file with Lookup data.<\/li>\n<li>The below table contains the information that you should include in your import files for Lookup Types and Lookup Codes.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Lookup Type \u2013 Header Fields and Descriptions<\/strong><\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16917\" aria-describedby=\"caption-attachment-16917\" style=\"width: 792px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16917\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-1-300x122.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 1\" width=\"792\" height=\"322\" \/><figcaption id=\"caption-attachment-16917\" class=\"wp-caption-text\">Fig 1: Lookup Type<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p><strong>Lookup Codes \u2013 Header Fields and Descriptions<\/strong><\/p>\n<figure id=\"attachment_16916\" aria-describedby=\"caption-attachment-16916\" style=\"width: 707px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16916\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-2-300x213.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 2\" width=\"707\" height=\"502\" \/><figcaption id=\"caption-attachment-16916\" class=\"wp-caption-text\">Fig 2: Lookup Code<\/figcaption><\/figure>\n<div id=\"attachment_2715\" class=\"wp-caption alignnone\">\n<p id=\"caption-attachment-2715\" class=\"wp-caption-text\">\n<\/div>\n<ul>\n<li>While creating the import file use this pipe \u2018|\u2019 as your delimiter and save this file in .csv file extension.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Sample Lookup\u00a0<span class=\"TextRun Highlight SCXW219525944 BCX8\" lang=\"EN-US\" xml_lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW219525944 BCX8\" data-ccp-parastyle=\"heading 3\">Type<\/span><\/span>\u00a0File<\/h3>\n<p>LookupType|Meaning|Description|ModuleKey|ModuleType<br \/>\nPOC_TYPE| POC_TYPE_MEANING| POC_LTYPE_DESC|PER|APPLICATION<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Sample Lookup Code File<\/strong><\/h3>\n<p>LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag<br \/>\nPOC_TYPE|POC_TYPE_CODE|1|Y|04\/07\/2022|31\/12\/4712|POC_TYPE_CODE_MEANING|POC_TYPE_CODE _DESC|CODE _TAG<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Step 2:\u00a0<\/strong><\/h3>\n<ul>\n<li>Navigation to upload the files to the UCM Server<\/li>\n<li><strong>Navigation<\/strong>: Navigator &gt;&gt; Tools &gt;&gt; File Import and Export<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16915\" aria-describedby=\"caption-attachment-16915\" style=\"width: 774px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16915\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-3-300x124.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 3\" width=\"774\" height=\"320\" \/><figcaption id=\"caption-attachment-16915\" class=\"wp-caption-text\">Fig 3: Tools &gt; File Import<\/figcaption><\/figure>\n<div id=\"attachment_2717\" class=\"wp-caption alignnone\">\n<p id=\"caption-attachment-2717\" class=\"wp-caption-text\">\n<\/div>\n<ul>\n<li>Click on the Upload icon.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16914\" aria-describedby=\"caption-attachment-16914\" style=\"width: 697px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16914\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-4-300x237.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 4\" width=\"697\" height=\"551\" \/><figcaption id=\"caption-attachment-16914\" class=\"wp-caption-text\">Fig 4: Search Screen<\/figcaption><\/figure>\n<div id=\"attachment_2718\" class=\"wp-caption alignnone\">\n<p id=\"caption-attachment-2718\" class=\"wp-caption-text\">\n<\/div>\n<ul>\n<li>Browse the prepared import file to upload then select \u2018setup\/functionalSetupManger\/import\u2019 from the Account drop-down list. Click on save and close.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16913\" aria-describedby=\"caption-attachment-16913\" style=\"width: 770px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16913\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-5-300x113.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 5\" width=\"770\" height=\"290\" \/><figcaption id=\"caption-attachment-16913\" class=\"wp-caption-text\">Fig 5: Upload Screen<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<div id=\"attachment_2719\" class=\"wp-caption alignnone\">\n<figure id=\"attachment_16912\" aria-describedby=\"caption-attachment-16912\" style=\"width: 770px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16912\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-6-300x92.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 6\" width=\"770\" height=\"236\" \/><figcaption id=\"caption-attachment-16912\" class=\"wp-caption-text\">Fig 6: Search Results<\/figcaption><\/figure>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><strong>Step 3:<\/strong><\/h3>\n<ul>\n<li>Import the uploaded data into fusion as lookup data.<\/li>\n<li>Go to Setup and Maintenance.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16911\" aria-describedby=\"caption-attachment-16911\" style=\"width: 699px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16911\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-7-227x300.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 7\" width=\"699\" height=\"924\" \/><figcaption id=\"caption-attachment-16911\" class=\"wp-caption-text\">Fig 7: Setup &amp; Maintenance<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Click on Search Results.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16910\" aria-describedby=\"caption-attachment-16910\" style=\"width: 724px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16910\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-8.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 8\" width=\"724\" height=\"655\" \/><figcaption id=\"caption-attachment-16910\" class=\"wp-caption-text\">Fig 8: Search Capability<\/figcaption><\/figure>\n<div id=\"attachment_2722\" class=\"wp-caption alignnone\">\n<p id=\"caption-attachment-2722\" class=\"wp-caption-text\">\n<\/div>\n<ul>\n<li>Search for Manage common lookups and Select import from the Actions menu.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16909\" aria-describedby=\"caption-attachment-16909\" style=\"width: 740px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16909\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-9-300x189.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 9\" width=\"740\" height=\"466\" \/><figcaption id=\"caption-attachment-16909\" class=\"wp-caption-text\">Fig 9: Import Lookup<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>In Import Standard Lookups, select the Account where you imported the files (setup\/functionalSetupManger\/import).<\/li>\n<li>Give the Full name of the file to be imported, including the csv extension (For example Lookup_type.csv) and click on upload.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16908\" aria-describedby=\"caption-attachment-16908\" style=\"width: 773px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16908\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-10-300x153.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 10\" width=\"773\" height=\"394\" \/><figcaption id=\"caption-attachment-16908\" class=\"wp-caption-text\">Fig 10: Upload lookup values in oracle fusion<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>You can view the progress of the process and you will able to download the process log file when the process has completed.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16907\" aria-describedby=\"caption-attachment-16907\" style=\"width: 773px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16907\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-11.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 11\" width=\"773\" height=\"546\" \/><figcaption id=\"caption-attachment-16907\" class=\"wp-caption-text\">Fig 11: Success Upload lookup values<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Navigate to the lookup field in the user interface to verify that your lookup values imported as expected.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16906\" aria-describedby=\"caption-attachment-16906\" style=\"width: 766px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16906\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Bulk-Import-of-Lookup-TypesCodes-Using-File-Based-Loader-in-HCM-Cloud-12-300x87.png\" alt=\"Bulk Import of Lookup TypesCodes Using File Based Loader in HCM Cloud - 12\" width=\"766\" height=\"222\" \/><figcaption id=\"caption-attachment-16906\" class=\"wp-caption-text\">Fig 12: Imported lookup Data<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h2><strong>Points to remember:<\/strong><\/h2>\n<p>Create separate files for\u00a0Lookup Types\u00a0and\u00a0Lookup Codes. Files should be of UTF-8 encoding (\u201cUTF-8 without BOM\u201d. Notepad ++ had the feature to convert the encoding)<\/p>\n<h2><\/h2>\n<h2><strong>Business Benefits:<\/strong><\/h2>\n<ul>\n<li><b><span data-contrast=\"none\">Time and Effort Saving:<\/span><\/b><span data-contrast=\"none\">\u00a0Minimized effort in data migration.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559738&quot;:0,&quot;335559739&quot;:150,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"none\">Repetition Ease:<\/span><\/b><span data-contrast=\"none\">\u00a0Facilitated deployment across instances.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"none\">Speed and Accuracy:<\/span><\/b><span data-contrast=\"none\">\u00a0Swift, error-free data migration.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559738&quot;:0,&quot;335559739&quot;:150,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h2><b><span data-contrast=\"none\">The Bottom Line:<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559738&quot;:0,&quot;335559739&quot;:150,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"none\">Oracle Fusion\u2019s File Based Loader (FBL) streamlines bulk import of lookup types and codes in HCM Cloud, reducing errors tied to manual entry during migration. Consultants follow steps to prep files, upload to UCM Server, ensuring data accuracy and consistency across instances. FBL adoption empowers efficient data migration, maintaining HCM Cloud integrity.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559738&quot;:0,&quot;335559739&quot;:150,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559738&quot;:0,&quot;335559739&quot;:150,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><strong>Author: <\/strong>Mohamed Thowfik Rahman, Oracle Cloud Consultant | Kovaion<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Entering all the values of the lookup type and code into the application manually will consume a significant effort during data migration. It may result in wrong data entry which could lead to other application issues. Apart from this, the data entry activity has to be repeated in other instances of applications. In Oracle fusion\u2019s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":22276,"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-32019","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\/32019","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=32019"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/32019\/revisions"}],"predecessor-version":[{"id":32020,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/32019\/revisions\/32020"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/22276"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=32019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=32019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=32019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}