Workflow Monitor Agent Generates Error "Column Id is NULL in LoadRules" When Using Workflow Component Mapped To S_PS_ADDR Table (Doc ID 2771846.1)

Last updated on APRIL 27, 2021

Applies to:

Symptoms

A custom workflow policy component has been created with workflow columns based on the S_PS_ADDR table.

When this component is associated to a workflow object with primary table set to S_CASE, the Workflow Monitor Agent task fails with an error.

The error message that occurs with this issue is:

The behaviour occurs as follows:

1. Create a custom workflow policy column based on the S_PS_ADDR table.

2. Add a custom workflow policy component under the workflow object with primary table set to S_CASE.

Additional information on how to create workflow policy components and columns for the above steps are outlined in Siebel Bookshelf > Business Process Framework: Workflow Guide > Chapter 15: Defining Custom Workflow Policies > Customizing Workflow Policy Objects

https://docs.oracle.com/cd/F26413_14/books/BPFWorkflow/defining-custom-workflow-policies.html#c_Customizing_Workflow_Policy_Objects_bm1338954

3. Run Generate Triggers task to drop and create triggers.

4. Add a new record in S_PS_ADDR by:

a.  Log into the Client UI

b.  Navigate to the Cases Screen/List view

c.  Add a new Case record

d.  For the new Case Record > go to the Address view table, then add a new address record

e.  This inserts a record into the S_ESCL_REQ table for the Workflow Policy

5. Start a task for the Workflow Monitor Agent component, it fails with the reported error.

Changes

Cause

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