CLOUD EBS INSTALLTION
CLOUD EBS INSTALLTION login as: opc Authenticating with public key “rsa-key-………” from agent Last login: Thu Jan 07:59:41 2020 from 103.57……129 [root@document ~]# df -h Filesystem Size Used Avail…
Read MorePatch Analysis in Oracle Apps R12.1
INTRODUCTION The below steps shows us how to take patch analysis on oracle EBS R12.1. STEP 1: Download the Recommended Patch from MOS, move it to the server and Unzip.…
Read MoreQuery to find to Soft Parse and Hard Parse Ratio
select ‘Soft Parses ‘ “Ratio” ,round( ((select sum(value) from v$sysstat where name = ‘parse count (total)’) – (select sum(value) from v$sysstat where name = ‘parse count (hard)’)) /(select sum(value) from…
Read MoreAutoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2
Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2 /u01/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status…
Read MoreResolve API error — (hz_cust_site_uses cannot be locked as it has been updated by another user)
Objective: Intent to publish this blog to get rid of this below common API Error while updating the Customer site uses. Error: hz_cust_site_uses cannot be locked as it has been…
Read MoreQuery to fetch the Records from AP Expense to GL
Introduction This Query will help to Fetch Records From AP Expense to GL SQL Query: SELECT aerha.invoice_num expense_invoice_number, papf.full_name employee_name, aerha.SOURCE, aerha.description expense_header_description, aerha.attribute_category, aerha.expense_status_code, aerla.start_expense_date, aerla.distribution_line_number, aerla.item_description line_description, aerla.amount,…
Read MoreOnhand Inventory by Revision Report
Onhand Inventory by Revision Report Introduction This Query will help to generate the On-hand Inventory by Revision Report Script: Step 1: Create Package Spec CREATE OR REPLACE PACKAGE xxxx_inventory_pkg AS…
Read MoreOPMNCTL startall Fails with “unexpected exit: status 4200”
While trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1/bin/opmnctl startall opmnctl startall: starting opmn and all managed…
Read MoreLife At Doyensys – Uday Kumar Koneti
Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreDoyensys Steps Up the Game Once Again With a Global Leader in Energy and Process Automation Solutions
An India-based global leader in Energy and Process Automation Solutions has been a customer of Doyensys for several years. Along the way, Doyensys has established itself as a trusted partner…
Read More