Insert Run Report in Excel for Apps
Insert Run Report Feature in ExcelforApps Insert Run functionality is used to return sum, count, max etc for the datapoint(columns) in E4A Report. The value will be returned in the…
Read MoreHow to Use Associative array in select statement as normal database table
Associative array in select statement as normal database table Step 1 First Create Associative Array Type TYPE assoc_array_type IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER; if required We can use…
Read MoreFile Moving and renaming using UNIX SHELL Script in EBS
#!/bin/bash ################################################################################# # File_Name : imauanzstmtfilearchv.prog …
Read MoreORACLE UTL_SMTP MAIL
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 MoreFusion HCM – Customizing the Global Cheque
1. 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 MoreFusion HCM – Customizing the Global Payslip
1. 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 MoreFusion HCM – Query for Payroll Costing Details
SELECT 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 MoreZooming : Calling One Form from another Form using Personalization
1. 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 MoreVendor Ledger Report Query
SELECT 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 MoreForm Personalization to modify the LOV of a Field
Aim : 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 More