APPLIES TO: Oracle Applications DBA - Version 12.0.0 to 12.1.3 [Release 12 to 12.1] SYMPTOMS: On application Release 12 When attempting to run autoconfig on APPS Tier, the following error…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A…
Read MoreIntroduction This blog explains how to get pricelist details for an item #Code# SELECT QLH_TL.NAME “List Price” ,QLH_TL.DESCRIPTION “Description” ,QLH_TL.VERSION_NO “Version” ,QLH_B.LIST_TYPE_CODE “List Type” ,QLH_B.CURRENCY_CODE “Curr Code” ,MSI.SEGMENT1 “Item Number”…
Read MoreOracle Cloud Shell is web based terminal access from Oracle Cloud console. It is free to use and provides access to Linux shell. Cloud shell is a small VM running…
Read Moreselect a.lookup_type Lookup_type_name,a.meaning Lookup_type_meaning,flv.lookup_code lookup_code_name,flv.meaning lookup_code_meaning, flv.description,flv.enabled_flag,flv.start_date_active,flv.end_date_active, decode(flv.created_by,’SEED_DATA_FROM_APPLICATION’,’Standard’,’Custom’),b.module_name from fnd_lookup_types_vl a, FND_APPL_TAXONOMY b, fnd_lookup_values_vl flv where 1=1 –and a.lookup_type=’BARGAINING_UNIT_CODE’ and a.module_id=b.module_id and upper(b.module_name) like ‘HCM%’ and a.lookup_type=flv.lookup_type –and flv.created_by=’SEED_DATA_FROM_APPLICATION’
Read MoreIssue : The register extract of goldengate failed with OCI Error 959 Observation : Cannot register extract in Goldengate . It abends with the OCI Error 959. Reason : ORA-00959:…
Read MoreIssue : The extract of the goldengate failed with the error : Error “OGG-00665 OCI Error executing fetch for TABLE (status = 1031-ORA-01031: insufficient privileges)” Observation : Goldengate Extract abends…
Read MoreEmployees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreRegional Display Selector Freezing In Oracle Apex The Region Display Selector is a Region component that provides page-level navigation control for other regions with the Region Display Selector property set to Yes. It can be configured to work in two modes: View Single RegionShow regions as tabs. Selecting a tab will make the corresponding region visible and hide the other selections. Scroll WindowAlways display all the regions on the page. Selecting a tab will scroll your window to the corresponding region. Technologies and Tools Used…
Read MoreAfter submitting concurrent request, the phase of the request is RUNNING and never completing. When we search for the database session, it is not having…
Read More