My Oracle Support Banner

Error Status Not Set on Transmission if Workflow Triggered by Integration Results in an Error (Doc ID 888352.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


-- Problem Statement:

Inbound transmission does not set to ERROR status if the related workflow (etc. agents) errors.

Expect OTM to report error back to the integration layer if the related workflow failed.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

For example:
1- Create an OB agent (Trigger on Order Base - Modified) > (Action: any incorrect SQL update)
1- Create a new OB.
2- Generate it's TransOrder XML via integration manager.
3- Modify the XML (etc. ship unit weight)
4- Upload the XML file via integration manager.
5- Check the transmission > Set to PROCESSED.
6- Look at the logs > see the expected workflow error dur to the incorrect sql query.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.