Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Author: Syed Saad Ali

October 1, 2017 ORA-01442: column to be modified to NOT NULL is already NOT NULL 
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR

Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL

sql> alter table HR.employees modify UID not null;

ORA-01442: column to be modified to NOT NULL is already NOT NULL

SOLUTION

ALTER TABLE table_name 
  ADD CONSTRAINT constraint_name CHECK(column_name IS NOT NULL); 

OR

ALTER TABLE hr.employees 
  ADD CONSTRAINT nn_uid_hr_addrsdtls CHECK(UID IS NOT NULL); 

October 1, 2017 How To Move Table to Different TableSpace
APPS DBAAppsDBA ScriptsDatabase ScriptsScripts

How To Move Table to Different TableSpace

 

SYNTAX

ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);

 

EXAMPLE

ALTER TABLE hr.employee_details move TABLESPACE hr;

OR

ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);

 

September 16, 2017 What’s New in EBS 12.2.7?
NEWS AND UPDATES

What’s New in EBS 12.2.7?

By: Steven Chan| Senior Director

EBS 12.2.7 is the latest update to E-Business Suite 12.2. It includes functionality enhancements, error corrections, and statutory and regulatory updates in a consolidated suite-wide patch set.

Release 12.2.7 is cumulative and includes updates released previously for earlier EBS releases including 12.1.3, 12.0, and 11.5.10.  It includes bug fixes for the following major product areas:

  • Applications Technology
  • Asset Lifecycle Management  
  • Channel Revenue Management  
  • Financials
  • Human Capital Management  
  • Lease and Finance Management  
  • Logistics
  • Manufacturing
  • Master Data Management  
  • Order Management & Contracts
  • Procurement
  • Contract Lifecycle Management for Public Sector
  • Projects
  • Sales, Marketing, and eCommerce
  • Service Management  
  • Value Chain Planning

EBS 12.2.7 includes new functionality for the following major product families:

  • Iprocurement
  • Procurement
  • Project Procurement
  • Projects
  • Order Management  
  • Logistics
  • Manufacturing
  • Value Chain Planning
  • Asset Management

For a complete list of new features, refer to:

Source:https://blogs.oracle.com/stevenchan/whats-new-in-ebs-1227?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+OracleE-BusinessSuiteTechnology+%28Oracle+E-Business+Suite+Technology%29

 

 

 

September 15, 2017 What is Oracle E-Business Suite on Oracle Cloud?
NEWS AND UPDATES

What is Oracle E-Business Suite on Oracle Cloud?

By: Nadia Bendjedou| Vice President – EBS Strategy

You can think of running Oracle E-Business Suite on Oracle Cloud as running exactly the same Oracle E-Business Suite applications that you run on-premises in your datacenter today –  the same E-Business Suite applications you may have customized – on a combination of Oracle’s Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings.

The main choices are:

  • Infrastructure: The Oracle Compute Cloud Service part of IaaS provides a highly scalable, competitively-priced compute capacity that can be used to host your application tier and (optionally) your database tier.
  • Infrastructure + Database: The Database Cloud Service part of PaaS can be used to run your database tier, allowing you to provision your chosen database configuration quickly and easily.
  • Infrastructure + Database + Application Management:  Optionally, you can get assistance with Oracle E-Business Suite applications and database management by deploying managed services on top of the infrastructure and platform services:
    • Oracle Managed Cloud Services (OMCS) manages your Oracle E-Business Suite environment on Oracle Cloud. The complete lifecycle management provided by this service includes patching, cloning, and regular technical/functional updates, along with an industry-leading application availability SLA.  [OMCS will also keep you up-to-date with the most recent security patches and latest product releases, so that you can both remain secure and benefit from the newest innovations.]
    • Alternatively, you can choose a partner to run your applications and perform applications DBA tasks such as patching and cloning, as well as upgrades and technology updates.

For more information, visit the Oracle E-Business Suite on Oracle Cloud Landing Page.

Source: https://blogs.oracle.com/ebsandoraclecloud/what-is-oracle-e-business-suite-on-oracle-cloud