Posts Tagged ‘Oracle EBS’

Change Allowed In Items Primary UOM in Oracle EBS R12.2.9 And Higher Versions

December 1st, 2020, posted in Oracle EBS Application
Share

Allowed to change Item’s Primary UOM in Oracle EBS R12.2.9 and higher versions

 

Prior to Oracle EBS R12.2.9, Item’s Primary Unit Of Measure(UOM) can be selected only at the time of item creation and cannot be updated once the item is saved.

There is a new feature added in Oracle EBS 12.2.9 latest version, where it is allowed change item’s primary UOM after the item is created When no transactions exist like material transactions, Sales Orders, Purchase Orders, Work Orders, Onhand etc.,

Item’s UOM won’t be updated if there are transactions or related records exists. This is to Maintain data Integrity and avoid corruption.

  1. Creating “VM TEST” master item with primary uom as Each.

oracle application,oracle ebs,oracle master item,oracle inventory master items,oracle apps dba

2. Extending “VM TEST” item to M1 inventory org.

oracle application,oracle ebs,oracle master item,oracle inventory master items,oracle apps dba

3. Query “VM TEST” item in M1 inventory org.

oracle application,oracle ebs,oracle master item,oracle inventory master items,oracle apps dba

Initially the item is created with primary UOM as “Each”. This item is newly created and there are no transactions exist.

4. Change primary uom from EACH to EA in the master item form ( primary UOM is master controlled item attribute) -> A concurrent request will be submitted when UOM is changed and saved.

oracle application,oracle ebs,oracle master item,oracle inventory master items,oracle apps dba

5. It runs “EGO Spreadsheet Java Concurrent Program” process and completes normal when the UOM is changed.

oracle application,oracle ebs,oracle master item,oracle inventory master items,oracle apps dba,EGO Spreadsheet Java Concurrent Program

Note: The concurrent program will have error like below if there are any transactions exists.

MESSAGE NAME: INV_UOM_CANNOT_UPDATE
ERROR MESSAGE : You cannot update UOM field when the inventory transactions exist in current or one of child orgs.

6. Re-Query “VM TEST” in the organization items form for M1 inventory org. You can see that primary UOM is changed to EA

oracle application,oracle ebs,oracle master item,oracle inventory master items,oracle apps dba,UOM is changed

Share

Decoded INST_TOP Oracle R12 INSTANCE_HOME

June 13th, 2020, posted in Oracle
Share

 

Features on this R12 INST_TOP

-All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top

  • All configuration files have been moved to INST_TOP
    like
    DBc file
    All the http related config files
    appsweb.cfg
    All the start or stop scripts
    all the OC4J related config files

-we can now share the Apps and technology stack among multiple nodes and even instances (Dev,Test, Production) as all the log and config are located in this top.We will have INST_TOP for each context.

-Configuration and log files are co-located

-Easier collection of instance state
-Minimize disk usage and maximize performance

Filesystem look

/inst/apps/ ($INST_TOP)
/admin
/scripts ($ADMIN_SCRIPTS_HOME) All the start and stop are here
/appl ($APPL_CONFIG_HOME) All the apps env are here
/fnd/12.0.0/secure ($FND_SECURE) dbc file lis located here
/certs
/logs ($LOG_HOME) all the logs are located
/ora ($ORA_CONFIG_HOME)
/10.1.2
/10.1.3 ($ORACLE_CONFIG_HOME) all the techstack(oacore,forms) related config files
/pids
/portal
/rgf

Some more changes to variable

OA_HTML =$COMMON_TOP/webapps/oacore/html
JAVA_TOP=$COMMON_TOP/java/classes
AF_JLIB=$COMMON_TOP/java/lib
JAVA_BASE=$COMMON_TOP/java/

Advantage  of INST_TOP

-Clear distinction between the shared file system and the file system unique to an instance
-Ability to share code (Apps, technology stack) among multiple  nodes and even instances (Development ,Test, Production)
-Enables split ownership of applications and technology stack file systems
-Improves code safety by making shared file system read-only while not patching
-Configuration and log files are co-located
-Easier collection of instance state
-Ability to use network or local storage for various file system portions
-Minimize disk usage and maximize performance

R12.2 Changes

-R12.2 contains the Fusion Middleware 11g tech-stack. The logfile and configuration files is located in that Oracle Home

Concurrent Manager log/out files have been moved in Non editioned File system

Where to Put INST_TOP in shared file system

It is recommended to put INST_TOP on local filesystem  in shared APPL_TOP filesystem  architecture. This is because of the Apache mutex problem.Apache performance is highly sensitive to mutex file access latency, and at higher loads is also sensitive to I/Os per second. In case you have INST_TOP on shared filesystem, it is suggested to point these context variable to local file-system

s_lock_pid_dir
s_pids_dir
s_web_pid_file

 

 

Conclusion

Hope you like the post on R12 INST_TOP, all the advantages and R12.2 changes.  Please do provide the feedback.

 

 

Share

Query To Find Legal Entity Organization Company Code

February 3rd, 2020, posted in Oracle Queries
Share
SELECT
xep.legal_entity_id "Legal Entity ID",
xep.name "Legal Entity",
hr_outl.name "Organization Name",
hr_outl.organization_id "Organization ID",
hr_loc.location_id "Location ID",
hr_loc.country "Country Code",
hr_loc.location_code "Location Code",
glev.flex_segment_value "Company Code"
FROM
xle_entity_profiles xep,
xle_registrations reg,
--
hr_operating_units hou,
-- hr_all_organization_units hr_ou,
hr_all_organization_units_tl hr_outl,
hr_locations_all hr_loc,
--
gl_legal_entities_bsvs glev
WHERE
1=1
AND xep.transacting_entity_flag = 'Y'
AND xep.legal_entity_id = reg.source_id
AND reg.source_table = 'XLE_ENTITY_PROFILES'
AND reg.identifying_flag = 'Y'
AND xep.legal_entity_id = hou.default_legal_context_id
AND reg.location_id = hr_loc.location_id
AND xep.legal_entity_id = glev.legal_entity_id
--
-- AND hr_ou.organization_id = hou.business_group_id
AND hr_outl.organization_id = hou.organization_id
ORDER BY hr_outl.name


Share

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported

September 2nd, 2018, posted in Oracle, Solaris
Share

[orastg@eboso bin]$ perl adcfgclone.pl dbconfig /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml

                      Copyright (c) 2002 Oracle Corporation

                        Redwood Shores, California, USA

                         Oracle Applications Rapid Clone

                                  Version 12.0.0

                       adcfgclone Version 120.31.12010000.8

 Enter the APPS password :

 Running Rapid Clone with command:

perl /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl java=/clone/oracle/product/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/clone/oracle/product/11.2.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml showProgress contextValidated=false

Running:

perl /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl java=/clone/oracle/product/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/clone/oracle/product/11.2.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml showProgress contextValidated=false

APPS Password :

 Beginning dbconfig Apply – Fri May 17 01:37:14 2013

 /clone/oracle/product/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/clone/oracle/product/11.2.0/oui -classpath /clone/oracle/product/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/java:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/share.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyDatabase -e /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml -stage /clone/oracle/product/11.2.0/appsutil/clone   -showProgress   -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /clone/oracle/product/11.2.0/appsutil/log/CLONE_ebso/ApplyDatabase_05170137.log

  |      0% completed       RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again…

 ERROR while running Apply…

 ERROR: Failed to execute /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl

  Please check logfile.

[orastg@ebso bin]$


Summary 
During the post cloning steps at the dbTier of an E-Business Suite R12.1.3 i get the error:

RC-20200 Fatal: Could Not Find Unzip. At This Time Only Native UnZip 5.X is Supported

I check my unzip version:
$ unzip -version 
$ which uzip 
And i found out that i have Unzip version 6 !!

But at the source system i do have the version UnZip 5.52

Workaround: 
Copy from the source system the unzip version 5.52 and put it under target system:
/usr/bin/unzip 
/system_base_directory/db/tech_st/11.2.0/bin/unzip 

MyOracle Support offers a solution with a patch:
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported [ID 1410514.1] 

Tip: 
After solving the issue with unzip and running again the dbTier post cloning steps you might get the error:

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
          

  [INSTANTIATE PHASE]
  AutoConfig could not successfully instantiate the following files:
    Directory: /u01/saudi_arabia_ar/db/tech_st/11.2.0/appsutil/install/PRODAR_ebsdbprd
      adcrdb.sh               INSTE8


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDBTechStack

The problem now is that the file:
/u01/saudi_arabia_ar/db/tech_st/11.2.0/appsutil/template/adcrdb.sh is Deleted from the first failed clone process.

Workaround:
Copy again all the template directory from the source system and put it to the “target” system.
Run again $ perl adcfgclone.pl dbTier

Share

Oracle EBS Query To Check FND Languages Installed in Oracle

June 26th, 2018, posted in Oracle Queries
Share

 

clear columns
set lines 180
set pages 50
col LANGUAGE_CODE for a15
col NLS_LANGUAGE for a20
col ISO_LANGUAGE for a15
col INSTALLED_FLAG for a15
SELECT LANGUAGE_CODE,NLS_LANGUAGE, ISO_LANGUAGE,INSTALLED_FLAG 
FROM APPS.FND_LANGUAGES 
WHERE INSTALLED_FLAG IN ('B','I');
Share