CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Interconnected Reports are failing when its submitted via JDE scheduler

Interconnects Reports are running fine when user submits parent report manually however parent job is failing when its submitted via JDE Scheduler. This is happening with only interconnected report.

Error message:

OCI0000038 - Unable to bind where value - :KEY5


31720   Thu Jun 17 14:42:08.724450   dbbndwhe.c478

   OCI0000039 - Error - ORA-01036: illegal variable name/number


31720   Thu Jun 17 14:42:08.724516   dbinitrq.c905

   OCI0000137 - Failed to bind where-clause values - SELECT IBITM, IBLITM, IBAITM, IBMCU, IBSRP1, IBSRP2, IBSRP3, IBSRP4, IBSRP5, IBSRP6, IBSRP7, IBSRP8, IBSRP9, IBSRP0, IBPRP1, IBPRP2, IBPRP3, IBPRP4, IBPRP5, IBPRP6, IBPRP7, IBPRP8, IBPRP9, IBPRP0, IBCDCD, IBPDGR, IBDSGP, IBVEND, IBANPL, IBBUYR, IBGLPT, IBORIG, IBROPI, IBROQI, IBRQMX, IBRQMN, IBWOMO, IBSERV, IBSAFE, IBSLD, IBCKAV, IBSRCE, IBLOTS, IBOT1Y, IBOT2Y, IBSTDP, IBFRMP, IBTHRP, IBSTDG, IBFRGD, IBTHGD, IBCOTY, IBMMPC, IBPRGR, IBRPRC, IBORPR, IBBACK, IBIFLA, IBABCS, IBABCM, IBABCI, IBOVR, IBSHCM, IBCARS, IBCARP, IBSHCN, IBSTKT, IBLNTY, IBFIFO, IBCYCL, IBINMG, IBWARR, IBSRNR, IBPCTM, IBCMCG, IBFUF1, IBTX, IBTAX1, IBMPST, IBMRPD, IBMRPC, IBUPC, IBSNS, IBMERL, IBLTLV, IBLTMF, IBLTCM, IBOPC, IBOPV, IBACQ, IBMLQ,

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