Posts

How to get the content written for the packages in Oracle DB.

By
To extract specific ranges or large blocks (e.g., 2,000 lines) of context from an Oracle Package or Package Body, the most effective methods rely on querying the data dictionary views ( USER_SOURCE / ALL_SOURCE ) or using Oracle's built-in package DBMS_METADATA . Option 1: Query USER_SOURCE for a Specific Line Range If you know the starting line (for example, reading 2,000 lines starting from line 1000 to line 3000), query USER_SOURCE directly: SQL SELECT line, text FROM user_source WHERE name = 'YOUR_PACKAGE_NAME' -- Replace with package name (UPPERCASE) AND type = 'PACKAGE BODY' -- 'PACKAGE' or 'PACKAGE BODY' AND line BETWEEN 1000 AND 3000 -- 2,000-line range ORDER BY line; Option 2: Extract Context Around a Specific Line or Keyword If an error or stack trace points to a specific line number (e.g., Line 2500), you can extract 1,000 lines before and 1,000 lines after: SQL SELECT line, text FROM user_...
Post a Comment
Read more

Autoconfig Log Location in EBS 12.2.X

By
  Log files for Autoconfig execution Oracle EBS R12.2.4 are below: On Applicaion Tier: $INST_TOP/admin/log/<MMDDhhmm> On Database Tier: $ORACLE_HOME/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm> 3.Log files for start/stop of services from $ADMIN_SCRIPTS_HOME In below directory we will find log files related to start/stop process of oacore, forms, apache, opmn, weblogic admin server/node manager: $LOG_HOME/appl/admin/log 4.Log/Out files for Concurrent programs/managers in Oracle R12.2.4 are in below location: Log/Out files for Oracle Release 12.2 are stored in Non-Editioned filesystem(NE). Log files: $APPLCSF/$APPLLOG (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/log) Out files: $APPLCSF/$APPLOUT (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out) 5.Log files for OPMN and OHS processes in Oracle R12.2.4 are in below location: Below directory contains log files related OPMN process(opmn.log), OPMN Debug logs(debug.log), HTTP Transaction logs (access.log),sec...
Post a Comment
Read more

EBS responsibilities are not displaying.

By
 Sometimes even though post running. 1) SYNC workflow data into WF local tables 2) SYNC workflow local roles. 3)  Workflow directory user role validation select  role_name ,  EFFECTIVE_END_DATE   from  wf_local_user_roles  where  user_name = ' OHRID '   SELECT    DISTINCT  frt . RESPONSIBILITY_NAME ,  furg . end_date FROM          fnd_user_resp_groups furg ,          FND_RESPONSIBILITY fr ,          fnd_responsibility_tl frt ,          fnd_user fu WHERE  fu . user_name  =   ' OHRID ' AND    fu . user_id  =  furg . user_id AND    furg . responsibility_id  =  fr . RESPONSIBILITY_ID AND    frt . responsibility_id  =  fr . RESPONSIBILITY_ID AND  frt .LANGUAGE= 'US' ORDER   BY ...
Post a Comment
Read more

Create Accounting completing with Warning and incorrect output format.

By
Conc Jobs are getting into warning with output generated in XML tags in place of desired format. There was a OPP issue. After recycle from front end resolve the issue.
Post a Comment
Read more

How to use JPXImporter in EBS12.2

By
  java   oracle.jrad.tools.xml.importer.JPXImporter   $HOME/kturley/ XXCUST_projects_list.jpx   -username apps -password xxxx -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= hostname.oracle.co.uk)(PORT=1551))(CONNECT_DATA=(SID=XXXXX )))”  Make sure you specify the correct values for  1. Path of you jpx file  2. apps password  3. host name  4. port  5. database SID  Finally restart the webserver so that you can see your changes in the application  $INST_TOP/admin/scripts/ adoacorectl.sh  stop $INST_TOP/admin/scripts/ adoacorectl.sh  start  
Post a Comment
Read more
By
Can I flush the Undo tablespace by any chance... ? You don't need to flush any thing from the undo tablespace. It will reuse the undo data automatically. You can create a new undo tablespace and make it active for your database. Later on drop your old undo tablespace. UNDO_RETENTION time undo tablespace is filled and any query fails, then if another query is going to do a DML and tries to use UNDO segments then, I think that will also fail because of unavailability of UNDO SEGMENTS.. > create undo tablespace undotbl_new datafile size 1m; Tablespace created. > alter system set undo_tablespace = undotbl_new scope=both; System altered. > drop tablespace undotbs; Tablespace dropped.
Post a Comment
Read more

Change Password in an Oracle Database

By
 Once connected, ALTER USER command, specifying the new password. ALTER USER myuser IDENTIFIED BY MyNewPassword; To use special characters, remember to enclose the password in double quotes. ALTER USER myuser IDENTIFIED BY "MyNewPassword#"; SQL*Plus and SQLcl Use the PASSWORD command from the SQL*Plus and SQLcl utilities. It will be prompted for your current password and the new password. SQL> password Changing password for MYUSER Old password: ******** New password: ******** Retype new password: ******** Password changed SQL> SQL Developer From SQL Developer Right-click on the connection. Select the "Reset Password..." option from the popup menu. In the subsequent dialog, enter the current password and the new password with confirmation. Click the OK button. TOAD For TOAD do the following. select "Session > Change Password". In the subsequent dialog, enter the current password and the new password with verification. Click the OK button.
Post a Comment
Read more

ALTER PACKAGE COMPILE Statement

By
  This statement explicitly recompiles the specification and body of the  hr.emp_mgmt  package. ALTER PACKAGE emp_mgmt COMPILE PACKAGE; If the database encounters no compilation errors while recompiling the  emp_mgmt  specification and body, then  emp_mgmt  becomes valid. The user  hr  can subsequently invoke or reference all package objects declared in the specification of  emp_mgmt  without runtime recompilation. If recompiling  emp_mgmt  results in compilation errors, then the database returns an error and  emp_mgmt  remains invalid. The database also invalidates all objects that depend upon  emp_mgmt . If you subsequently reference one of these objects without explicitly recompiling it first, then the database recompiles it implicitly at run time. To recompile the body of the  emp_mgmt  package in the schema  hr , issue this statement: ALTER PACKAGE hr.emp_mgmt COMPILE BODY; This statement...
Post a Comment
Read more