• descriptive flexfield


        1、 Descriptive elastic domain Foreword introduction: The essence of descriptive elastic domain is that the system reserves self-defined fields, and the system can use descriptive elastic domain to obtain important additional information unique to the business. The system may customize the descriptive elastic field to display the fields that store more information, and […]

  • Add tag to ebs for k8s and aws- add-ebs-tags-controller


    preface When using aws’s managed k8s–eks, you can’t avoid using aws’s LB and block storage. All the resources in the AWS public cloud can customize tags. The advantage of this is that the resources can be audited and counted in different dimensions according to the specific meaning of tag. For example, by department, by project, […]

  • Oracle EBS Tool Options: Turn off other forms modification methods


    Tool in Oracle EBS – Close other forms. If checked, users will close other forms when they open one, ensuring that only one form exists. If you want to turn this option on, you can do it in the following two ways 1) Individual responsibilities Add menu exclusions: Menu Exclusions Function: Fuction Name: Navigator: Disable […]

  • Script to find Whether patches is applied in Oracle EBS


    Write a PL / SQL script to find out if Oracle Appplications have applyed a series of patches when you are idle. It’s useful when you need to confirm the status of a bunch of patches. The script uses the varray data type in PL/SQL to store the patch numbers that need to be looked […]

  • Tuning OPP in EBS Oracle EBS 11i & R12


    Optimizing Indicators OPP (Output Post Processor) optimization in EBS can be started from the following three aspects: Threads Processes Jvm memory argument Threads & Processes The settings for Threads and Processes can be seen on the page defined by the Concurrency Manager as follows:Among them, 2 represents the number of service threads, and the max_threads […]

  • Query to find profile options values in Oracle EBS


    The following scripts can be used to find specific profile options settings in EBS. In sql, the profile options found are concurrent% OPP% sqlSELECT FPOT.USER_PROFILE_OPTION_NAME, DECODE(FPOV.LEVEL_ID, 10001, ‘Site’, 10002, ‘Application’, 10003, ‘Responsibility’, 10004, ‘User’, 10005, ‘Server’, 10006, ‘Org’, 10007, DECODE(TO_CHAR(FPOV.LEVEL_VALUE2), ‘-1’, ‘Responsibility’, DECODE(TO_CHAR(FPOV.LEVEL_VALUE), ‘-1’, ‘Server’, ‘Server+Resp’)), ‘UnDef’), DECODE(TO_CHAR(FPOV.LEVEL_ID), ‘10001’, ”, ‘10002’, APP.APPLICATION_SHORT_NAME, ‘10003’, RSP.RESPONSIBILITY_KEY, ‘10004’, […]

  • Cloning Oracle EBS R12.2 using Rapid Clone


    Cloning instructions Reference Documents Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (document ID 1383621.1)Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (document ID 1330701.1) introduce Cloning is a process of replicating existing environments into other environments for testing and other purposes. For EBS, Oracle provides Rapid Clone tools […]