foalabs

How to change the Timezone for any specific OEM Agent In this post I am going to share how to change the timezone of an OEM Agent. Steps: 1) Check Current Timezone of the agent from the OEM repository database select target_name, timezone_region from sysman.mgmt_targets where target_name='funoracleapps.lab' order by 1,2; 2) Stop the Agent having wrong timezone emctl stop agent 3) Reset Timezone for agent emctl resetTZ agent It will give command to run on OEM repository like below Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Updating /oem/oracle/agent12c/agent_inst/sysman/config/emd.properties... Successfully updated /oem/oracle/agent12c/agent_inst/sysman/config/emd.properties. Login as the em repository user and run the  script: exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore') and commit the changes This can be done for example by logging into sqlplus and doing...

Queries related to Lookup in Oracle EBS Scripts: Lookup Information: select *   from apps.fnd_lookup_types_vl  Where lookup_type = '&lookup_type'; Values of  lookup: select *   from apps.fnd_lookup_values  Where lookup_type = '&lookup_type';  select disticnt a2.lookup_type,   a2.meaning "Lookup Type Meaning",   a2.description "Lookup Type Description",   a1.LOOKUP_CODE,   a1.meaning "Lookup Value Meaning",   a1.description "Lookup Value Description"   from apps.fnd_lookup_values a1,apps.fnd_lookup_types_VL a2   where a1.lookup_type='&name_of_lookup'   and a1.lookup_type=a2.lookup_type

How to Change the Interface Name in Linux Old Name: ens192 New Name: eth0 Check interface details /etc/init.d/network status shows this output: Configured devices: lo eth0 Currently active devices: lo enp192 Rename the interface  ip link set enp192 down ip link set enp192 name eth0 ip link set eth0 up Move configuration file and update the values mv /etc/sysconfig/network-scripts/ifcfg-{enp192,eth0} sed -ire "s/NAME=\"enp192\"/NAME=\"eth0\"/" /etc/sysconfig/network-scripts/ifcfg-eth0 sed -ire "s/DEVICE=\"enp192\"/NAME=\"eth0\"/" /etc/sysconfig/network-scripts/ifcfg-eth0

Item is shipped in Oracle Order Management but IB is not created We usually come across this scenario where Item is shipped in Oracle Order Management and the order line is closed but IB is not created. Below listed are possible checks that can be done to debug the reasons for this. 1. Item Setup Is your item set up as IB trackable? An item needs to be set up as IB trackable in Master and every child inventory org in order to interface the item's transaction to Oracle Installed Base. Check from form: INVENTORY (R) > Item > Organization Item > Service Tab > Attribute: Installed Base Trackable Check using query: SELECT segment1, organization_id, comms_nl_trackable_flag FROM mtl_system_items_b WHERE segment1 = '&your_item_number'; 2. Validate Shipment Does your Order Management shipment go through the inventory interface for a shippable item? Although your order line is closed, the inventory interface (kicked off from ship confirm trip stop interface) may not c...

How to Set or Change the Time Zone in Linux Server 1. Check  the Current Time Zone timedatectl      Local time: Mon 2020-07-06 22:22:40 +08   Universal time: Mon 2020-07-06 14:22:40 UTC         RTC time: Mon 2020-07-06 14:22:40        Time zone: Asia/Singapore (+08, +0800)      NTP enabled: yes NTP synchronized: yes  RTC in local TZ: no       DST active: n/a The output above shows that the system’s time zone is set to Singapore. The system time zone is configured by a link i.e. /etc/localtime file to a binary time zone’s identifier in the /usr/share/zoneinfo directory. $ ls -l /etc/localtime lrwxrwxrwx 1 root root 36 Jul  6 22:03 /etc/localtime -> ../usr/share/zoneinfo/Asia/Singapore 2. Change  the Time Zone Now Make sure to identify the exact time zone which needs to be set in Region/City format. To view all available time zones, use the timedatectl command or list the files...