My Oracle Support Banner

Need To Schedule Collect Revenue Recognition Information With SQL Calculated Start Date Err ORA-0103 (Doc ID 1573031.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Cost Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


We have concurrent program Collect Revenue Recognition Information scheduled in a request set but need to change the start date from the default start date to a SQL-calculated date in the request set.

When attempting to do this, an error is given. Why are we receiving an error and how can we schedule this request with a SQL-driven date?

the following error occurs.

APP-FND-01564: ORA-01036 illegal variable name/number
  The SQL being executed at time of the err:
  Request set parameters:
  Start date is defined as SQL :
  select fnd_date.date_to_displaydate(start_date)
  from gl.gl_periods
  where start_date   and end_date >= trunc(sysdate-1)

1. setup a request set using the following Program:
  Autoinvoice Master Program
  Revenue Recognition Master Program
  Record Order Management Transactions
  Collect Revenue Recognition Information
  Generate COGS Recognition Events

2. For the concurrent program: Collect Revenue Recognition Information, scheduled in a request set change the start date from the default start date to a SOL-calculated date in the request set.


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.