Monday, February 28, 2022

Row Count Of All Partitions Of A Table

 

Find Row Count Of All Partitions Of A Table

Query :- partition_count.sql 

set serverout on size 1000000
set verify off
declare
sql_stmt varchar2(1024);
row_count number;
cursor get_tab is
select table_name,partition_name
from dba_tab_partitions
where table_owner=upper('&&TABLE_OWNER') and table_name='&&TABLE_NAME';
begin
dbms_output.put_line('Checking Record Counts for table_name');
dbms_output.put_line('Log file to numrows_part_&&TABLE_OWNER.lst ....');
dbms_output.put_line('....');
for get_tab_rec in get_tab loop
BEGIN
sql_stmt := 'select count(*) from &&TABLE_OWNER..'||get_tab_rec.table_name
||' partition ( '||get_tab_rec.partition_name||' )';

EXECUTE IMMEDIATE sql_stmt INTO row_count;
dbms_output.put_line('Table '||rpad(get_tab_rec.table_name
||'('||get_tab_rec.partition_name||')',50)
||' '||TO_CHAR(row_count)||' rows.');
exception when others then
dbms_output.put_line
('Error counting rows for table '||get_tab_rec.table_name);
END;
end loop;
end;
/
set verify on

SQL> @partition_count.sql
Enter value for table_owner: ABCD
Enter value for table_name: ABCD
Checking Record Counts for table_name
Log file to numrows_part_ABCDlst ....
....
Table ABCD(P_ADCH_CL_201301)                  118150 rows.
Table ABCD(SYS_P12259)                        327701 rows.
Table ABCD(SYS_P12264)                        324872 rows.
Table ABCD(SYS_P12269)                        315435 rows.
Table ABCD(SYS_P12274)                        333191 rows.
Table ABCD(SYS_P12279)                        369279 rows.
----------
----------
----------
PL/SQL procedure successfully completed.


Sunday, February 20, 2022

Oracle E-Business Suite Technology Articles and links


Oracle E-Business Suite Technology 


EBS 12.2 Now Certified with Database Release Update 19.14 - All Platforms (Jan 2022)

Posted:

Certification of Oracle Database Release Update(DBRU) 19.14 (19.14.0.0.220118-Jan2021) on all platforms (UNIX and MS Windows) with Oracle E-Business Suite Release 12.2 on-premises.

[This is a summary only; visit this blog for complete articles, links, and more]

Quarterly EBS Upgrade Recommendations: August 2021 Edition

Posted:

Here are our latest upgrade recommendations for Oracle E-Business Suite updates and technology stack components.

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.1.3 Now Certified with Database Release Update 19.12 (Jul 2021)

Posted:

Oracle Database Release Update 19.12 (19.12.0.0.210720-Jul2021) is now certified with Oracle E-Business Suite Release 12.1.3 on-premises.

[This is a summary only; visit this blog for complete articles, links, and more]

July 2021 Updates to EBS Technology Codelevel Checker (ETCC)

Posted:

ETCC has been updated to include bug fixes and patching combinations.

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.1.3 migration to Oracle Linux 8 and Red Hat Enterprise Linux 8 now certified

Posted:

Oracle E-Business Suite (EBS) Release 12.1.3 is now certified for migrations to Oracle Linux 8 and Red Hat Enterprise Linux.

[This is a summary only; visit this blog for complete articles, links, and more]

EBS Technology Blog is Migrating to a New Blogging Platform

Posted:

All blog posts that were previously published here are being migrated.

[This is a summary only; visit this blog for complete articles, links, and more]

Oracle Application Management Pack Release 13.4 Release Update 1 Now Available

Posted:

As a follow-up to a prior announcement, we are pleased to announce that the Oracle Application Management Pack (AMP) 13.4.1.0.0 Release Update 1 is now available for download. To obtain latest...

[This is a summary only; visit this blog for complete articles, links, and more]

July 2021 FMW Consolidated Patches for EBS 12.2

Posted:

To assist Oracle E-Business Suite (EBS) customers with obtaining required Oracle Fusion Middleware (FMW) patches, we are pleased to announce the availability of two recently released FMW re-packaged...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.7.0_311 Certified with EBS Releases 12.2 and 12.1

Posted:

We are pleased to announce that the Java Runtime Environment (JRE) 1.7.0_311 (7u311) on the JRE 7 codeline is now certified with Oracle E-Business Suite (EBS) Releases 12.2 and 12.1. However, Oracle...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.8.0_301 Certified with EBS Releases 12.2 and 12.1

Posted:

We are pleased to announce that the Java Runtime Environment (JRE) 1.8.0_301 (8u301) on the JRE 8 codeline is now certified with Oracle E-Business Suite (EBS) Releases 12.2 and 12.1. This JRE release...

[This is a summary only; visit this blog for complete articles, links, and more]

Critical Patch Update for July 2021 Now Available

Posted:

The Critical Patch Update (CPU) for July 2021 was released on 20 July 2021. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest...

[This is a summary only; visit this blog for complete articles, links, and more]

New Patches to Resolve Issue With EBS Desktop Clients Using JRE 8u291 or Later

Posted:

After you upgrade your Oracle E-Business Suite (EBS) desktop clients to JRE 8u291 or later, attempting to open a URL from Oracle Forms or any Java applet in Oracle E-Business Suite may appear to do...

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.2 now certified with Oracle Linux 8 and Red Hat Enterprise Linux 8

Posted:

I am pleased to announce that Oracle E-Business Suite (EBS) Release 12.2 (12.2.3 or later) is now certified on Oracle Linux 8 and Red Hat Enterprise Linux 8. The Unbreakable Enterprise Kernel (UEK),...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.10 Bundle 3 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

Quarterly EBS Upgrade Recommendations: May 2021 Edition

Posted:

Here are our latest upgrade recommendations for Oracle E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's product...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.9 Bundle 9 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.7 Bundle 13 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.1.3 Now Certified with Database Release Update 19.11 (Apr 2021)

Posted:

We are pleased to announce that Oracle Database Release Update 19.11 (19.11.0.0.210420-Apr2021) is now certified with Oracle E-Business Suite Release 12.1.3 on-premises. For additional details, refer...

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.2 Now Certified with Database Release Update 19.11 (Apr 2021)

Posted:

We previously announced the release of the April 2021 updates for the E-Business Suite (EBS) Technology Codelevel Checker (ETCC). The April 2021 update for ETCC includes the certification of Oracle...

[This is a summary only; visit this blog for complete articles, links, and more]

April 2021 Updates to EBS Technology Codelevel Checker (ETCC)

Posted:

The E-Business Suite Technology Codelevel Checker (ETCC) utility identifies patches that need to be applied to your Oracle E-Business Suite 12.2 technology stack for the application and database...

[This is a summary only; visit this blog for complete articles, links, and more]

April 2021 FMW Consolidated Patches for EBS 12.2

Posted:

To assist Oracle E-Business Suite (EBS) customers with obtaining required Oracle Fusion Middleware (FMW) patches, we are pleased to announce the availability of two recently released FMW re-packaged...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.7.0_301 Certified with EBS Releases 12.2 and 12.1

Posted:

The Java Runtime Environment 1.7.0_301 (7u301) on the JRE 7 codeline is now certified with Oracle E-Business Suite Releases 12.2 and 12.1. Note that Oracle strongly recommends that you migrate to JRE...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.8.0_291 Certified with EBS Releases 12.2 and 12.1

Posted:

We are pleased to announce that the Java Runtime Environment (JRE) 1.8.0_291 (8u291) on the JRE 8 codeline is now certified with Oracle E-Business Suite Releases 12.1 and 12.2. This update is...

[This is a summary only; visit this blog for complete articles, links, and more]

Critical Patch Update for April 2021 Now Available

Posted:

The Critical Patch Update (CPU) for April 2021 was released on 20 April 2021. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest...

[This is a summary only; visit this blog for complete articles, links, and more]

Update to EBS Electronic Technical Reference Manual (eTRM)

Posted:

The Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) is a repository of Oracle E-Business Suite database object definitions and their dependency information. The eTRM contains a...

[This is a summary only; visit this blog for complete articles, links, and more]

March 2021 Update Available for ECC

Posted:

Our Enterprise Command Center development colleagues have recently announced the March 2021 update of the Oracle E-Business Suite Enterprise Command Centers. Instructions for installing the Oracle...

[This is a summary only; visit this blog for complete articles, links, and more]

Microsoft Windows Server 2016 and Visual Studio 2019 certified with EBS 12.2 and 12.1

Posted:

I'm pleased to announce that Oracle E-Business Suite (EBS) Releases 12.2.3 (or later) and 12.1.3 are now certified on Microsoft Windows Server 2016 and Visual Studio 2019 on x86-64. Installations of...

[This is a summary only; visit this blog for complete articles, links, and more]

New EBS 12.2 Upgrade Readiness Checker Tool for Database Tier (EURC-DT)

Posted:

This is the second of two articles about a pair of brand new tools designed to increase the productivity of Oracle E-Business Suite (EBS) DBAs and related staff when upgrading and patching EBS...

[This is a summary only; visit this blog for complete articles, links, and more]

New EBS Technology Patch Automation Tool for Application Tier (ETPAT-AT)

Posted:

This is the first of two articles about a pair of brand new tools designed to increase the productivity of Oracle E-Business Suite (EBS) DBAs and related staff when upgrading and patching EBS...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.9 Bundle 8 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.10 Bundle 2 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.5 Bundle 24 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.7 Bundle 12 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.6 Bundle 26 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

Quarterly EBS Upgrade Recommendations: February 2021 Edition

Posted:

Here are our latest upgrade recommendations for Oracle E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's product...

[This is a summary only; visit this blog for complete articles, links, and more]

Reminder: EBS 12.1.3 Moves to Sustaining Support on Jan 1, 2022

Posted:

Oracle E-Business Suite (EBS) 12.1 has been in Premier Support since May 2009. EBS 12.1.3 will move to to Sustaining Support on January 1, 2022. See the following for more information: Oracle...

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.1.3 Now Certified with Database Release Update 19.10 (Jan 2021)

Posted:

We are pleased to announce that Oracle Database Release Update 19.10 (19.10.0.0.210119 ) is now certified with Oracle E-Business Suite Release 12.1.3 on-premises. For additional details, refer to...

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.2 Now Certified with Database Release Update 19.10 (Jan 2021)

Posted:

We previously announced the release of the February 2021 updates for the E-Business Suite (EBS) Technology Codelevel Checker (ETCC). This ETCC update includes the certification of Oracle Database...

[This is a summary only; visit this blog for complete articles, links, and more]

February 2021 Updates to EBS Technology Codelevel Checker (ETCC)

Posted:

The E-Business Suite Technology Codelevel Checker (ETCC) utility identifies patches that need to be applied to your Oracle E-Business Suite 12.2 technology stack for the application and database...

[This is a summary only; visit this blog for complete articles, links, and more]

February 2021 Update to Integrated SOA Gateway for EBS 12.1.3

Posted:

I am pleased to announce availability of consolidated Patch 32172877:R12.OWF.B - ISG Consolidated Patch for 12.1.3 (21_1_3) for Oracle E-Business Suite Integrated SOA Gateway(ISG) for Oracle...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.7.0_291 Certified with EBS Releases 12.2 and 12.1

Posted:

The Java Runtime Environment 1.7.0_291 (7u291) on the JRE 7 codeline is now certified with Oracle E-Business Suite Releases 12.2 and 12.1. Note that Oracle strongly recommends that you migrate to JRE...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.8.0_281 Certified with EBS Releases 12.2 and 12.1

Posted:

We are pleased to announce that the Java Runtime Environment (JRE) 1.8.0_281 (8u281) on the JRE 8 codeline is now certified with Oracle E-Business Suite Releases 12.1 and 12.2. This update is...

[This is a summary only; visit this blog for complete articles, links, and more]

Critical Patch Update for January 2021 Now Available

Posted:

The Critical Patch Update (CPU) for January 2021 was released on 19 January 2021. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest...

[This is a summary only; visit this blog for complete articles, links, and more]

Upcoming EBS R12 Patching Requirements on Solaris SPARC

Posted:

Beginning on February 26th 2021, Oracle E-Business Suite patches for Releases 12.2 and 12.1 on the Oracle Solaris on SPARC (64-bit) platform will be built with an updated operating system security...

[This is a summary only; visit this blog for complete articles, links, and more]

EBS 12.2.10 with Database 19c VM Virtual Appliance for On-Premises

Posted:

We are excited to share the news of our latest VM Virtual Appliance on-premises, which contains Oracle E-Business Suite Release 12.2.10 and Oracle Database 19c. You can download this from the Oracle...

[This is a summary only; visit this blog for complete articles, links, and more]

Quarterly EBS Upgrade Recommendations: November 2020 Edition

Posted:

Here are our latest upgrade recommendations for Oracle E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's product...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.7 Bundle 11 Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

New OA Framework 12.2.9 Bundle 5 Now Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

Oracle Database Release Update 19.9 (October 2020) Now Certified With EBS 12.1.3

Posted:

We are pleased to announce that Oracle Database Release Update 19.9 (19.9.0.0.201020) is now certified with Oracle E-Business Suite Release 12.1.3 on-premises. For additional details, refer to...

[This is a summary only; visit this blog for complete articles, links, and more]

Oracle Database 19c Now Certified with EBS 12.2 and 12.1 for Oracle Solaris on x86-64

Posted:

Oracle E-Business Suite Release 12.2 (12.2.3 and later) and 12.1.3 are now certified with Oracle Database 19c on Oracle on Solaris x86-64 as a database tier only platform. The Database 19c certified...

[This is a summary only; visit this blog for complete articles, links, and more]

October 2020 Updates to EBS Technology Codelevel Checker (ETCC)

Posted:

The E-Business Suite Technology Codelevel Checker (ETCC) utility identifies patches that need to be applied to your Oracle E-Business Suite 12.2 technology stack for the application and database...

[This is a summary only; visit this blog for complete articles, links, and more]

Prebuilt EBS 12.1 and 12.2 SOA Integrations Now Certified with Oracle SOA Suite 12.2.1.4

Posted:

Oracle SOA Suite is a comprehensive software suite from Oracle Fusion Middleware that lets you to build, deploy, and manage integrations using Service Oriented Architecture (SOA). Oracle BPEL Process...

[This is a summary only; visit this blog for complete articles, links, and more]

Data Masking Now Certified for EBS 12.1.3 with DB 12.1.0.2 or 11.2.0.4 and EM 13cR4

Posted:

We're pleased to announce the certification of the EBS 12.1.3 Data Masking Template with Oracle Database 12.1.0.2 or 11.2.0.4 and EM 13cR4. The updated template included with this certification...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.7.0_281 Certified with EBS Releases 12.2 and 12.1

Posted:

The Java Runtime Environment 1.7.0_281 (7u281) on the JRE 7 codeline is now certified with Oracle E-Business Suite Releases 12.2 and 12.1. Note that Oracle strongly recommends that you migrate to JRE...

[This is a summary only; visit this blog for complete articles, links, and more]

JRE 1.8.0_271 Certified with EBS Releases 12.2 and 12.1

Posted:

We are pleased to announce that the Java Runtime Environment (JRE) 1.8.0_271 (8u271) on the JRE 8 codeline is now certified with Oracle E-Business Suite Releases 12.1 and 12.2. This update is...

[This is a summary only; visit this blog for complete articles, links, and more]

Critical Patch Update for October 2020 Now Available

Posted:

The Critical Patch Update (CPU) for October 2020 was released on 20 October 2020. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest...

[This is a summary only; visit this blog for complete articles, links, and more]

OA Framework 12.2.10 Bundle 1 Released

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

JDeveloper Patch for OA Framework in EBS 12.2.10 Released

Posted:

The September 2020 release of Oracle E-Business Suite Release 12.2.10 includes major updates to our Oracle Application Framework (OA Framework, OAF, or FWK) development tools and infrastructure....

[This is a summary only; visit this blog for complete articles, links, and more]

Reminder: Error Correction Support for Oracle Database 12.1.0.2

Posted:

E-Business Suite customers should run on a database that is covered by Error Correction Support (ECS). Premier Support for Oracle Database 11.2.0.4 ended July 31, 2018. Oracle Database 12.1.0.2 is...

[This is a summary only; visit this blog for complete articles, links, and more]

Reminder: End of Error Correction Support for Oracle Database 11.2.0.4

Posted:

E-Business Suite customers should run on a database that is covered by Error Correction Support (ECS). Premier Support for Oracle Database 11.2.0.4 ended January 31, 2015. Oracle Database 11.2.0.4...

[This is a summary only; visit this blog for complete articles, links, and more]

Reminder: Upgrade Oracle Internet Directory 11.1.1.x to 12.2.x

Posted:

Oracle Internet Directory (OID) is part of a suite of products called Oracle Identity and Access Management (IAM). OID 11.1.1.x is covered by Premier Support until December 2020 and Extended Support...

[This is a summary only; visit this blog for complete articles, links, and more]

Reminder: Upgrade Oracle Access Management from 11.2.3 to 12.2.x

Posted:

Oracle Access Management (OAM) is part of a suite of products called Oracle Identity and Access Management (IAM). OAM 11.1.2.x is covered by Premier Support until December 2020 and Extended Support...

[This is a summary only; visit this blog for complete articles, links, and more]

New OA Framework 12.2.4 Bundle 22 Now Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

New OA Framework 12.2.6 Bundle 25 Now Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]

Data Masking Now Certified for EBS 12.2 with DB 12.1.0.2 or 11.2.0.4 and EM 13cR4

Posted:

We're pleased to announce the certification of the EBS 12.2 Data Masking Template with Oracle Database 12.1.0.2 or 11.2.0.4 and EM 13cR4. The updated template included with this certification...

[This is a summary only; visit this blog for complete articles, links, and more]

New OA Framework 12.2.9 Bundle 4 Now Available

Posted:

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated...

[This is a summary only; visit this blog for complete articles, links, and more]