Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

[12.1] adtasktim.sql output "ORA-01442: column to be modified to NOT NULL is already NOT NULL"

edited Feb 1, 2017 4:00AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓

Hi, experts

I got failed altering ad_task_timing table

while applying patch 23231676- R12.JTT.B.delta.4

Below is the information collected, please confirm.

I cannot figure out any clue to analysis this issue, please help.

====

Creating the AD_UTIL_PARAMS table...

Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.

DROP TABLE AD_UTIL_PARAMS

CREATE TABLE ad_util_params( worker_id          number       not null,

utility_name                                  varchar2(100)  not null,

task                                           varchar2(30)  not null,

status                                         varchar2(100) not null,

arguments                                     varchar2(2000) not null,

rowid1                                        varchar2(2000),

utility_status                                        number not null,

symbolic_arguments                             varchar2(2560) not null)

-adpatch.log-

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center