PAIGEN: ORA-01008 WHEN RUNNING WITH 'BILL GROUP' PARAMETER ENTERED (Doc ID 1997783.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
PRC: Generate Draft Invoices for a Single Project process

Symptoms

On : 12.1.3 version, Invoices

After applied patch # 17855007, pre-req patch #17839156,# 18000312, when running PRC: Generate Draft Invoices for a Single Project process
and specify value for 'Bill Group' parameter, the process errors out with:

ERROR
-----------------------
PAI_ORACLE_ERROR
ERROR
cursor=66 code=-1008: ORA-01008: not all variables bound


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PRC: PRC: Generate Draft Invoices for a Single Project with parameter:


 Single Project ID ---------------------> 979969
 From Project Number ------------------->
 To Project Number --------------------->
 Bill Through Date ---------------------> 2015/02/19
 Invoice Date --------------------------> 2015/02/18
 Invoice Generation Option -------------> INCLUDE_RETN_INVOICES
 Project Type ID -----------------------> 0
 Project Org ID ------------------------> 0
 Customer ID ---------------------------> 0
 LOC Customer ID -----------------------> 0
 Agreement ID --------------------------> 0
 Multi Currency Flag -------------------> No
 Exclude New Transactions --------------> No
 Delete unapproved invoices only -------> No
 Delete PWP Linked invoices ------------> No


2. The process completed with error:

cursor=66 code=-1008: ORA-01008: not all variables bound


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