My Oracle Support Banner

PA_BILL_RATES_PUB.CREATE_BILL_RATE_SCHEDULE API Fails With Errors: 'The Schedule Reference Is Missing For Bill Rate' and 'The Specified Non-Labor Schedule Type NON-LABOR Contains an Invalid Parameter.' (Doc ID 2976156.1)

Last updated on OCTOBER 11, 2023

Applies to:

Oracle Project Billing - Version 12.2.8 and later
Information in this document applies to any platform.


When trying to use PA_BILL_RATES_PUB.create_bill_rate_schedule API to create new bill rate schedules, it fails with the following errors, one after another:

Error# 1: 'The schedule reference is missing for bill rate. Enter a schedule reference and retry.'

Error# 2: 'The specified non-labor schedule type NON-LABOR contains an invalid parameter. Enter a valid value and retry. (PA_BILL_RATE=)'


1. The API script needs to be saved to a plain text file (i.e. create_bill_rate_schedule.sql) .

2. Log into SQL*Plus as the Apps system owner.

3. Run the script

SQL> @create_bill_rate_schedule.sql


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.