Need To Schedule Collect Revenue Recognition Information With SQL Calculated Start Date Err ORA-0103
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.
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 :
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.
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