CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

EnterpriseOne Table Auditing

edited Jun 19, 2015 9:55AM in CNC, DB and Operating System - JDE1 (MOSC) 5 commentsAnswered

Hello All,

We are in the process of enabling Audit tool in 9.1. We have created the necessary ocms and created a Non-Julian data source also. But when i m trying to enable Audit through P9500001 it is giving me error as shown below. Please help.

2648/3856 WRK:Starting jdeCallObject        Mon Feb 10 02:43:27.411000dbperfrq.c471
OCI0000178 - Unable to execute -

-- ORACLE TRIGGER FOR SIGNATURE, HEADER AND DETAIL TABLES

create or replace trigger SY910.F9500006_CFRS_RIUB

before insert or update on SY910.F9500006

for each row

begin

  :new.STCFRUPMJ := trunc(sysdate);

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

end;

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