My Oracle Support Banner

SRProc Component Not Picking Records According To SCEHD_START_DT (Doc ID 2729771.1)

Last updated on JUNE 25, 2021

Applies to:

Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.

Symptoms

Server Request Processor (SR PROC) Component is not picking records according to SCEHD_START_DT sometimes; while it functions as expected at other times.

Issue can be backtracked with below steps:
1. Records gets created in S_SRM_REQUEST table and stamps SCEHD_START_DT as in UTC date time.
2. When issue occurs[Jobs not processed] it compares SCEHD_START_DT with server time zone which is in EST US time zone and does not process the records.

Component Log has following DB error:

 

Cause

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
Symptoms
Cause
Solution
References


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