Project Basic Query: select proj.carrying_out_organization_name project_organization, proj.segment1 project_number, proj.name Project_Short_Name, proj.city , proj.region, proj.long_name project_long_name, proj.start_date transaction_start_date, proj.target_finish_date Target_Finish_Date, proj.project_type , …
Read MoreInsert 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 MoreAssociative 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 More#!/bin/bash ################################################################################# # File_Name : imauanzstmtfilearchv.prog …
Read MoreHow 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 More