How to Send SMTP MAIL to Multiple Recipents using ORACLE UTL_SMTP package —————————————————————————————— Below procedure shows how to send email to mutliple recipents CREATE OR REPLACE PROCEDURE XXCUST.XXX_SMTP_MAIL_NOTIF_PRC(errbuf OUT VARCHAR2,…
Read More1. Copy the Existing Check Template from the Location : 2. Paste the Copied Check Template to the Custom Folder 3. Edit the Template according to your Requirement 4. Login to Application with implementation user and…
Read More1. Copy the Existing Pay slip Template & Sub Template from the Location : Human Capital Management -> Payroll -> Payment Distribution 2. Paste the Copied Payslip Template to the Custom…
Read MoreSELECT paaf.assignment_number, petf.base_element_name element_name, (SELECT petf2.base_element_name FROM pay_input_values_f piv2, pay_element_types_f petf2 …
Read More1. Open the main form you want to personalize and go to Help -> Diagnostics -> Custom Code -> Personalize 2. Add a record as seq 10 Description =…
Read MoreSELECT flag, vendor_num, vendor_name, vendor_site_id, vendor_site_code, state_code, project_code, transaction_type, transaction_num, doc_category_name, document_num, po_number, transaction_date, gl_date, status, description, currency, SUM(entered_dr) entered_dr, SUM(entered_cr) entered_cr, SUM(accounted_dr) accounted_dr, SUM(accounted_cr) accounted_cr FROM (SELECT 1 flag,…
Read MoreAim : To Change the LOV of the “Tax Category” field in the “Enter transation India Localization” form. Navigation: AR Super User > India Local Receivables > Transactions > Transactions (Localized) Double…
Read MoreThe below are the steps to follow to develop a basic Custom form in EBS. Download the Resource folder from the server and place in local directory. Right Click on…
Read More1. Go to Application Developer -> Flex Fields -> Descriptive -> Register Enter all the details and click on Columns. Enable the columns and save. 2. Now go to Segments menu. Search…
Read MoreEnable Audit Trail ProfileNavigation: System Administrator à Profile à System Now enter AuditTrail:Activate in Profile and click on Find. Make sure it is enabled (Yes) at Site Level Enable Audit For Schema Navigation: System…
Read More