CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Direct SQL Query Insert Into Database Oracle JD Edward

edited Nov 12, 2019 4:02AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered ✓

Dear Experts,

I'm curious and want to direct insert sql query from external apps to JDE table

For example :
Insert into WO routing (F3112) table
Insert into Inventory Issues Inbound Transactions (F3111Z1) table

Insert into Completion Inbound Transactions (F4801Z1) table

Etc..

Is it okay? Or I should insert into table using inbound menu?

What I'm afraid of is that if I directly insert into oracle table, it will affect to database performance and JDE performance

Sincerely,

Oviedityanto

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