CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Not able to create auditing for DV pathcode in E920

edited May 3, 2016 7:10AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered ✓

Hi Team ,

I am working on CFR 21 and while enabling the auditing for pathcode DV i am unbale to do so,

I have provided all the essential acess to DD920, SY920 and TESTDTA owner.

following log update while enabling the audting for pathcode,

028/5776 MAIN_THREAD                      Tue May 03 16:18:06.362000jdb_ctl.c4196
Starting OneWorld

2028/3584 WRK:Starting jdeCallObject        Tue May 03 16:18:54.545000dbperfrq.c471
OCI0000178 - Unable to execute -

-- ORACLE TRIGGER FOR SIGNATURE, HEADER AND DETAIL TABLES

create or replace trigger SY920.F9500004_CFRS_RIUB

before insert or update on SY920.F9500004

for each row

begin

  :new.ADCFRUPMJ := trunc(sysdate);

  :new.ADCFRUPMT := to_number(to_char(sysdate, 'HH24MISS'));

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