Month: August 2021

HRMS Legislative Data Using Data Installer and hrglobal.drv

HRMS Legislative Data If apply the Latest RUP patch in HRMS (R12.HR_PF.C.Delta.14 Release Update Pack) Oracle Payroll – Version 12.2 and later Oracle Human Resources – Version 12.2 and later We can the following Post update steps   HR Legislative customers only:   1. adop phase=prepare   2. Source the Patch  environment file   2.[applmgr@visebsapp …

HRMS Legislative Data Using Data Installer and hrglobal.drv Read More »

How to stop and start concurrent manager in Oracle EBS R12.2 ?

 1. To Check the Concurrent manager status   /visapps/applmgr/fs1/inst/apps/VIS_visebsapp/admin/scripts ==>$ADMIN_SCRIPT_HOME   [applmgr@visebsapp scripts]$ adcmctl.sh status   You are running adcmctl.sh version 120.19.12020000.7     Enter the APPS username : apps   Enter the APPS password : Internal Concurrent Manager is Active.   adcmctl.sh: exiting with status 0     adcmctl.sh: check the logfile /visapps/applmgr/fs1/inst/apps/VIS_visebsapp/logs/appl/admin/log/adcmctl.txt for …

How to stop and start concurrent manager in Oracle EBS R12.2 ? Read More »

FRM-40010.Cannot read form /visapp/applmgr/fs2/EBSapps/apl/12.0.0/forms/US/JAINAXT.frmx

 To implement the solution, please execute the following steps:   1. Execute the below script in apps schema using SQL*PLUS   set serveroutput on; begin IF (AD_EVENT_REGISTRY_PKG.Is_Event_Done( p_Owner => ‘JA’, p_Event_Name => ‘JAI_EXISTENCE_OF_TABLES’ ) = TRUE) THEN dbms_output.put_line ( ‘Event JAI_EXISTENCE_OF_TABLES for JA is set!!’); else dbms_output.put_line ( ‘Event JAI_EXISTENCE_OF_TABLES for JA is NOT set. …

FRM-40010.Cannot read form /visapp/applmgr/fs2/EBSapps/apl/12.0.0/forms/US/JAINAXT.frmx Read More »

Prerequisite Steps to Configure Oracle Fusion Middleware 11.1.1.9 Components for Oracle E-Business Suite Release 12.2 Before Applying CPU patch

 I have applied JAN Critical Patch 31304503 [IMPORTANT: Follow Note 2555355.1 before applying.]     – Filename: p31304503_111190_Linux-x86-64.zip   If applied the Patch 31304503 the following OPMN will log the following Error:   [opmn] [ERROR:1] [] [ons-secure] Connection server SSL set credentials failed (43084) [opmn] [ERROR:1] [222] [ons-secure] SSL initialization failed   To avoid failures …

Prerequisite Steps to Configure Oracle Fusion Middleware 11.1.1.9 Components for Oracle E-Business Suite Release 12.2 Before Applying CPU patch Read More »

Request for List of Application wise Seeded Responsibilities for Oracle E- Business Suite

The Application wise Seeded Responsibilities for R12.2 Version and request to include the following information: Responsibility Name Description User_Menu_Name Menu_Desc Responsibility_Key Application_Short_Name Application_Name Menu Name       1)SELECT DISTINCT     –fu.user_name,     frt.responsibility_name,     frt.description,     fmt.user_menu_name,     fmt.description menu_desc, —    furg.start_date, —    furg.end_date,     fr.responsibility_key, …

Request for List of Application wise Seeded Responsibilities for Oracle E- Business Suite Read More »

How executed adpreclone.pl in Database and Application oracle 12.2?

Database Side: To check the database status [oracle@visebsdb ~]$ ps -ef | grep tns root        23     2  0 Jul16 ?        00:00:00 [netns] oracle   25253     1  0 Aug08 ?        00:00:11 /visdb/oracle/12.1.0/bin/tnslsnr VIS -inherit oracle   31468 31407  0 20:37 pts/0    00:00:00 grep –color=auto tns    …

How executed adpreclone.pl in Database and Application oracle 12.2? Read More »

How stop application and shutdown oracle Database in R12.2 ?

 To Stop the Application Services:   In Application Server Source the environment file (ie, EBSapps.env ) [applmgr@visebsapp VIS]$ . EBSapps.env   E-Business Suite Environment Information   —————————————-   RUN File System           : /visapp/VIS/fs2/EBSapps/appl   PATCH File System         : /visapp/VIS/fs1/EBSapps/appl   Non-Editioned File System : /visapp/VIS/fs_ne   DB Host: …

How stop application and shutdown oracle Database in R12.2 ? Read More »

ORA-04063: package body “APPS.AD_ZD_ADOP” has errors when Running adop -status

 While am executing the adop -status, The following got Error   [applmgr@devebsapp admin]$ adop -status   Enter the APPS password: *******FATAL ERROR******* PROGRAM : (/prodapps/applmgr/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Mar 26 22:40:21 2021 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS error: buffer=   SQL*Plus: Release 10.1.0.5.0 – Production on Fri Jun 25 22:40:21 2021   …

ORA-04063: package body “APPS.AD_ZD_ADOP” has errors when Running adop -status Read More »