You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I need to see the column comments for the FLOWID column for the FUSION.ESS_REQUEST_HISTORY table

Summary:

Problem: The AutoPost ESS job spawns other ESS jobs - Post Journals and Post Journals for Single Ledger. We need to verify that all spawned jobs have succeeded before any subsequent jobs are triggered.

Possible workaround: Run a query against the FUSION.ESS_REQUEST_HISTORY table joining the row for the AutoPost job with the rows for the spawned jobs. The ABSPARENTID column cannot be used for the join. However, it appears that the FLOWID column can be used.

Has anyone done this - or have the column comments that confirm or refute this possible workaround?

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!