tag:blogger.com,1999:blog-86480354787875571122024-03-23T05:28:06.593-07:00Oracle Apps SolutionsAbhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.comBlogger163125tag:blogger.com,1999:blog-8648035478787557112.post-4922726094508293782023-12-02T06:39:00.000-08:002023-12-02T06:39:06.514-08:00Update/Correct Payroll Relationship Number - HCM<p><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="background-color: white;">A Payroll relationship gets created automatically when you hire an employee or create other types of person records, such as candidates and pending workers. A payroll relationship is an association between a person and a payroll statutory unit.</span></span></p><p><span style="background-color: white;"><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;">It is the same number as person number or assignment number(s) but few cases you would find where it doesn't matches or not in sync with person number.</span></span></p><p><span style="background-color: white;"><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;">How we can correct this?</span></span></p><span style="background-color: white; color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;">There are two options:</span><br /><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;">1></span><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;"> Prerequisite: "Person Number Generation Method" must be set to Manual</span><br /><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;"> (Setup & Maintenance > "Manage Enterprise HCM Information")</span><br /><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;"> > Now search the affected Employee from person management</span><br /><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;"> > Go to Manage Person, scroll down and edit the 'Person Number' and save/submit.</span><br /><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;"> > Re-search the employee and numbers should be in sync </span><br /><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;"><br /></span><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;">2.) If there are more than one employees affected or above option doesn't work run the 'Payroll Relationship Number Upgrade' process</span><div><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;"><br /></span><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;"> > First create a (Payroll > Object Groups) Payroll relationship Group with affected payroll relationship numbers</span><br /><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;"> > Then Payroll > Submit a Flow -> 'Run feature upgrade</span><span style="background-color: white;"><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;"> ' and select </span></span><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;">'Payroll Relationship Number Upgrade' process</span><br /><p style="text-align: left;"><span style="background-color: white;"><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;"> >> </span></span><span style="color: #1a1816; font-family: Oracle Sans, -apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Helvetica, Arial, sans-serif;">Provide the above crated Payroll Relationship Group as free text in Additional Information field</span></p><p style="text-align: left;"><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif;">It should solve the issue.</span></p></div>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-85087573644598530682023-10-05T09:10:00.001-07:002023-10-05T09:14:41.512-07:00Amend Notification Subject LinesOne of my clients had a requirement to change the notification subject line <div><br /></div><div>Ex: For 'Annual Leave' the original subject line is</div><div>'Approval of Annual Leave Request for XXX YYY from 2022-07-10 to 2022-09-10'</div><div><br /></div><div>They want this to be changed as 'Annual Leave is Submitted Successfully for XXX YYY'</div><div><br /></div><div>Lets see how we can achieve this</div><div><br /></div><div>You can do this from BPM Task Configuration</div><div><br /></div><div>Prerequisite: You should have '<span face="arial, sans-serif" style="background-color: white; color: #4d5156; font-size: 14px;">Application Implementation Consultant' role </span></div><div><span face="arial, sans-serif" style="background-color: white; color: #4d5156; font-size: 14px;"><br /></span></div><div><span face="arial, sans-serif" style="background-color: white; color: #4d5156; font-size: 14px;">Now go to BPM Worklist, there are two ways to go there </span></div><div><span face="arial, sans-serif" style="background-color: white; color: #4d5156; font-size: 14px;"><br /></span></div><div><span face="arial, sans-serif" style="background-color: white; color: #4d5156; font-size: 14px;">1> Click on the bell icon on the home page and click on 'More Details'</span></div><div><span face="arial, sans-serif" style="background-color: white; color: #4d5156; font-size: 14px;"> OR</span></div><div><span style="background-color: white;"><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">2> Setup and Maintenance > </span></span></span><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">Manage Task Configurations for Human Capital Management</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">Now go to 'Administration' > Task Configuration</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">Since this is Absence Approval so search for AbsencesApprovalTask</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhklhuc16hfx3L9nhCBCO_4fMpQkOS_qf8voUO_xTYmiHsuJE1vzJyKqcpqMsNRfNYAzIlGadlCAAMe27_-yZITxXIyfNhjATf4mgB1o-PBUVxKqB3hOQB0uRImmcGxHu7ysczL3xQEfS6V7QVm-5MgCXEvnYUi48k5hJOSRWfE49Q6q4jpjKAU-DtOSrQ" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1215" data-original-width="3682" height="147" src="https://blogger.googleusercontent.com/img/a/AVvXsEhklhuc16hfx3L9nhCBCO_4fMpQkOS_qf8voUO_xTYmiHsuJE1vzJyKqcpqMsNRfNYAzIlGadlCAAMe27_-yZITxXIyfNhjATf4mgB1o-PBUVxKqB3hOQB0uRImmcGxHu7ysczL3xQEfS6V7QVm-5MgCXEvnYUi48k5hJOSRWfE49Q6q4jpjKAU-DtOSrQ=w443-h147" width="443" /></a></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div>Now click on Edit pencil and then on Globe icon at the end of the Title</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhiNWe6m6mZvvGjIJKVcpG8VnRdSbiUbxTqIYpXDONkNXrSw88rUZe06vPnhKppQMfOVVbfm5XqTIW1LEpX9XTpPN_7Ynm9no1hVFp9oC25uqlyC3MTb9OSmV7sgT3-yMBvm0z8aZ9JjtQMmZC6ZLVrd5m-wjDGckRRh320dknTvbzNwSXe-alarS4_ApA" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1261" data-original-width="2838" height="142" src="https://blogger.googleusercontent.com/img/a/AVvXsEhiNWe6m6mZvvGjIJKVcpG8VnRdSbiUbxTqIYpXDONkNXrSw88rUZe06vPnhKppQMfOVVbfm5XqTIW1LEpX9XTpPN_7Ynm9no1hVFp9oC25uqlyC3MTb9OSmV7sgT3-yMBvm0z8aZ9JjtQMmZC6ZLVrd5m-wjDGckRRh320dknTvbzNwSXe-alarS4_ApA=w446-h142" width="446" /></a></div><br /><br /></div><br /><br />Now, keep the language English and give any key as 'DEMO_ABSENCE_TITLE' and in the expression provide the title you want Ex: {0} is submitted successfully for {1}</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">{0} is the Absence Type and {1} is the person Name</span></span></div><div><br /></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhxEHU32fZDo0FiMEWDrNS4Q1zGNtdXflxzRztIukorZbLToDsc6xnlJFS5YS86emDaT6PsxFD6h73uNYxV4qHPxgwHh7pn5qsOQqwzSfZFHyl5sE3FnssXYogdOOFvpADJvlSkpxxE0-JofZ12Vf-ECriPsfp5k5E252llD1DJx13GxiEGCNN65J0pNrM" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="700" data-original-width="2468" height="91" src="https://blogger.googleusercontent.com/img/a/AVvXsEhxEHU32fZDo0FiMEWDrNS4Q1zGNtdXflxzRztIukorZbLToDsc6xnlJFS5YS86emDaT6PsxFD6h73uNYxV4qHPxgwHh7pn5qsOQqwzSfZFHyl5sE3FnssXYogdOOFvpADJvlSkpxxE0-JofZ12Vf-ECriPsfp5k5E252llD1DJx13GxiEGCNN65J0pNrM=w436-h91" width="436" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div></span></span><span face="arial, sans-serif" style="color: #4d5156; font-size: 14px;">Click on the 'Arguments' pencil icon and provide arguments for token {0} and {1}</span></div><div><span face="arial, sans-serif" style="color: #4d5156; font-size: 14px;"><br /></span></div><div><br /></div><div><span face="arial, sans-serif" style="color: #4d5156;"><div class="separator" style="clear: both; font-size: 14px; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhlQWU3cMBBbpE3gsm9PGMkdRhYGj_iNYLRVMUdaTuMF8pz8cLauJgZu916u5QEfhfqEFS0_GBBmmd7Tb0rdiiD08nV2txujNsB31Hq-0AVouRUib0HAgeYi4f2REi-mtQFYVkdWNfMr5Saajm9gEz54PwDhIVplAH_03g-BKjXJ9UyuAAr2EhdlKi6ax8" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="958" data-original-width="2465" height="124" src="https://blogger.googleusercontent.com/img/a/AVvXsEhlQWU3cMBBbpE3gsm9PGMkdRhYGj_iNYLRVMUdaTuMF8pz8cLauJgZu916u5QEfhfqEFS0_GBBmmd7Tb0rdiiD08nV2txujNsB31Hq-0AVouRUib0HAgeYi4f2REi-mtQFYVkdWNfMr5Saajm9gEz54PwDhIVplAH_03g-BKjXJ9UyuAAr2EhdlKi6ax8=w408-h124" width="408" /></a></div><br /><br /></div><span style="font-size: 14px;">Click on the expression builder icon</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">Now expand the Variables for task:payload > AbsenceApprovalrequest > AbsenceType </span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">and <b>Insert into Expression </b></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">It should be /task:task/task:payload/ns0:AbsencesApprovalsRequest/ns0:AbsenceType</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"> </span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEi8lC3OZkIMEKNlMHpY_IFYIc7XY1EpkqcEvsVzXNDYXUzJcZC-WhJbLVM4EBzo3Nov9r75V9e-0iJrLqvPATZa0moq9Tdwli2b4v5Xy9uFmONZEvw7vyhPULGqsVOSEnXwcahRjpf8LsNs14x1HtxkqOK7mJRoxe_tzkOBNoPj2gZ2WnEdN-0RCwrZyxY" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1765" data-original-width="2391" height="236" src="https://blogger.googleusercontent.com/img/a/AVvXsEi8lC3OZkIMEKNlMHpY_IFYIc7XY1EpkqcEvsVzXNDYXUzJcZC-WhJbLVM4EBzo3Nov9r75V9e-0iJrLqvPATZa0moq9Tdwli2b4v5Xy9uFmONZEvw7vyhPULGqsVOSEnXwcahRjpf8LsNs14x1HtxkqOK7mJRoxe_tzkOBNoPj2gZ2WnEdN-0RCwrZyxY=w414-h236" width="414" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div>Same for the token {1}</span></span></div><div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">task:payload > AbsenceApprovalrequest > PersonName</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">and <b>Insert into Expression </b></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">It should be /task:task/task:payload/ns0:AbsencesApprovalsRequest/ns0:PersonName</span></span></div></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;">Click on OK</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgEJIG3s2Aa3YGlGcsOa2uVx3eglXHNdYA-yXHRz7heoZHcbhIReQolg_QQFNbMO-W8yP5LUsM_mKx03mY_UyVeF3kVc134cxCeb3xqPPJKZiHZqnbKQNw5c4yaQQJQkkj1FiWWimeTU4zA_qtgiwZ0WtszQb-K-G6vcu55veu-FSoAbFURmwazH39EXnc" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1391" data-original-width="2451" height="182" src="https://blogger.googleusercontent.com/img/a/AVvXsEgEJIG3s2Aa3YGlGcsOa2uVx3eglXHNdYA-yXHRz7heoZHcbhIReQolg_QQFNbMO-W8yP5LUsM_mKx03mY_UyVeF3kVc134cxCeb3xqPPJKZiHZqnbKQNw5c4yaQQJQkkj1FiWWimeTU4zA_qtgiwZ0WtszQb-K-G6vcu55veu-FSoAbFURmwazH39EXnc=w412-h182" width="412" /></a></div><br />Click on OK</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjg-soSqspU3Lw1D-yHUZLzFmpR4InKIeMlF3hcAgUjpToneE0a0ZNueu_Nk0sg28KxO5Qe669dQScxdtV4PTGH3vp6Gtz6nn8aacA0c5-YIZvbnXo-V_iPAmxgfDk8nV--dnyK0X4Z7tqx-B5Zix2-nILxelBvuhBR0vBjrMkwCGgywFBtGJcnVil7Oxk" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1803" data-original-width="2218" height="240" src="https://blogger.googleusercontent.com/img/a/AVvXsEjg-soSqspU3Lw1D-yHUZLzFmpR4InKIeMlF3hcAgUjpToneE0a0ZNueu_Nk0sg28KxO5Qe669dQScxdtV4PTGH3vp6Gtz6nn8aacA0c5-YIZvbnXo-V_iPAmxgfDk8nV--dnyK0X4Z7tqx-B5Zix2-nILxelBvuhBR0vBjrMkwCGgywFBtGJcnVil7Oxk=w423-h240" width="423" /></a></div><br /><br /></span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><br /></div>And then Save, Commit and OK</span></span></div><div><span face="arial, sans-serif" style="color: #4d5156;"><span style="font-size: 14px;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEitJGM9v7pOthRapgPoRCxYKUyaa2lBw36IBIdlbAYjXtWjQu8ZEXRi2nMnJJRn3w6qYPcu1UmiGNXqAgKuulQ7D3AL2IPSJcsjLSHvzEA5VdRT0QRx3ZSoJIjfy6_rSzxQWlwmXrzbo30Z0highhM2W6FeAb3Vcab60dYgHIo4D3GwkkBt_o4Tb-3ceBA" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1262" data-original-width="2509" height="161" src="https://blogger.googleusercontent.com/img/a/AVvXsEitJGM9v7pOthRapgPoRCxYKUyaa2lBw36IBIdlbAYjXtWjQu8ZEXRi2nMnJJRn3w6qYPcu1UmiGNXqAgKuulQ7D3AL2IPSJcsjLSHvzEA5VdRT0QRx3ZSoJIjfy6_rSzxQWlwmXrzbo30Z0highhM2W6FeAb3Vcab60dYgHIo4D3GwkkBt_o4Tb-3ceBA=w425-h161" width="425" /></a></div><br /><br /></div><br />And job done! :)<br /><br /></span></span></div>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-48697863814279754992023-10-04T02:27:00.001-07:002023-10-04T02:27:17.534-07:00An internal assertion test couldn't be completed at location ReportUtils.callJavaClass5<p> While running the 'Make EFT Payment' process for a terminated employee I have received the below error</p><p><b>Error</b> An internal assertion test couldn't be completed at location ReportUtils.callJavaClass5</p><p><b>Error</b> The bank account associated to this payment has a start date after the payment process date.</p><p>Issue was related to the personal payment method with that particular employee, there were two payment methods active for the payment period, please check if that is the case. After end dating one of those, EFT process went fine. </p><p>It does happen when you create a new payment method and instead of doing "Correction" to the old one you do the "Update", which creates a date effective records.</p><p><b>Other solution</b> is, you can set the </p><p>"<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Historic Payment Removes the validation to look for active banks as of the process date in payments processes.</span>"</p><p>flag to 'Y' in the 'Payroll Process Configuration' for Default group, by default it is No. By the definition it will bypass the validation for inactive banks.</p><p>Navigation: My Client Group -> Show More -> Payroll Process Configuration under 'Payroll' section</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgHv_oXxAgtu5XM1FA5j2Sbj9NnLOHF5xYu9rqDqRi_k4XqPnD298-hr3J_AshksBglAAlW1eOaKEC0-J3sI1bTD1Tn978j3e13754_Nvk0eoO4PEeUCAPpa618OL2OeYwZNp2L6MzSI-YpFdmTF-anK93AGi5XjiZ6i4SDSq-zndFXYJOs_yufja0fm9M" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="632" data-original-width="3538" height="57" src="https://blogger.googleusercontent.com/img/a/AVvXsEgHv_oXxAgtu5XM1FA5j2Sbj9NnLOHF5xYu9rqDqRi_k4XqPnD298-hr3J_AshksBglAAlW1eOaKEC0-J3sI1bTD1Tn978j3e13754_Nvk0eoO4PEeUCAPpa618OL2OeYwZNp2L6MzSI-YpFdmTF-anK93AGi5XjiZ6i4SDSq-zndFXYJOs_yufja0fm9M=w440-h57" width="440" /></a></div><br /><br /><p></p><p><br /></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-10970187611440614392023-09-26T04:52:00.003-07:002023-09-26T04:52:52.065-07:00FF: Exception in Trans to Main Mapping<p>Did you encounter the below error with fast formula? </p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgxB0pK24mZbhNBm5ncrilQW6GOjzEnYcPelvIh53oC-tcG_BsrGV_9JlVSihkRvhYReCTW98qu-9_jmlUpGi-sP6wmj-luOsNsz_IEpNLvwJYEFRijEkE0t-1bnjrS6hB8ZYuqT04dt_Vfsm9mWMfYUUoLFSm83DLZWrUNOHMhkVdM4F43_Uaz_QPW2e4" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="695" data-original-width="1662" height="134" src="https://blogger.googleusercontent.com/img/a/AVvXsEgxB0pK24mZbhNBm5ncrilQW6GOjzEnYcPelvIh53oC-tcG_BsrGV_9JlVSihkRvhYReCTW98qu-9_jmlUpGi-sP6wmj-luOsNsz_IEpNLvwJYEFRijEkE0t-1bnjrS6hB8ZYuqT04dt_Vfsm9mWMfYUUoLFSm83DLZWrUNOHMhkVdM4F43_Uaz_QPW2e4" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div>If yes, this means your formula body is not properly defined, please handle the no error section properly<p></p><p>-----------------------------------------------------</p><p><b>/*I assume your 1st part is working fine :)*/</b></p><p>IF <condition> </p><p>THEN</p><p>(</p><p><Expression></p><p>)</p><p><b>ELSE</b></p><p><b>(</b></p><p><b>VALID = 'Y'</b></p><p></p><p><b>RETURN VALID</b></p><p><b>)</b></p><p><b>----------------------------------------------------------</b></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com1tag:blogger.com,1999:blog-8648035478787557112.post-47348752071991053522021-11-25T04:06:00.004-08:002021-11-25T04:12:28.865-08:00Create an Inbound Interface process using HCM Extract - Automated process to upload an HDL file (Part-2)<p> We will be creating only a dummy HCM extract here just to use the 'Initiate HCM Data Loader' feature as data extraction and transformation we are already doing in our BI report.</p><p>> My Client Group > Data Exchange > HCM Extracts > Extract Definitions </p><p>Use the + sign to create a new extract of type 'Inbound Interface'</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSRxAB0TNbgqBcJoQ38aIYRlomKbvEIJKhba_5TrTqYMBC6BJH-p5bhEsFVpUgiDWo_GIY5csuHBHgXiJOf3GXPKZodXLdu_tI6NVtvuk4qTwUHyCkNCH3lwGxrF1O-04klCEfIEmofRA/s2803/EXT+1.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1067" data-original-width="2803" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSRxAB0TNbgqBcJoQ38aIYRlomKbvEIJKhba_5TrTqYMBC6BJH-p5bhEsFVpUgiDWo_GIY5csuHBHgXiJOf3GXPKZodXLdu_tI6NVtvuk4qTwUHyCkNCH3lwGxrF1O-04klCEfIEmofRA/w400-h153/EXT+1.JPG" width="400" /></a></div><div><br /></div>In the Parameters section add a parameter called Auto Load (Tag Name = Auto_Load) with Data Type as "Text" with Default Value as "Y". <div>>> In new releases this parameter is already there but hidden. Click on 'Show hidden parameters' and update the Default Value to "Y" and Save<div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXNQBQJvycTmtuCXhj6besV7UUHPUVZFHiVhYOmz9czDZ80KCqpWV4jo7DEfzqQFUzNIAq2NZ2QfRGeGFWLd5OqSl8lJ8DxwqZzo9ds5CZWmqIwEJT_lgCM84YThp2-9pkU4u0Lq0a82s/s2722/EXT+2.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1156" data-original-width="2722" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXNQBQJvycTmtuCXhj6besV7UUHPUVZFHiVhYOmz9czDZ80KCqpWV4jo7DEfzqQFUzNIAq2NZ2QfRGeGFWLd5OqSl8lJ8DxwqZzo9ds5CZWmqIwEJT_lgCM84YThp2-9pkU4u0Lq0a82s/w400-h170/EXT+2.JPG" width="400" /></a></div><br /><div><br /><div class="separator" style="clear: both; text-align: left;">For the Data Group I have taken "PER_EXT_ASG_STATUS_DETAILS_UE" as User Entity as it returns very less row count.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXPWx4vYCzm48PKB6tw90YbhHYLjg_yS7ThHiFXzglAZ5xp-WbeJIL1s_nd9t1BGWHfVoXesLLukwvRs3HwaZ7Lip0eZ9QoUzpCQ-Z6dkq5e-53kvyLuE7_rsYPunTIZn_7HH2L3spVNc/s2812/EXT+3.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="802" data-original-width="2812" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXPWx4vYCzm48PKB6tw90YbhHYLjg_yS7ThHiFXzglAZ5xp-WbeJIL1s_nd9t1BGWHfVoXesLLukwvRs3HwaZ7Lip0eZ9QoUzpCQ-Z6dkq5e-53kvyLuE7_rsYPunTIZn_7HH2L3spVNc/w400-h114/EXT+3.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: left;"><div class="separator" style="clear: both;"><b>Save</b></div><div class="separator" style="clear: both;">In Data group Filter criteria, I have put condition as "1=2" so that it doesn't return any data set</div><div class="separator" style="clear: both;">Edit > Put the condition 1=2 and 'Add Constant' and ‘Ok’</div><div class="separator" style="clear: both;"><b>Save</b></div></div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimxmcAoPzKU4lCYR9g-5QZ4sqIJDaoYySmfMivT_uL_ZlR0hPTO7evmTX1Q4IZj60gXmYE_Vyhhpvv4yPSWn6CbWQeI8o10mg2kw37TjO7JslQBY4vZzGA0ShCf5sT5HEVb_34HojsyJo/s2813/EXT+4.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1072" data-original-width="2813" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimxmcAoPzKU4lCYR9g-5QZ4sqIJDaoYySmfMivT_uL_ZlR0hPTO7evmTX1Q4IZj60gXmYE_Vyhhpvv4yPSWn6CbWQeI8o10mg2kw37TjO7JslQBY4vZzGA0ShCf5sT5HEVb_34HojsyJo/w400-h153/EXT+4.JPG" width="400" /></a></div><div>In the Data Group create a Data Record and then a Dummy Attribute called "Dummy Field" with Data Type as "Text", Type "String" and string value has been passed as "Demo"</div><div><b>Dummy Record</b></div></div></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifM_-kkTN3LEa6u9wgVROkETOLeSJ0PiacqmBWE9W9MRYSOCDYMK6CvEMtkGPurcaUPzFqX1tJOsdoGOvdMbXmxLSL3Zmsj1oorAPtaF-EoI5Hdi2b0g84g4xckHuUMC3Zeh6UccXtxkM/s2804/EXT+5.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1051" data-original-width="2804" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifM_-kkTN3LEa6u9wgVROkETOLeSJ0PiacqmBWE9W9MRYSOCDYMK6CvEMtkGPurcaUPzFqX1tJOsdoGOvdMbXmxLSL3Zmsj1oorAPtaF-EoI5Hdi2b0g84g4xckHuUMC3Zeh6UccXtxkM/w400-h150/EXT+5.JPG" width="400" /></a></div>Save, It will generate a fast formula and then create a dummy attribute</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihF3blrTOpn9Uv2-eKBLXvMbxtu9dxOGG1g4Ui1z4ETLGcuDqud69fyS__EVQpCkZYqC7ITYy0JAh193PDfjpLuckoZpYzpMSM33m712tA2XiQycQ3CvMzJIik431noa4oI5YnrsLFv6s/s2680/EXT+6.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1173" data-original-width="2680" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihF3blrTOpn9Uv2-eKBLXvMbxtu9dxOGG1g4Ui1z4ETLGcuDqud69fyS__EVQpCkZYqC7ITYy0JAh193PDfjpLuckoZpYzpMSM33m712tA2XiQycQ3CvMzJIik431noa4oI5YnrsLFv6s/w400-h175/EXT+6.JPG" width="400" /></a></div><br /><div><div>Now for the Extract Delivery Option, you can pass the details as below :</div><div> Start Date : 01/01/1901</div><div> End Date : 12/31/4712</div><div> Delivery Option Name : HDLDemoOutput</div><div> Output Type : Text</div><div> Report : <pass the BI Report path here ; </div><div> Ex: /Custom/UoE Data Migration/UserCatHDLReport/HDLCallDemoRpt.xdo</div><div> Template Name : <pass the eText template name here;</div><div> Ex: HDLCallDemo</div><div> Output Name : HDLCallDemoOpt</div><div> Delivery Type : Inbound Interface</div><div> Required/Bursting Node : ticked</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeUaG9Yn-Pttl2qpe-4I3P4vDxJcZ4u4zBAjDK9FFp35tgy-beNJ_eGW3f0XVNH4UBLj1f71Xnw-PdJqae0M2zVaVaYhcSSzuLFEBEixrOFSIHgtmtPAhXBQNF-0wBLd8Dn1KUswnXcZU/s2793/EXT+7.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="813" data-original-width="2793" height="116" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeUaG9Yn-Pttl2qpe-4I3P4vDxJcZ4u4zBAjDK9FFp35tgy-beNJ_eGW3f0XVNH4UBLj1f71Xnw-PdJqae0M2zVaVaYhcSSzuLFEBEixrOFSIHgtmtPAhXBQNF-0wBLd8Dn1KUswnXcZU/w400-h116/EXT+7.JPG" width="400" /></a></div><br /><div>In the "Additional Details" section please pass the details as below :<br /></div><div> Encryption Mode : None</div><div> Override File Extension : .dat</div><div> Run Time File Name : User</div><div> <b>Integration Name</b> : UserCategoryUpdate</div><div> Integration Type : Data Loader</div><div> Integration Parameters : blank</div><div> Key : blank</div><div> Locale : blank</div><div> Time Zone : blank</div><div> Compress : Yes Compress</div><div> Compressed Delivery Group: UserCatUpdate.zip</div><div><br /></div><div><b>** Integration Name</b> : 1st 8 characters will be used in the content ID name during the HDL call for this extract.</div><div>It starts with DL_<1st 8 characters from Integration Name in upper case>_ProcessID </div><div> EX: DL_USERCATE_1092672</div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt8_QqZkP9xcqBo4rTa1P8bBFFQfPCrZhFjpROzdDAuUR7TTb853TYFqcaJ1NLE845YiG5T9fRSWsNY3g6MSITlk0hqMQmxJWGQTE2fzivIcNE9d1V-IomQ72R5O54AMoI5I-Vxwby1yc/s1655/EXT+8.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1404" data-original-width="1655" height="339" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt8_QqZkP9xcqBo4rTa1P8bBFFQfPCrZhFjpROzdDAuUR7TTb853TYFqcaJ1NLE845YiG5T9fRSWsNY3g6MSITlk0hqMQmxJWGQTE2fzivIcNE9d1V-IomQ72R5O54AMoI5I-Vxwby1yc/w400-h339/EXT+8.JPG" width="400" /></a></div><div><b>Save</b></div><div><b><br /></b></div><div>Now navigate to Home --> My Clients Groups > Data Exchange > HCM Extracts> Refine Extracts</div><div>Search for the dummy HCM Extract which has been created. Select the HCM Extract and click on the "Edit" button.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4l8EZFrLLOL5kffMT9vSghOzsw7iPZXb9uPZldKj1m1oEBLvxObF5M5xXb7Q6k9Rpkw9o1T4fgxef8NBnMr04ETbWSBGafzFRxQ1ULdZeYg4ptEXH7pNvfZvxvNdd07S5S5JKzJSy2KU/s2349/EXT+9.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="870" data-original-width="2349" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4l8EZFrLLOL5kffMT9vSghOzsw7iPZXb9uPZldKj1m1oEBLvxObF5M5xXb7Q6k9Rpkw9o1T4fgxef8NBnMr04ETbWSBGafzFRxQ1ULdZeYg4ptEXH7pNvfZvxvNdd07S5S5JKzJSy2KU/w400-h149/EXT+9.JPG" width="400" /></a></div><br /><div><div>Once the HCM Extract is opened, in the "Tasks" tab, under Flow Task the HCM Extract name will be present. Now click on the "Actions" button and select the option "Select and Add".</div></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZMWD3FNd7ocdusxIg4t5Ylkc0V8_hcD5l8VIpD08pozdLkOrQd0NUzOe_QNKP8BMmZK4ExgZeCm4f_mTIZ5oFEHNsewIDbJ8Rq_Iv8rPIdpjJwx79ZBxn8K925Ci47sX4dtfmvWl2Dkc/s2307/Ext+10.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="749" data-original-width="2307" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZMWD3FNd7ocdusxIg4t5Ylkc0V8_hcD5l8VIpD08pozdLkOrQd0NUzOe_QNKP8BMmZK4ExgZeCm4f_mTIZ5oFEHNsewIDbJ8Rq_Iv8rPIdpjJwx79ZBxn8K925Ci47sX4dtfmvWl2Dkc/w400-h130/Ext+10.JPG" width="400" /></a></div><br /><div>A search popup will appear and search the task "Initiate HCM Data Loader" (Generate HCM Data Loader file and optionally perform a data load). Now select the task and click on the "Done" button.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOR1hUcwPFsAsQY_hqUQ1trkiyQRRbYxiXmCHtZjyCXmBELPgr5Shp_SdEPZaNhtn2Alx18p2U5G7_POcj9HmYrMzVRH4NvyaWlPKVQG7XtANUSAFszg3HM4uf42U_nQs5f_s9Hmv-z3I/s2330/Ext+11.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="918" data-original-width="2330" height="158" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOR1hUcwPFsAsQY_hqUQ1trkiyQRRbYxiXmCHtZjyCXmBELPgr5Shp_SdEPZaNhtn2Alx18p2U5G7_POcj9HmYrMzVRH4NvyaWlPKVQG7XtANUSAFszg3HM4uf42U_nQs5f_s9Hmv-z3I/w400-h158/Ext+11.JPG" width="400" /></a></div><div><div><b>Save</b></div><div>Now select the task "Initiate HCM Data Loader" click on the "Go to Task" button.</div><div> 2 options will be there :</div><div> a> Data Loader Archive Action</div><div> b> Data Loader Configuration</div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZxXbrpF7s2nF4qtnzzZMCyettjmcEWaxn5rHcM9BiWB402ihj5Nnq-Vw_bP44d5OzXXDT-yX5tF8uxDUBcMbkr4HwzDmt3lZZRO0x8Abq9u6a0HSpEuWOJZoTabbyYAe7q06er5kpj9g/s2332/Ext+12.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="569" data-original-width="2332" height="98" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZxXbrpF7s2nF4qtnzzZMCyettjmcEWaxn5rHcM9BiWB402ihj5Nnq-Vw_bP44d5OzXXDT-yX5tF8uxDUBcMbkr4HwzDmt3lZZRO0x8Abq9u6a0HSpEuWOJZoTabbyYAe7q06er5kpj9g/w400-h98/Ext+12.JPG" width="400" /></a></div><br /><div><div>Select the 1st option "Data Loader Archive Action".Click on the "Edit" button.</div><div>In the "Parameter Basis" dropdown, select the option "Bind to Flow Task".</div><div>In the "Basis Value" dropdown, select the option "Extract Name , Submit , Payroll Process"</div><div> Ex: HDLCallDemo, Submit, Payroll Process</div><div><br /></div><div>Now select the 2nd option "Data Loader Configuration". Click on the "Edit" button.</div><div>In the "Parameter Basis" dropdown, select the option "Constant Bind".</div><div>In the "Basis Value" multiline text box, please provide the below details : ImportMaximumErrors=100,LoadMaximumErrors=100,LoadConcurrentThreads=8,LoadGroupSize=100</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiXZ7lAmriEqeNMdE4rBwOcMVWO0qn6xCMNe00We5rKXZPhukLUm6uR-u1EGY49k6TfbahDwnITSzbxWcP4mo3Mjo5Pm7Uvu5BnuQ_OF8F_kECemZDtLaP3H8YOtXfMHjSLSWxsuwnanI/s2352/Ext+13.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="657" data-original-width="2352" height="111" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiXZ7lAmriEqeNMdE4rBwOcMVWO0qn6xCMNe00We5rKXZPhukLUm6uR-u1EGY49k6TfbahDwnITSzbxWcP4mo3Mjo5Pm7Uvu5BnuQ_OF8F_kECemZDtLaP3H8YOtXfMHjSLSWxsuwnanI/w400-h111/Ext+13.JPG" width="400" /></a></div><br /><div><div>Now click on the <b>"Next"</b> button and then click on the <b>"Submit"</b> button. You might get <b>error</b> to <b>compile the fast formula</b>, please do so. You can ignore the warnings</div><div><br /></div><div>It's time now to submit the HCM Extract and check the Inbound Interface process. </div></div><div><br /></div><div>HCM Extracts > Submit Extract</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_ZCFZFuJofjhcsHqNPlRH7KJG_a428cawRJ5vl5JWU23V7I2QclC4_09vE44UPcOAlpJDdoDSC8wKsN5fhhqmd3P9zzk4pzj7Wd61CMaoI_YCBSekiH4lFrH8zyGq8NmW4rGsxAkaHoI/s2333/Ext+14.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1109" data-original-width="2333" height="190" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_ZCFZFuJofjhcsHqNPlRH7KJG_a428cawRJ5vl5JWU23V7I2QclC4_09vE44UPcOAlpJDdoDSC8wKsN5fhhqmd3P9zzk4pzj7Wd61CMaoI_YCBSekiH4lFrH8zyGq8NmW4rGsxAkaHoI/w400-h190/Ext+14.JPG" width="400" /></a></div><br /><div><div>You can check the </div><div>HCM Data Extracts > View Extract Results</div></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5pxIJeDjO4pq1ieA9AR6-lmvjzw2bh_PXe83blmvj5PvSJ5U4QroW6lLskoXVMybgxU6X851AKHIeEEmj0qc7se_iwsqLSut67F9EE-_jbLQ5L_Mm-qMUAKKWsQI0eFdlB6ogYMMcBXA/s2323/Ext+15.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="914" data-original-width="2323" height="158" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5pxIJeDjO4pq1ieA9AR6-lmvjzw2bh_PXe83blmvj5PvSJ5U4QroW6lLskoXVMybgxU6X851AKHIeEEmj0qc7se_iwsqLSut67F9EE-_jbLQ5L_Mm-qMUAKKWsQI0eFdlB6ogYMMcBXA/w400-h158/Ext+15.JPG" width="400" /></a></div><div><br /></div>In case of any error, you can download the report for the last stuck process from the Instance Details and check for the error details</div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6JiWbigK1xcfnP-Ch-cKUVw6XSJggzlenbkWSel_m-ulCmRcnk-Om7DvnyeELXzETw3f5KqqSztdg187o5hBf01mTWXzdul7a2KKfdJ9icxBQv1o-XJ5rhJh1EDgK9wJ96xYTeejZBQ8/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1435" data-original-width="2048" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6JiWbigK1xcfnP-Ch-cKUVw6XSJggzlenbkWSel_m-ulCmRcnk-Om7DvnyeELXzETw3f5KqqSztdg187o5hBf01mTWXzdul7a2KKfdJ9icxBQv1o-XJ5rhJh1EDgK9wJ96xYTeejZBQ8/w400-h280/image.png" width="400" /></a></div><br /><br /><div><div>Now check if it has triggered the HDL load or not</div><div><br /></div><div>HCM Data Loader > Import and Load Data</div><div><br /></div><div>‘Show filters’ and remove your User Name and search as <b>it won’t be against your User</b>. You can see the Data Set been called, content ID/Data Set Name explanation has given above.</div></div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSpWqADcZmBCT6IIJKPTAgn8NPsxvEjYrWxddHNFFdeWTdYDDnzoHJEqZQ2CPKIzPnVyjW2caJ3-ZzUMjJtr2aFMwe-9AJfvBlio4u8l5cx70mcW6qahPFbbPdVbOdtxp6kJsvKWsVCWA/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="146" data-original-width="975" height="60" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSpWqADcZmBCT6IIJKPTAgn8NPsxvEjYrWxddHNFFdeWTdYDDnzoHJEqZQ2CPKIzPnVyjW2caJ3-ZzUMjJtr2aFMwe-9AJfvBlio4u8l5cx70mcW6qahPFbbPdVbOdtxp6kJsvKWsVCWA/w400-h60/image.png" width="400" /></a></div></div><div><br /></div><div>Import and Load both are successful, so it's all good at the end :)</div></div>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com1tag:blogger.com,1999:blog-8648035478787557112.post-12201557490953678172021-10-28T07:31:00.009-07:002021-11-26T01:45:38.024-08:00Create an Inbound Interface process using HCM Extract - Automated process to upload an HDL file (Part-1)<p>There are requirements where you need to rectify an existing record in fusion. Today's topic is to create an user friendly automated process to extract the existing record, transform it and load the same using HDL on a single click.</p><p>So to achieve this we would be creating an inbound interface process using HCM extract and BI report.</p><p>I am sharing step by step process with a simple example here which I had created with the help of my good friend Pavan.</p><p>Let's start, we would update the User Category of a person record. </p><p>1> Create an BI report to extract and transform the existing data in an HDL format</p><p> > Prepare an extract query</p><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><p style="text-align: left;"></p><p style="margin: 0cm;"></p><p style="margin: 0cm;"><span style="color: black;">SELECT '1' KEY<o:p></o:p></span></p>
<p style="margin: 0cm;"><span style="color: black;"><span style="mso-spacerun: yes;"> </span>,'MERGE|User|'||papf.person_number||'|EMPLOYEE_USER'
mdata<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"> FROM
fusion.per_users pu,<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;">
<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>per_all_people_f
papf<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;">WHERE pu.person_id IS NOT NULL<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"> AND
pu.active_flag = 'Y'<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"> AND
papf.person_id = pu.person_id<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"> AND (
(trunc(sysdate) BETWEEN papf.effective_start_date <o:p></o:p></span></p>
<p style="margin: 0cm;"><span style="color: black;"><span style="mso-spacerun: yes;"> </span>AND papf.effective_end_date)<o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;">
OR papf.effective_start_date >=
trunc(sysdate)) <o:p></o:p></span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"> AND
person_number is not null</span></p>
<p style="-webkit-text-stroke-width: 0px; font-variant-caps: normal; font-variant-ligatures: normal; margin: 0cm; orphans: 2; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"> AND
papf.person_number = '169980'</span></p><p></p><p></p></blockquote><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><p style="text-align: left;"></p><p style="margin: 0cm;">> Now create a Data Model</p><p></p></blockquote><p> > Tools > Reports and Analytics > Browse Catalog > New > Data Model</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGtj8c6_wfk2heVBRizNqA-5iETPyv9F4KgOnh7xIVM3PTlya-3Q0VfktbJFj1rh6Kp2pDh-D-TGMZ_DTdeHjcSBCoAK7cnf2Fhao8SH28qhl0kBF6p-ie2MrOEnQx_pmO91iR_weBh0k/s1889/BI+DM1.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1324" data-original-width="1889" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGtj8c6_wfk2heVBRizNqA-5iETPyv9F4KgOnh7xIVM3PTlya-3Q0VfktbJFj1rh6Kp2pDh-D-TGMZ_DTdeHjcSBCoAK7cnf2Fhao8SH28qhl0kBF6p-ie2MrOEnQx_pmO91iR_weBh0k/w400-h280/BI+DM1.JPG" width="400" /></a></div><br /><p> Data > View > Export > It will create an XML output</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm9yhyphenhyphen2id01CwAJsDMHB2R1S1AqhkYTr3S0OVDdHCO_ZMffNth_Uh-oumWPB0IFSrK9l64YuJVP5pksqW4L5aIINzflKHpZSQttrWit001uopTKVJ6aUKNbzyBGW3XLUzwEgIiW3kZ8hQ/s1892/BI+DM2.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="322" data-original-width="1892" height="68" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm9yhyphenhyphen2id01CwAJsDMHB2R1S1AqhkYTr3S0OVDdHCO_ZMffNth_Uh-oumWPB0IFSrK9l64YuJVP5pksqW4L5aIINzflKHpZSQttrWit001uopTKVJ6aUKNbzyBGW3XLUzwEgIiW3kZ8hQ/w400-h68/BI+DM2.JPG" width="400" /></a></div><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><p style="margin: 0cm;"><br /> > Based on the above XML data now create an RTF template </p></blockquote><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvXvULIKhYYndTTi6RSrRk8nZeKvO_G5JNm4TSaKdSIN60R5drg1YIQw7lwAnll0L1e94lea69xCe7r_pTxrDz3y0gdSHjtwN877f37GhaZqxnw6zxgplIzW76zEFvlrkSrnh7iQ_owQc/s1425/RTF+Template.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1353" data-original-width="1425" height="380" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvXvULIKhYYndTTi6RSrRk8nZeKvO_G5JNm4TSaKdSIN60R5drg1YIQw7lwAnll0L1e94lea69xCe7r_pTxrDz3y0gdSHjtwN877f37GhaZqxnw6zxgplIzW76zEFvlrkSrnh7iQ_owQc/w400-h380/RTF+Template.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><p style="margin: 0cm;"> > Save the DM under Custom folder and create a report using this RTF template, make sure your repot is referring to the correct DM</p></blockquote><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgajShvu1yCcRW-tNIcokwuXzC2Ez9xBuBbBw3DAEysgA-FDpZmlqt5cn9imW5_F1RQiep9RYS1FrKLTlQn8w_3xjB032Nte6xpdfUcvWWxN8NyyVC9JVSymAII3LInnPBlNhfqjyiOZ8k/s1883/BI+Rpt1.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="818" data-original-width="1883" height="174" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgajShvu1yCcRW-tNIcokwuXzC2Ez9xBuBbBw3DAEysgA-FDpZmlqt5cn9imW5_F1RQiep9RYS1FrKLTlQn8w_3xjB032Nte6xpdfUcvWWxN8NyyVC9JVSymAII3LInnPBlNhfqjyiOZ8k/w400-h174/BI+Rpt1.JPG" width="400" /></a></div><p> Please note down the </p><p> Template Name: HDLCallDemo and the </p><p> Report Path:/Custom/HDL Call Demo/UserCatHDLReport/HDLCallDemoRpt.xdo </p><p> > Now create bursting with the report template name</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipeC1vA8LVkyd0Bl397fmByXrXlOR4SqFYbX5_C8Yuedg452SF5m0PePDT76YtTAg0E3iVckM2a0POeQEWCAYvbDBPLD4rDQ_JtUd3g75yvrMKY0U9m4kX9bL36aKXAdBZZM_n9vZWC1M/s1872/BI+DM3.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="928" data-original-width="1872" height="199" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipeC1vA8LVkyd0Bl397fmByXrXlOR4SqFYbX5_C8Yuedg452SF5m0PePDT76YtTAg0E3iVckM2a0POeQEWCAYvbDBPLD4rDQ_JtUd3g75yvrMKY0U9m4kX9bL36aKXAdBZZM_n9vZWC1M/w400-h199/BI+DM3.JPG" width="400" /></a></div><p> > And add an additional permission </p><p> Search for 'Enterprise Scheduler Job Application Identity for HCM' under All and add</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWo3sQoLbYq2Q5MKWxYpThyphenhyphenIa3zCD_w1BMatuyz2JeCRxN1zhyphenhyphenF_ozG3EG_nUEUcPXtxzFzIhZ1vzQ900lK9xVgo4D7oB2XofSNdt4UDSW5uka1_kejfh6-QQBX8bK2v3iPYRAwBiYSG0/s1880/BI+DM+Permission.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1139" data-original-width="1880" height="243" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWo3sQoLbYq2Q5MKWxYpThyphenhyphenIa3zCD_w1BMatuyz2JeCRxN1zhyphenhyphenF_ozG3EG_nUEUcPXtxzFzIhZ1vzQ900lK9xVgo4D7oB2XofSNdt4UDSW5uka1_kejfh6-QQBX8bK2v3iPYRAwBiYSG0/w400-h243/BI+DM+Permission.JPG" width="400" /></a></div><br /><p> > Now check if report is returning the data</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiR3oeAOePULWxM0YNdDKKC7qXm9R9zKSXdvzIPUKdzvSirt9wI7JO3veqgp3QXT0KnaOdsWhfPi39Lz6dnxiLed-aAcB7QJW3Mvz0na_BD_EiMwUIOG-eqybdeBcGp3125_VqUm1GK7YM/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="435" data-original-width="2188" height="80" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiR3oeAOePULWxM0YNdDKKC7qXm9R9zKSXdvzIPUKdzvSirt9wI7JO3veqgp3QXT0KnaOdsWhfPi39Lz6dnxiLed-aAcB7QJW3Mvz0na_BD_EiMwUIOG-eqybdeBcGp3125_VqUm1GK7YM/w400-h80/image.png" width="400" /></a></div><br /><b>2> <a href="https://abhayappssolution.blogspot.com/2021/11/create-inbound-interface-process-using.html" target="_blank"><i><span style="color: #2b00fe;">Lets move on to creating an Extract (Part-2)</span></i></a></b><p></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com1tag:blogger.com,1999:blog-8648035478787557112.post-14410753190761001302021-10-19T08:59:00.001-07:002022-01-13T01:09:06.313-08:00HDL: End date a record/Alter the Effective Start date through HDL<p> If you just pass the EffectiveEndDate field in an HDL load to end date any component, it would create a date track entry. </p><p>To end date a record completely you should also use <b>ReplaceLastEffectiveEndDate</b> field with value 'Y' </p><p>Similarly to alter the EffectiveStartDate, you need to use <b>ReplaceFirstEffectiveStartDate</b> field with value 'Y'</p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-63663871806483060122020-10-28T05:15:00.002-07:002020-10-28T05:15:39.952-07:00HCM: Delete HCM Data Loader Stage Table Data<p>This job purges the HCM Data Loader staging tables for the data sets identified by the parameter values.</p><p>1> Either you can schedule this job </p><p><b>*** </b><u style="font-weight: bold;">Note:</u> When you run the HDL job 1st time it checks whether the 'Delete HCM Data Loader Stage Table Data' job is scheduled or not. If not, then the HDL process creates a schedule for 'Delete HCM Data Loader Stage Table Data' automatically.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKWv6msGOZmj4HGKuOp4y6ZqjzWddTQRsJ0AydcWt1NzZ0avEHiphS7EGp1YQxRP1HzVT_l91tJo3mhdkRMviLT7rLdALywcpzKSlD28DbBKAODdYUnAD0IA7QnUr0xSnCjZYFqOBGaEY/" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="1731" data-original-width="1874" height="369" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKWv6msGOZmj4HGKuOp4y6ZqjzWddTQRsJ0AydcWt1NzZ0avEHiphS7EGp1YQxRP1HzVT_l91tJo3mhdkRMviLT7rLdALywcpzKSlD28DbBKAODdYUnAD0IA7QnUr0xSnCjZYFqOBGaEY/w400-h369/image.png" width="400" /></a></div><br /><br /><p></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p>2> Or when you want to 'Delete' the load entry from the 'Import and Load Data' load list, it calls this job for that data set.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrp90v5MT75ATnb4np0MqTyGudkS0_OtP4sburPUra3TijsYIz74i-sNQXrf_QkAdrTC1Auv4_51gljmBAlMi6LorPpVi4glOYTtcXKiMqi1-tXc2sP3OdHKV1XDo_dehWEcqnBa8L2PY/" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="855" data-original-width="3211" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrp90v5MT75ATnb4np0MqTyGudkS0_OtP4sburPUra3TijsYIz74i-sNQXrf_QkAdrTC1Auv4_51gljmBAlMi6LorPpVi4glOYTtcXKiMqi1-tXc2sP3OdHKV1XDo_dehWEcqnBa8L2PY/w400-h106/image.png" width="400" /></a></div><br /><br /><p></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-47231499355815453672020-09-25T08:58:00.002-07:002020-09-25T08:58:35.760-07:00HCM: The Regular/Temporary and Full Time/Part Time fields default to Regular and Full Time for all workers<p> While migrating the workers we noticed that 'Regular or Temporary' and 'Full Time or Part Time' are getting auto populated with default values 'Regular' and 'Full Time' even though we are not passing the values for these fields.</p><p>These values are coming from the Position assigned and the reason is 'Position Synchronization Configuration'. </p><p><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;">Navigation: Setup and Maintenance > Search > Manage Enterprise HCM Information</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj089RquZhZgj1E7RuTU22oj7z1ei1yGcK_pwJMST2M_a6a-EUMhYY_X2vrTLmRnByeOJJ2eR1dRqdVz7_Tq_bHvuRSUUssDkTwYrPjQ6OUswnVwkPmQCsK3SbIp9oDEiITC536PPTOR6g/s2400/2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1022" data-original-width="2400" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj089RquZhZgj1E7RuTU22oj7z1ei1yGcK_pwJMST2M_a6a-EUMhYY_X2vrTLmRnByeOJJ2eR1dRqdVz7_Tq_bHvuRSUUssDkTwYrPjQ6OUswnVwkPmQCsK3SbIp9oDEiITC536PPTOR6g/w640-h272/2.JPG" width="640" /></a></div><br /><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;"><br /></span><p></p><p>Now the problem was, we were not even providing these values in the position load and system was still populating these fields with default values. This seems to be a bug.</p><p>The <b>workaround</b> is to <b>pass the #null </b>values to<b> FullPartTime & RegularTemporary</b> fileds in the<b> position load</b> file.</p><p>So to rectify the assignment records, you need to update the positions first and then run the ''<b>Synchronize Person Assignments from Position</b>". This process would only work if "<span style="background-color: white; color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif; font-size: 14px;"><b>Allow Override at Assignment</b>' flag is unchecked. If it is also checked unfortunately you have to update the assignment records.</span></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-36935585145895108452020-09-25T08:22:00.002-07:002020-09-25T08:22:15.907-07:00HCM: Default Number, Date & Time Format<p> These default formats are controlled by profile options.</p><p>Navigation: Setup and Maintenance > Manage Administrator Profile Values</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-V7JkTs3V1Eazhw9ENHmgoJhOA7YSCJ06d3PhT8wUd0vFx5gOzKjsvuJDzpC1VRwpjNvUD5wfVCs-022QKh7JfJE73aHZyGeCScJL3yU30NZ36nIRwp_WL-fohZh4ezj9vp_REh4Fiec/s2341/1.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="485" data-original-width="2341" height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-V7JkTs3V1Eazhw9ENHmgoJhOA7YSCJ06d3PhT8wUd0vFx5gOzKjsvuJDzpC1VRwpjNvUD5wfVCs-022QKh7JfJE73aHZyGeCScJL3yU30NZ36nIRwp_WL-fohZh4ezj9vp_REh4Fiec/w640-h132/1.JPG" width="640" /></a></div><br /><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p>Profile Option Code:</p><p style="text-align: justify;">Number: FND_NUMBER_FORMAT</p><p style="text-align: justify;">Date : FND_DATE_FORMAT</p><p style="text-align: justify;">Time : FND_TIME_FORMAT</p><p style="text-align: justify;">You can set these options on Site or User level from the list of values available as required.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsDR4jYcWE69G2HmoXGIrtET6WG14Lfw5WjNBaxxBwjfjZSETHn-oW7L6xRircvMZvko66evtl96oqNpRRKoCjUWYjS1M-ITP1f1N5jIl2lWnu9pn4gHkCPqG3z9llaFZ4V4ZQXEQTZKU/s2362/2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1148" data-original-width="2362" height="311" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsDR4jYcWE69G2HmoXGIrtET6WG14Lfw5WjNBaxxBwjfjZSETHn-oW7L6xRircvMZvko66evtl96oqNpRRKoCjUWYjS1M-ITP1f1N5jIl2lWnu9pn4gHkCPqG3z9llaFZ4V4ZQXEQTZKU/w640-h311/2.JPG" width="640" /></a></div><br /><p style="text-align: justify;"><br /></p><p style="text-align: justify;"><br /></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-33303296437848588532020-09-25T07:46:00.000-07:002020-09-25T07:46:14.006-07:00HCM: Workers Auto Numbering & Duplication Check<p> Auto numbering and person duplicate check options are available under enterprise information. You can amend as required </p><p>Navigation: Setup and Maintenance > Search > Manage Enterprise HCM Information</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnil19ivnZPqJPLiQ7tyl5IcAcfG0bGHUIdFxT27or9a1Gpr9XlsGzrqXWOyp_wOwsiPFg7-yOesf6nhLUvA2mH-NcSbaWP200lJqTdzGsiKDU1kZoSnNL91ruK07MkT4Q9Cz4E-EexBk/s1807/1.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="375" data-original-width="1807" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnil19ivnZPqJPLiQ7tyl5IcAcfG0bGHUIdFxT27or9a1Gpr9XlsGzrqXWOyp_wOwsiPFg7-yOesf6nhLUvA2mH-NcSbaWP200lJqTdzGsiKDU1kZoSnNL91ruK07MkT4Q9Cz4E-EexBk/w640-h133/1.JPG" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: left;">'Enterprise Information' Section</div><div><br /></div><div>Options are self explanatory for both number generation and duplicate check. </div><div>If you want to start the person number from a specific range you can provide that value in the 'Initial Person Number' filed.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh49HnDuzTB945SzboT3CoYOekrBfuXbroKld-FyhkOfuyKl6UfbdFDzF9gIqvOfrkkyAHyV-GZdzOpZ_w8lt0R3QVuAoEaHMWiZCHUxHg13nClrnXM0BBGHdE-8WT51hl7Y0GmUQwfzIs/s2336/2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="763" data-original-width="2336" height="210" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh49HnDuzTB945SzboT3CoYOekrBfuXbroKld-FyhkOfuyKl6UfbdFDzF9gIqvOfrkkyAHyV-GZdzOpZ_w8lt0R3QVuAoEaHMWiZCHUxHg13nClrnXM0BBGHdE-8WT51hl7Y0GmUQwfzIs/w640-h210/2.JPG" width="640" /></a></div><br /><div><br /></div><div><br /></div><div><br /></div><br /><p><br /></p>Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-25404890338695532252020-07-08T09:03:00.002-07:002020-07-08T09:03:59.686-07:00HDL: Extract Failed Lines<div dir="ltr" style="text-align: left;" trbidi="on">
From version 20B there in an extra feature been added in the import load data section which is quite useful.<br />
<br />
You can now generate the load file only for the failed rows from the import and load screen. You just need to enable this option<br />
<br />
Setup and Maintenance > HCM Data Loader > Configure HCM Data Loader<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5U3aytlSGxi8DA-SiPwpsL7hf3PvHm3VCsB9r9RghJ_ZMDiwg5ReNxs9uL_6xUnMgfrE6lJXoGfhIDcqf6moPqmuH9IxPPwLj8BjwiwH88gw0UkK83HOjoueYMwbePoOCmLMuIO45G2I/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="391" data-original-width="1600" height="97" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5U3aytlSGxi8DA-SiPwpsL7hf3PvHm3VCsB9r9RghJ_ZMDiwg5ReNxs9uL_6xUnMgfrE6lJXoGfhIDcqf6moPqmuH9IxPPwLj8BjwiwH88gw0UkK83HOjoueYMwbePoOCmLMuIO45G2I/s400/Capture.PNG" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
It will enable the 'Extract Failed Lines' option on the Import and Load screen<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAfiUDAM1BNaqlJBO7m1JxW71trf7kmcqa8CepH7qISBMBiuRgA213b8BT1FCJsL0SeXr__6JWErL5LH1cri4iBaQZuXxVT_YRRO7HAVxVYMsxHUGbdTUGboBdjA23KqxMkBcbqU1gLJU/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="424" data-original-width="1600" height="105" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAfiUDAM1BNaqlJBO7m1JxW71trf7kmcqa8CepH7qISBMBiuRgA213b8BT1FCJsL0SeXr__6JWErL5LH1cri4iBaQZuXxVT_YRRO7HAVxVYMsxHUGbdTUGboBdjA23KqxMkBcbqU1gLJU/s400/Capture.PNG" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<b>Just to note that</b>, it works quickly if number of failed line are less but it will take time in case of large volume of failed data.</div>
</div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com1tag:blogger.com,1999:blog-8648035478787557112.post-36866413235617348732020-07-08T08:34:00.000-07:002020-07-08T08:34:50.216-07:00Talend: Import/Export Items<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><u><span style="background: white; color: #444444; font-family: "Arial",sans-serif;">Export:</span></u></b><span style="background: white; color: #444444; font-family: "Arial",sans-serif;"> </span>You
can export multiple items from the project onto a directory or as an archive zipped
file<span style="background: white; color: #444444; font-family: "Arial",sans-serif;"><o:p></o:p></span></div>
<br />
<br />
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><!--[endif]--><span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">In the <b>Repository</b>
tree view, select the items you want to export, you can have multiple selections
as well<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirENmc5vGcAD9yoxkYc2WTeplbh9MVWI72IZrZkqQSPe8_ahtKB_daXqqJn7FTXGvGbxW3774drkRHcnNrvza7S3K7Lbk9CIdD-7IA1kbhA3f6CJRAb9vLxmhF-A3I27ET0gl0HlA7kQk/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="831" data-original-width="1600" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirENmc5vGcAD9yoxkYc2WTeplbh9MVWI72IZrZkqQSPe8_ahtKB_daXqqJn7FTXGvGbxW3774drkRHcnNrvza7S3K7Lbk9CIdD-7IA1kbhA3f6CJRAb9vLxmhF-A3I27ET0gl0HlA7kQk/s400/Capture.PNG" width="400" /></a></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="text-indent: -18pt;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="text-indent: -18pt;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="text-indent: -18pt;">2.1 You can either go with the root directory or Archive
file method. Root directory will create the files in the selected folder along
with the parent tree structure</span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<span style="text-indent: -18pt;"><br /></span></div>
<div style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt;">
</div>
<div class="MsoNormal" style="text-align: left;">
<o:p></o:p></div>
<div class="MsoNormal">
<b>Export Dependencies</b> check box exports the routine
dependencies along with Jobs you are exporting (Ex: Related File Excel
mappings, DB connection etc.)<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEBxmzAuVQt-1WV5tP4CdhpxsDR6QXNjfeac0tk9qjGlZVVpEDxlXjH12_rKNn-KjfpZpVT8mFUqP_JRBfCGB8LqNK-bU09GYFVcQxcrbrrcpcmA9ARF15X8z2aRIu8LSVrtLTZHgBGbE/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="898" data-original-width="1600" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEBxmzAuVQt-1WV5tP4CdhpxsDR6QXNjfeac0tk9qjGlZVVpEDxlXjH12_rKNn-KjfpZpVT8mFUqP_JRBfCGB8LqNK-bU09GYFVcQxcrbrrcpcmA9ARF15X8z2aRIu8LSVrtLTZHgBGbE/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
2.1.1 It created the Project Name and the all the related
job files.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMh7sKskiEWLL-KT8TVFdOQ_B4_RPgaYhpG8xgprbm0sSzRXzD9lTPc-A7BrNZBAw_ut2jq2WEnib4N4HxKlmJsmnN9o3ZhaX2eNVcCq8fYj054jJgY8eeIBoCcWS1wlKZKlD7bsAkMxs/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="256" data-original-width="1600" height="63" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMh7sKskiEWLL-KT8TVFdOQ_B4_RPgaYhpG8xgprbm0sSzRXzD9lTPc-A7BrNZBAw_ut2jq2WEnib4N4HxKlmJsmnN9o3ZhaX2eNVcCq8fYj054jJgY8eeIBoCcWS1wlKZKlD7bsAkMxs/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
2.2 Archive file option will create a ZIP file at the
destination</div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"> </span><b style="text-align: center;">Export Dependencies</b><span style="text-align: center;"> check box exports the routine
dependencies along with Jobs you are exporting</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFj2VwYXx2Szg6K9Xtqc1AKIc-aB6M48HnEnEGVUaIRmO654VSd7jEUUkE2IjFZm38ahaMpKvqH-X-qcGrofC_JzlCLS1qfnI4Wndg7Je484EnPc4pmvjirnA-N-ehbs0IcumPUioUysA/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="715" data-original-width="1600" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFj2VwYXx2Szg6K9Xtqc1AKIc-aB6M48HnEnEGVUaIRmO654VSd7jEUUkE2IjFZm38ahaMpKvqH-X-qcGrofC_JzlCLS1qfnI4Wndg7Je484EnPc4pmvjirnA-N-ehbs0IcumPUioUysA/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="text-align: center;"><br /></span></div>
<div class="MsoNormal">
2.2.1 Zip file created</div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilsGn0OR829tBJMpAqgvo_TRjrIp7EdEWnKKSkklFwtmufRdQnybixOQCJPvGp7-7RzMy-4kDhCNO4ISjqhOy9aHyRxBc6QR6QwSpLlQalKDzFLXVphEVzhkCpPwwvy0Cs25RUmONsnKA/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="186" data-original-width="1600" height="46" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilsGn0OR829tBJMpAqgvo_TRjrIp7EdEWnKKSkklFwtmufRdQnybixOQCJPvGp7-7RzMy-4kDhCNO4ISjqhOy9aHyRxBc6QR6QwSpLlQalKDzFLXVphEVzhkCpPwwvy0Cs25RUmONsnKA/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><u><span style="background: white; color: #444444; font-family: "Arial",sans-serif;">Import:</span></u></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->1 1. <span style="font-size: 7pt; font-stretch: normal; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Right click on the folder or Job design and
select ‘Import items’<o:p></o:p></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKBL_rw08Oba8QCWzTy_juiJ6EErCRhbwSphDexrC7tsZxkT8-7b_vlZCsRB4ns_vAKK0WyU6zv9Yke28ssQGsGSNRfOvntoSb_A9NQogrQRjHEpzw-JcUdNncalDe3-1uZ2Fz9LX2vTI/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="802" data-original-width="1600" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKBL_rw08Oba8QCWzTy_juiJ6EErCRhbwSphDexrC7tsZxkT8-7b_vlZCsRB4ns_vAKK0WyU6zv9Yke28ssQGsGSNRfOvntoSb_A9NQogrQRjHEpzw-JcUdNncalDe3-1uZ2Fz9LX2vTI/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
<div class="MsoNormal">
2.1. The Root directory option will create the structure the
way it was exported. You can select individual items as well.<o:p></o:p></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
</div>
<div class="MsoNormal">
<b>Overwrite existing items</b> check box overwrites the
existing items with those having the same names to be imported.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRtP7hrTvGeRBx8KsSCIXLzwJHYl61AFvG0_KDkB-aj1oSp-ZktizbJ6GKHWbxG_HEB2xOpqKVfspfzJ6JBoCRM0locpm_HbaPrn2zR-rKnFuMkcwbQv5Rwf_7AI5Qh3LeaEpSyI_vwTU/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1045" data-original-width="1600" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRtP7hrTvGeRBx8KsSCIXLzwJHYl61AFvG0_KDkB-aj1oSp-ZktizbJ6GKHWbxG_HEB2xOpqKVfspfzJ6JBoCRM0locpm_HbaPrn2zR-rKnFuMkcwbQv5Rwf_7AI5Qh3LeaEpSyI_vwTU/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
2.1.1 Result will be as like below<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuOcWrSy89aVlUmSSB50NxrLDZJdCe-2f2BW_JYQqXQjxrSN7X_Xar8Zu1ni4ZxyJLyEEKT46klwpLxsYppXoDpAZ41VupDYHAOT2qsXyGsSOLoU7jrxTxgJY63rUaxGPK128hD7FmVho/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="544" data-original-width="1600" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuOcWrSy89aVlUmSSB50NxrLDZJdCe-2f2BW_JYQqXQjxrSN7X_Xar8Zu1ni4ZxyJLyEEKT46klwpLxsYppXoDpAZ41VupDYHAOT2qsXyGsSOLoU7jrxTxgJY63rUaxGPK128hD7FmVho/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
2.2 Archive file option will also give you the same result<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhddBPB9-nFXWNlfC2KqJ3m6HzDUFBsN2lVbOlKJujIsQfFAgBjEWiQN8t3Of0p7LZO6Grm4QAcDkLE3R88_ttuikJ9l9ms6J3QPj0D9_jQcz4Ry9PlYUilAPACn_CygxsbtsG7xf3UYps/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1040" data-original-width="1600" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhddBPB9-nFXWNlfC2KqJ3m6HzDUFBsN2lVbOlKJujIsQfFAgBjEWiQN8t3Of0p7LZO6Grm4QAcDkLE3R88_ttuikJ9l9ms6J3QPj0D9_jQcz4Ry9PlYUilAPACn_CygxsbtsG7xf3UYps/s400/Capture.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="text-align: center;">
<o:p></o:p></div>
</div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-2455539104723249172020-07-08T08:03:00.000-07:002020-07-08T08:03:06.021-07:00Talend: tAggregateRow<div dir="ltr" style="text-align: left;" trbidi="on">
tAggregateRow palette can be used to get the aggregate value of any column or to get column based on the unique key<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbbYlEhyphenhyphenjTxsaAqT_G3UWE6zMU6PmxxN4J4VjtaJA6-24l9UgCkAkURh1oTaLRfeRJ8Qr5yA0yDTg1_bfGLaS7bFwn4YppVrtLn2PDv0qnhn-_vm4nOUFoqdsDW2Xk9p5ixliLePAmOFw/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="955" data-original-width="1600" height="238" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbbYlEhyphenhyphenjTxsaAqT_G3UWE6zMU6PmxxN4J4VjtaJA6-24l9UgCkAkURh1oTaLRfeRJ8Qr5yA0yDTg1_bfGLaS7bFwn4YppVrtLn2PDv0qnhn-_vm4nOUFoqdsDW2Xk9p5ixliLePAmOFw/s400/Capture.PNG" width="400" /></a></div>
<br /></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-89748301063113198982020-07-08T07:59:00.002-07:002020-07-08T07:59:44.945-07:00Talend: tReplace<div dir="ltr" style="text-align: left;" trbidi="on">
Use this palette to replace any column value with a new value<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidmrrqhOaNZM2zb9V3ljgo_TzQaf7b7BV-P9PgocwKr8YP7uy-UuVFaq3BgDXu7xHmAdxq5nREWuxh8DRY04S1t_sKT-GAgfcVgpQK_H8FlAAVzrW5aaNVyd7gMCsQJQO7H0-_TyMYMp0/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="665" data-original-width="1600" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidmrrqhOaNZM2zb9V3ljgo_TzQaf7b7BV-P9PgocwKr8YP7uy-UuVFaq3BgDXu7xHmAdxq5nREWuxh8DRY04S1t_sKT-GAgfcVgpQK_H8FlAAVzrW5aaNVyd7gMCsQJQO7H0-_TyMYMp0/s400/Capture.PNG" width="400" /></a></div>
<br /></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-47434983569490740932020-07-08T07:56:00.003-07:002020-07-08T07:56:49.809-07:00Talend: tSortRow<div dir="ltr" style="text-align: left;" trbidi="on">
Use this for sorting the output<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZkCw1F0mmeHNb3H0YAxQGIUeO3qI7xtjbwDB5gD7xZXbhnTtMT4lz2E0fj2sxz2FdtAMUGknrY07FcScDRrhHD0yNi-ndXNHzd0A6FhUDzmlUB7ygWX6lkXeEQxpy3TMdv1kWr4r2ZPM/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="879" data-original-width="1600" height="218" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZkCw1F0mmeHNb3H0YAxQGIUeO3qI7xtjbwDB5gD7xZXbhnTtMT4lz2E0fj2sxz2FdtAMUGknrY07FcScDRrhHD0yNi-ndXNHzd0A6FhUDzmlUB7ygWX6lkXeEQxpy3TMdv1kWr4r2ZPM/s400/Capture.PNG" width="400" /></a></div>
<br /></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-11191003910793277692020-06-30T14:43:00.001-07:002020-06-30T14:43:53.645-07:00Talend: tUniqRow to Remove Duplicate Rows<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="font-size: 13.2px;">tUniqRow</span></span><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;"> Palette can be used to remove duplicate rows. You can define the unique row combination key in the Basic settings section.</span><br />
<br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;" /><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;">Below, the keys attributes for a unique row are DateStart, PersonId and SourceSystemId</span><br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;" /><br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;" /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYu_X5HrN-h63zuprM33oZThtBtns1Cwn2SkvepCdkBy-Cs-dNh2h8cktXJgMe8FOzaqA5UWZkM9tD9Ml77iMeooBPWsMl132QJTqLy3myMhBHJllXapInHD7IgMMQcxzA8gb_HUU3rg0/s1600/Capture.PNG" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="1197" data-original-width="1416" height="337" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYu_X5HrN-h63zuprM33oZThtBtns1Cwn2SkvepCdkBy-Cs-dNh2h8cktXJgMe8FOzaqA5UWZkM9tD9Ml77iMeooBPWsMl132QJTqLy3myMhBHJllXapInHD7IgMMQcxzA8gb_HUU3rg0/s400/Capture.PNG" width="400" /></a><br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;"><br /></span></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-90627201876608919702020-06-30T14:31:00.002-07:002020-06-30T14:31:49.910-07:00Talend: tFilterRow to Filter Null rows<div dir="ltr" style="text-align: left;" trbidi="on">
tFilterRow Palette can be used to filter out unwanted rows from the output, here I am giving an example to filter out Null rows<br />
<br />
Below, it is filtering out the rows where assignmentNumber is Null<br />
<br />
In the 'Use advanced mode'<br />
Relational.ISNULL(input_row.AssignmentNumber)?false:true<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjc6nd16-F7t-G0P4MY_tHoOMHxuKc_HOwBCSmwX98QXqZ8GyWnm_yyilkne4CQe-LHkYLipbKIhRngmBvcbHzF2OBAIII3cSdCYKPHLHLNR4F1k-9gTzhEfkTulqnSe34kWeUHNWjiks4/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1030" data-original-width="1600" height="257" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjc6nd16-F7t-G0P4MY_tHoOMHxuKc_HOwBCSmwX98QXqZ8GyWnm_yyilkne4CQe-LHkYLipbKIhRngmBvcbHzF2OBAIII3cSdCYKPHLHLNR4F1k-9gTzhEfkTulqnSe34kWeUHNWjiks4/s400/Capture.PNG" width="400" /></a></div>
<br /></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-23946587881106198702020-06-30T14:18:00.001-07:002020-06-30T14:18:36.655-07:00Talend: If Else Condition on tMap<div dir="ltr" style="text-align: left;" trbidi="on">
In the recent ETL routine on the Talend job I had to compare two dates and select the greater one.<br />
<br />
You have many predefined functions available on expression builder, I used TalendDate.compareDate function to compare the dates and If else condition to get the max one.<br />
<br />
Open the expression builder by clicking on three dots<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM9ZkyxnrX1xEHijfuuiq6Ccr5NUPg5g7EOcO7rFUlXcfyvKdXWhTfIqG05IeD82hxDUjRWLGtX-WXMv2jiHdZTT9x9Ay0NR-LiwYu1wlYBu7BQP623GH7K__OpIvy1UeXxsLDBrP0nmc/s1600/Capture2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="443" data-original-width="1600" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM9ZkyxnrX1xEHijfuuiq6Ccr5NUPg5g7EOcO7rFUlXcfyvKdXWhTfIqG05IeD82hxDUjRWLGtX-WXMv2jiHdZTT9x9Ay0NR-LiwYu1wlYBu7BQP623GH7K__OpIvy1UeXxsLDBrP0nmc/s400/Capture2.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: left;">
Select the TalendDate.compareDate function and drag the date variables from the list </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
TalendDate.compareDate(row2.ASS_START_DATE,row7.MGR_START_DATE)==-1?row7.MGR_START_DATE:row2.ASS_START_DATE </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Here, compareDate returns -1 if argumen1 is less than argument1</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
== represents IF, ? represents THEN and : represents ELSE here</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Note: You use == for integer and .equals("") for string output.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Ex: row2.status.equals("Active")?"Select":"Ignore"</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjca70ei177L6RQ3G33yUTpk4OYGLDbjXZeUjbp5BoCw5HMW5fIYgWSFiT5ERRDdxqVxET60YiOJPnHF1gbaZqq2Nnqza56lYEOlKwncKj6m6hEZJMNFP2cooDMGXV6jsZyefq2YzrLgJM/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="268" data-original-width="1600" height="66" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjca70ei177L6RQ3G33yUTpk4OYGLDbjXZeUjbp5BoCw5HMW5fIYgWSFiT5ERRDdxqVxET60YiOJPnHF1gbaZqq2Nnqza56lYEOlKwncKj6m6hEZJMNFP2cooDMGXV6jsZyefq2YzrLgJM/s400/Capture.PNG" width="400" /></a></div>
</div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-60240328310504598372020-05-05T03:00:00.001-07:002020-05-05T03:00:29.594-07:00After a worker is created, you can't update or delete the user information or roles though the worker service. Make updates though the User service<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjg6LitBmpV7mOXdq79f2_-3R2BbZ6oaqNlAYO2STYmFlJxDATP1a-TyOxUgQZ6LXLhS2xnt0SqOYbjIvrI9ePJtCGuJeTKnsbQn7jPSe_DEYQxf17UhBc-szj4E_ALuj-55jUNzv66Z8c/s1600/HDL+Error01.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="254" data-original-width="1376" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjg6LitBmpV7mOXdq79f2_-3R2BbZ6oaqNlAYO2STYmFlJxDATP1a-TyOxUgQZ6LXLhS2xnt0SqOYbjIvrI9ePJtCGuJeTKnsbQn7jPSe_DEYQxf17UhBc-szj4E_ALuj-55jUNzv66Z8c/s400/HDL+Error01.PNG" width="400" /></a></div>
<br />
HDL Error: After a worker is created, you can't update or delete the user information or roles though the worker service. Make updates though the User service<br />
<br />
If you have already loaded the worker you can not use Worker.dat file to load User Information. Worker.dat file can only be used at the time of new worker creation, if the worker already exists in the system then you need to use User.dat file to add/remove roles or to update the user account information.<br />
<div style="-webkit-text-stroke-width: 0px; border-bottom-color: currentColor; border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: currentColor; border-left-style: none; border-left-width: 0px; border-right-color: currentColor; border-right-style: none; border-right-width: 0px; border-top-color: currentColor; border-top-style: none; border-top-width: 0px; box-sizing: content-box; color: #100f0e; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-stroke-width: 0px; border-bottom-color: currentColor; border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: currentColor; border-left-style: none; border-left-width: 0px; border-right-color: currentColor; border-right-style: none; border-right-width: 0px; border-top-color: currentColor; border-top-style: none; border-top-width: 0px; box-sizing: content-box; color: #100f0e; font-family: inherit; font-size: 100%; font-style: inherit; font-variant: normal; font-weight: inherit; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; word-spacing: 0px;">
In the User.dat file, discriminator User accepts only one role per user at a time. If you want to add multiple roles for a user at the same time, please use UserRole discriminator.</div>
</div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-65836024815339173052020-05-02T14:57:00.000-07:002020-05-02T14:57:18.921-07:00HDL Error ORA-01000: maximum open cursors exceeded<div dir="ltr" style="text-align: left;" trbidi="on">
While uploading large volume of data in Cloud/EBS you may encounter this error message. The solution is to increase the value set for open_cursors for the session.<br />
<br />
It was easy to amend this value in EBS<br />
<b>ALTER system SET open_cursors = 1000 scope=both;</b><br />
<b></b><br />
But in Cloud you do not have access to do so but you can try optimizing the HDL performance.<br />
Increase the size of below parameters in the HCM Data Loader configurator.<br />
<br />
Maximum Concurrent Threads for Load<br />Load Group Size<br />
<br />
The recommended value for the number of threads is 8, and for say 50,000 records in a batch, a Chunk size of 500 could be used to give decent throughput.<br />
<br />
Navigation> Setup and Maintenance > Configure HCM Data Loader<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4_76NR3_NYwDOc5v-13bdbLGkoQmzC9jrdASByY7GWPCijoIDK2TJl5IHsMSzRdv9N2xgu3ElLVCBfVtwZpvGcU_eUEIuGZDrlVJcntOW3rXkEQ-vFYgGj1rbywa2pmBWCZSI5ADZkmw/s1600/Capture11.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="668" data-original-width="1600" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4_76NR3_NYwDOc5v-13bdbLGkoQmzC9jrdASByY7GWPCijoIDK2TJl5IHsMSzRdv9N2xgu3ElLVCBfVtwZpvGcU_eUEIuGZDrlVJcntOW3rXkEQ-vFYgGj1rbywa2pmBWCZSI5ADZkmw/s400/Capture11.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
If it doesn't improve the performance please raise a service request with Oracle and they will increase the value for open_cursors parameter.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Ref: <span style="-webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: Tahoma,Verdana,Helvetica,sans-serif; font-size: 14.33px; font-style: normal; font-variant: normal; font-weight: 700; letter-spacing: normal; orphans: 2; text-align: right; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">(Doc ID 2066732.1)</span></div>
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><br /></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-32599951579159945012020-05-01T09:58:00.001-07:002020-05-01T09:58:42.937-07:00 Defining New Source System Owner for HDL in Oracle Cloud<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
For HDL either you can use User Key or Source Key. To go with the source key, a source system owner must be defined. To do so, you need to add a new lookup code in the HRC_SOURCE_SYSTEM_OWNER lookup type.</div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />Roles Required: "Application Implementation Consultant"<br /> OR "Human Capital Management Application Administrator" </div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
Use the Manage Common Lookups task in the ''Setup and Maintenance' work area under 'Other' </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKFCUyKAQe1qPHi3wWjaCQ2CqEWCJaMytOzQBqM7ZbSwgS3ae2BDcH3XcKgoGPDHKqFEM07HJ7MPyPVUb-7epPrHQ1DmBodbNT5TG7G6ZrTtCUhk60XGQenQL5lkKi72MdnZLxhqm1q4E/s1600/0105-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="510" data-original-width="1600" height="127" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKFCUyKAQe1qPHi3wWjaCQ2CqEWCJaMytOzQBqM7ZbSwgS3ae2BDcH3XcKgoGPDHKqFEM07HJ7MPyPVUb-7epPrHQ1DmBodbNT5TG7G6ZrTtCUhk60XGQenQL5lkKi72MdnZLxhqm1q4E/s400/0105-01.png" width="400" /></a></div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />Or 'Settings & Actions' window for your user and select 'Setup and Maintenance' under 'Administration</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOh498mk3LXw0ngsO3zbqqe-YUd8ItHSmh2vWi7r0tdXDqQYYNs09X62C43i4a2AZixuJPkh1ApW1uWVaJA6OjPFUfkU_QMJ9S185jdDVCsgesMpXNJhwEum_BgJYLA-VdEHWSi6GvRIc/s1600/0105-02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1293" data-original-width="1479" height="279" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOh498mk3LXw0ngsO3zbqqe-YUd8ItHSmh2vWi7r0tdXDqQYYNs09X62C43i4a2AZixuJPkh1ApW1uWVaJA6OjPFUfkU_QMJ9S185jdDVCsgesMpXNJhwEum_BgJYLA-VdEHWSi6GvRIc/s320/0105-02.png" width="320" /></a></div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />Now if know the functional area, search Task for 'Manage Common Lookups' </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUMuJ6NogKDlY0f9ejiOoeB-QLgtVZ8zXMdFH7tOV1yNCurnhJEfEbhyphenhyphenRL7z00zF53ZKWwpZ0SzjRgVMWZYmD2PgQD4awmk3LQ9rbkwslZf5CXvMQ8w_5JMC_uMCmHe4Q0fubUaOdfseY/s1600/0105-03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="1600" height="119" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUMuJ6NogKDlY0f9ejiOoeB-QLgtVZ8zXMdFH7tOV1yNCurnhJEfEbhyphenhyphenRL7z00zF53ZKWwpZ0SzjRgVMWZYmD2PgQD4awmk3LQ9rbkwslZf5CXvMQ8w_5JMC_uMCmHe4Q0fubUaOdfseY/s320/0105-03.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
or click on the little window to the right hand side and 'Search' for 'Manage Common Lookups'</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHeYjSWe_KwGtXtwKfhm7dlm04ngKhThN4OGXoaBIFoRMMR2kiMVNIG3lizKkFofwaG2XqEMAyhCfKw8WVPzV_7AOxVQBVRjtKKV9f4qjlhDcUOhMDojH3po6zrPyuDjRSEsuR9hjJHIc/s1600/0105-04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="680" data-original-width="1011" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHeYjSWe_KwGtXtwKfhm7dlm04ngKhThN4OGXoaBIFoRMMR2kiMVNIG3lizKkFofwaG2XqEMAyhCfKw8WVPzV_7AOxVQBVRjtKKV9f4qjlhDcUOhMDojH3po6zrPyuDjRSEsuR9hjJHIc/s320/0105-04.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigK223ZHqoQV4DikEkvU9eq9BTYiXHZQucrMpukMddfYfbYKrMw6qHqYCiiadSmX8AR8afUuJMCedWe6xlLeJ3KVB0pBDZfkFqWga05OIqa9uMOS5YP9YjcfnFl9f6OpCcQWVNpGmLGg0/s1600/0105-05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="361" data-original-width="1600" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigK223ZHqoQV4DikEkvU9eq9BTYiXHZQucrMpukMddfYfbYKrMw6qHqYCiiadSmX8AR8afUuJMCedWe6xlLeJ3KVB0pBDZfkFqWga05OIqa9uMOS5YP9YjcfnFl9f6OpCcQWVNpGmLGg0/s320/0105-05.png" width="320" /></a></div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
> Search for the lookup type HRC_SOURCE_SYSTEM_OWNER. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUhyCNnG40xeJFNhXJm0fs84mAXbjQoBNcKTLp5pE0YUkP-L6J2ud7GT74mEby0UGgHU9sRXn_qPwNmoA64RzQ-oclQIC-_faAuVycbdEx24M96iOYkMtXxY9DIKqeaqiWztdBChSDDxA/s1600/0105-06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="906" data-original-width="1600" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUhyCNnG40xeJFNhXJm0fs84mAXbjQoBNcKTLp5pE0YUkP-L6J2ud7GT74mEby0UGgHU9sRXn_qPwNmoA64RzQ-oclQIC-_faAuVycbdEx24M96iOYkMtXxY9DIKqeaqiWztdBChSDDxA/s320/0105-06.png" width="320" /></a></div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />> In the Lookup Codes section of the page, click the New icon to add a new lookup-code<br />> Save & Close</div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #1a1816; font-family: &quot; font-size: 16px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.44; margin-bottom: 14px; margin-left: 0px; margin-right: 0px; margin-top: 14px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />select lookup_code<br /> ,meaning<br /> ,description<br /> from fnd_lookup_values <br />where upper(lookup_TYPE) ='HRC_SOURCE_SYSTEM_OWNER'<br /> and enabled_flag = 'Y'</div>
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><br /></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-86279579717633025802020-04-14T10:24:00.000-07:002020-04-14T10:24:02.226-07:00OAF personalization - Java Script<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Recently I got a requirement to change the default option from 'New Bank' to 'Existing Bank' on the iSupplier bank details page. </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">This cannot be achieved by the direct personalization as values are being set dynamically. The value for ‘Existing Bank’ is ‘OLD’ and ‘NEW’ for ‘New Bank’. The inherited value is already ‘OLD’ but at the run time it is being set as ‘NEW’ and the default radio choice is ‘New Bank’ instead of ‘Existing Bank’.</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">With the help of my very good friend Vikram, I achieved it with java scripting.</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br />To achieve this functionality, we need to write some java script which can overwrite the initial value to ‘OLD’. Components involved </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"> > Java & HTML script</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"> > OAF Personalization</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">First, to know about the logic, right click on the radio choice, ‘New bank’ and select ‘Inspect’ (it might possible you won’t able to perform this in IE, either use chrome or press F12)</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Here you can see the logic how radio choice being selected; this is after the solution so you are seeing ‘OLD’</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWIEyNa51z_BsDAns9b7aV3pfy-opf2d2YdPmLpR9o5Zwp1zk1su7s5_qWJH8Xxt_BK-qXiWja_REr9rDP9VJZ027Idn_4MvWEs6QIQPrRbqZBCP06Hh8BHMm6FhhmoPcXQ7XH9gdkxIk/s1600/1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="664" data-original-width="1600" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWIEyNa51z_BsDAns9b7aV3pfy-opf2d2YdPmLpR9o5Zwp1zk1su7s5_qWJH8Xxt_BK-qXiWja_REr9rDP9VJZ027Idn_4MvWEs6QIQPrRbqZBCP06Hh8BHMm6FhhmoPcXQ7XH9gdkxIk/s400/1.png" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><span style="color: black;"></span><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">We tried first </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><script>window.onload = document.querySelector("input[name=BankSelectChoice][value=OLD]").checked=true;</script></span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">In the ‘Console’ you can test your script before doing the actual personalization.</span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHIkiB1FVHTShEBKSO6bWrJP9A8064n_JvEnGa9R7ruhzutC82Msprjyb51Qcva9GUOEc1hX6EoHErcSnDe9-SDnPLFB3_nT7-uOeIScnbTButkvTbwyLsja9LGSqBD26K0w1pKONWUk8/s1600/2-1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="635" data-original-width="1600" height="158" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHIkiB1FVHTShEBKSO6bWrJP9A8064n_JvEnGa9R7ruhzutC82Msprjyb51Qcva9GUOEc1hX6EoHErcSnDe9-SDnPLFB3_nT7-uOeIScnbTButkvTbwyLsja9LGSqBD26K0w1pKONWUk8/s400/2-1.png" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">This Worked on Chrome but did not work on IE -- Depends on IE version and developer mode set, even the IE version is 11 but if developer mode is set as 5, the below script won’t work in IE.</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">If you change the developer mode more or equal to version 9, it would work as querySelector is not avaliable to less than IE9.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigwC54lEF6ND9sGZ5bu9PXnw_XLjurrcGgmwSqe_9MpKcD4AO7Vj_g2xas23JZGvGAVQQz2ODad3FJelNMdAm7WmdzcrGgQhv_IegSQRbPR_UoBFwywyikECcDiBpBKpI6bTERZ1yCEi4/s1600/2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="374" data-original-width="1600" height="92" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigwC54lEF6ND9sGZ5bu9PXnw_XLjurrcGgmwSqe_9MpKcD4AO7Vj_g2xas23JZGvGAVQQz2ODad3FJelNMdAm7WmdzcrGgQhv_IegSQRbPR_UoBFwywyikECcDiBpBKpI6bTERZ1yCEi4/s400/2.png" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">So the<b> final Java & HTML Script</b></span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Ø Script is finding the value of the Radio Choice BankBranch and setting the click when it is finding ‘OLD’ at the time of window load. OLD is the value for ‘Existing Bank’ or ‘Existing Branch’.</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Ø It is setting up ‘Bank Branch’ only because ‘Bank’ choice is dependent on the ‘Bank Branch’ choice. ‘Bank’ choice will change according to the ‘Bank Branch’ choice.</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><script><br />function xxakde() {<br />var x= document.getElementsByName("BankBranchSelectChoice");<br />var i;<br />for (i = 0; i < x.length; i++) {<br /> if (x[i].type == "radio") {<br /> if (x[i].value=="OLD") {<br /> x[i].click();<br /> }<br /> }<br />}<br />}<br />window.onload = xxakde;</span><br />
<div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"></script></span></div>
<div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span></div>
<div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Please Note: This can be done in a single script as above, but I have modularized it for better understanding and created two scripts. </span></div>
<div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span></div>
<div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">1> First to create a function to find the set the appropriate value </span></div>
<div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><script><br />function xxakde() {<br />var x= document.getElementsByName("BankBranchSelectChoice");<br />var i;<br />for (i = 0; i < x.length; i++) {<br /> if (x[i].type == "radio") {<br /> if (x[i].value=="OLD") {<br /> x[i].click();<br /> }<br /> }<br />}<br />}<br /><div>
</script></div>
<div>
<br /></div>
<div>
2> Secondly, a wrapper function to call the above function on the window load</div>
<div>
<br /></div>
<script>function xxdef() { xxakde();} window.onload= xxdef(); </script></span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><b><u><br />OAF Personalization</u></b></span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><b></b><u></u><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Responsibility: iSupplier Profile & user Manager ></span><span style="color: black;"> </span><span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">‘Supplier details’ ></span><span style="color: black;"> </span><span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">‘Banking Details’ </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Click on ‘Create’ Button' > </span><span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">‘Personalize Page’ </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br />Choose ‘Complete View’ and ‘Expand All’</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Now click on ‘Create Item’ symbol under the last topmost Region so that the custom items will be sitting at the end and easy to find.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFEaAVOxk2fUAJkq_NB2q9tmhJQaFUxRfweoVyvK-_uInxSGxhc_6oqrOP79goqIsiubn9u2NpCg4w6QFVR7wfbIavQvBrNsp95wOjTqH5GqheOEWmCGlXBnTYGcyeeOhYxam2rGiEzaY/s1600/4.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="488" data-original-width="1600" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFEaAVOxk2fUAJkq_NB2q9tmhJQaFUxRfweoVyvK-_uInxSGxhc_6oqrOP79goqIsiubn9u2NpCg4w6QFVR7wfbIavQvBrNsp95wOjTqH5GqheOEWmCGlXBnTYGcyeeOhYxam2rGiEzaY/s400/4.PNG" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">ID: Any Suitable ID as per the Home Group naming standard EX: XXAKDEFAULTBRANCHOPTION</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Leave the other properties with default values and ‘Apply’</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqh4Ve4iHfsNzTDFsxy0d75rsaaG1FUSkuNVfn2fdzXbrRIx32PvmbqIk3FYb4_54N0CvMWM3CP59H_-_jdb1YlagmROzmK4P-rjwk5ghnTBlIV2W_7gc22lJPnMehWQpShyglDxZTfcQ/s1600/5.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="848" data-original-width="1047" height="323" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqh4Ve4iHfsNzTDFsxy0d75rsaaG1FUSkuNVfn2fdzXbrRIx32PvmbqIk3FYb4_54N0CvMWM3CP59H_-_jdb1YlagmROzmK4P-rjwk5ghnTBlIV2W_7gc22lJPnMehWQpShyglDxZTfcQ/s400/5.PNG" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Similarly, create another item </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Choose Level as ‘Site’, Item Style as ‘Raw Text’ and modify below properties</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">ID: Any Suitable ID as per the Home Group naming standard EX: XXAKDEFAULT<br /> </span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">Leave the other properties with default values and ‘Apply’</span><br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">It should look like as below, click on ‘Return to Application’</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidSNRK8ndxYXlZc0hzy9hJTxXYTHfnNIsAijs0kbyxpUCWQ3efhuyXFsO3nDaWHa-msJXAe-m-iPts6OeQB8F9T2-0eCo-0rzpg0Znyc0fPj-SxiRqQxAEKxq-_mjSotRENnesCyfwFy4/s1600/6.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="783" data-original-width="1600" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidSNRK8ndxYXlZc0hzy9hJTxXYTHfnNIsAijs0kbyxpUCWQ3efhuyXFsO3nDaWHa-msJXAe-m-iPts6OeQB8F9T2-0eCo-0rzpg0Znyc0fPj-SxiRqQxAEKxq-_mjSotRENnesCyfwFy4/s400/6.PNG" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;">It should do the job</span><span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPo5Mb6J2niLxRBkXNHh6q_n98HtnujLywH9bTfWSuDoY3kerB-yy_tU41lTXqzVWZ5hB80Tfx3ZG2tzK0kpPgtjROpxuMzqtUpGLfTpldjx5KVyag4Jgj3ThWd9o0R4SlSAxlzZG14Ac/s1600/8.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="650" data-original-width="1600" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPo5Mb6J2niLxRBkXNHh6q_n98HtnujLywH9bTfWSuDoY3kerB-yy_tU41lTXqzVWZ5hB80Tfx3ZG2tzK0kpPgtjROpxuMzqtUpGLfTpldjx5KVyag4Jgj3ThWd9o0R4SlSAxlzZG14Ac/s400/8.PNG" width="400" /></a></div>
<span style="background-color: white; color: black; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"><br /></span>
<div>
<span style="background-color: white; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"></span></div>
<div>
<span style="background-color: white; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: x-small;"></span></div>
<span style="-webkit-text-stroke-width: 0px; background-color: white; display: inline !important; float: none; font-family: Arial,Tahoma,Helvetica,FreeSans,sans-serif; font-size: 13.2px; font-variant: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="color: black;"></span><br /></span></div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com2tag:blogger.com,1999:blog-8648035478787557112.post-29089214592452137752020-03-25T04:39:00.001-07:002020-04-14T09:23:01.048-07:00'Java was started but returned exit code 1' Error<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #3e3e3e; font-family: &quot; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
Please check the correct java version is installed and java environment is set correctly.</div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #3e3e3e; font-family: &quot; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #3e3e3e; font-family: &quot; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
'java -version' in command prompt (cmd) will show you the java version installed<br />
'where java' will show you the java location</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;">
<img border="0" data-original-height="360" data-original-width="1503" height="95" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS7pi5UrUvaDnwF8Q0nM97EXOhtHmX1nrrZoF-AP0KTziMOCD7N7TdNmRG5gT4xvKkUBEVbJhb42AoplUCa1MMasmOXJMwxbkQyMDbcvu9a-yFwkHHlBNbSKnhC1EWdJfMNMiOMjqba20/s400/Capture.PNG" width="400" /></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="text-align: left;">
<span style="background-color: white; color: #3e3e3e; display: inline; float: none; font-family: "times new roman"; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><br /></span></div>
<div style="text-align: left;">
<span style="background-color: white; color: #3e3e3e; display: inline; float: none; font-family: "times new roman"; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">Ensure proper version of JDK is installed, you can download JDK from <a href="https://www.oracle.com/java/technologies/javase-jdk8-downloads.html" target="_blank">here</a>.</span></div>
<div style="text-align: left;">
<span style="background-color: white; color: #002000;">Set the JAVA_HOME environment variable.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlxB8BsCTISnDcRLBpV6lq5ZNCAENYPmDaNap9MycSRw2zS6gd-ZASyG411L0nz6J0mD_1E4q4XzIEwFAw3Rtp0zmPI8IRpe_vC8sab4E69xI_cV3lSYo-6C5mQGiF1FZ6kPbbqC7ZEdI/s1600/Capture2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="571" data-original-width="1600" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlxB8BsCTISnDcRLBpV6lq5ZNCAENYPmDaNap9MycSRw2zS6gd-ZASyG411L0nz6J0mD_1E4q4XzIEwFAw3Rtp0zmPI8IRpe_vC8sab4E69xI_cV3lSYo-6C5mQGiF1FZ6kPbbqC7ZEdI/s400/Capture2.PNG" width="400" /></a></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="-webkit-text-stroke-width: 0px; box-sizing: border-box; color: #3e3e3e; font-family: &quot; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
</div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0tag:blogger.com,1999:blog-8648035478787557112.post-14652497009600796702020-03-25T04:07:00.000-07:002020-04-14T09:23:24.005-07:00 Oracle SQL Developer - Increase size of GUI/Font<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
When you are running SQL Developer on Windows 10, you need to change the compatibility accordingly to get the proper GUI size.</div>
<div>
<br /></div>
<div>
<u>With default compatibility mode </u><u><br /></u></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;">
<img border="0" data-original-height="1307" data-original-width="1414" height="368" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIXdBnA4FkYkrn1Osxnh6DbLld7hM221c7uJ2jIA26Bf_FwD7UF42NXV6SBwiRNsKVrttOZQPlxYzlvG5LHvuuHeNlcEqtsuwq2ynh2BKLu8jmZIIrOsojxKLLKku9OK7Nizyf55S06hg/s400/Capture.PNG" width="400" /></div>
<br />
<span style="color: #000120;"><br /></span>
<span style="color: #000120;"><br /></span>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="text-align: left;">
<u>Change the compatibility mode</u></div>
<span style="color: #000120;"><u></u><br /></span>
<div style="text-align: left;">
<span style="color: #000120;">1> Right Click on SQL Developer icon and select Properties.</span></div>
<div style="text-align: left;">
<span style="color: #000032;"> > Go to the Compatibility tab</span></div>
<div style="text-align: left;">
><span style="color: #000120;"> Compatibility mode change it to windows 7</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #000032;"> > Check the option of Override high DPI scaling behaviour</span></div>
<div>
<span style="color: #000050;"> > Select "System" in drop down below</span></div>
<span style="color: #000032;">6> Apply </span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoSjUplAmxiztX1ThKdQNteLDpAlaRGOZ3Z4rNQ7SEU-HA7Gi4HUxRDkSXTCo8-_OGtpCNnNs1fPC7Gqqv59VCDVR9kuTtHj1UMZ2Rncr2gizRnwY1K_Fef7Ou7vHwUAux5l16RSPPC3c/s1600/Capture2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: #000032;"></span><img border="0" data-original-height="1129" data-original-width="1406" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoSjUplAmxiztX1ThKdQNteLDpAlaRGOZ3Z4rNQ7SEU-HA7Gi4HUxRDkSXTCo8-_OGtpCNnNs1fPC7Gqqv59VCDVR9kuTtHj1UMZ2Rncr2gizRnwY1K_Fef7Ou7vHwUAux5l16RSPPC3c/s400/Capture2.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #000120;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #000120;"><u>Re-Launch the application</u></span><span style="color: #000120;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOLDgnqFewjiwSJXRN30xgUY23paeOVsPx2wugneIEVk2v0IDyLrRwNe3s1Kk5JzRrEUiFIvwh3gnHyq7Ai6MBHMVhT1F9TzegVKQRIbqaEmqT3QI8Mo1fFgs3cVw_tzSSTrstbmuoqmM/s1600/Capture3.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1387" data-original-width="1600" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOLDgnqFewjiwSJXRN30xgUY23paeOVsPx2wugneIEVk2v0IDyLrRwNe3s1Kk5JzRrEUiFIvwh3gnHyq7Ai6MBHMVhT1F9TzegVKQRIbqaEmqT3QI8Mo1fFgs3cVw_tzSSTrstbmuoqmM/s400/Capture3.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #000120;"><br /></span></div>
<div>
<br /></div>
</div>
Abhay Kumarhttp://www.blogger.com/profile/14455462067429407225noreply@blogger.com0