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

Last updated on JANUARY 22, 2017

Applies to:

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

Symptoms

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.

ERROR
-----------------------
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)



STEPS
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms