Integration Technologies - JDE1 (MOSC)

MOSC Banner

Orchestrator: System Value "User Name" is sending NULL value

edited Sep 12, 2018 12:27PM in Integration Technologies - JDE1 (MOSC) 2 commentsAnswered ✓

Hello.

We created an Orchestration to update an external database. There is a field to register the user that is doing the update, and I put the "User Name" System Value for it. However, it is sending NULL value, and it causes an exception in AIS server, because the table that will be updated doesn't accept NULL value in that field. The exception is that:

Orchestration Aborted java.lang.Exception: ServiceRequest JDE_SREQ_CONN_SPV_INS_PESSOA: org.codehaus.groovy.runtime.InvokerInvocationException: java.sql.SQLException: ORA-01407: cannot update ("BASETST"."PESSOA"."USUARIO_ULT_ALTERACAO") to NULL

I found that, if we put a default value in "User Name", it works.

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