My Oracle Support Banner

UPDATE_PROJECT Errors With 'PA_OVER_REASON_NOT_ALLOWED' When Using The New Employee Bill Rate Override Annotation 'P_EMP_BILL_RATE_OVERRD_IN' and the Billing Implementation Option 'Require Rate and Discount Reason' is UNCHECKED. (Doc ID 3009871.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Project Foundation - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When using the new employee bill rate override annotation 'p_emp_bill_rate_overrd_in' per 'R12: Projects: How to Upload Bill Rate Schedules in Project Accounting Using an API? (Doc ID 2472345.1)', the following error is returned when the Billing Implementation Option 'Require Rate and Discount Reason' is UNCHECKED:

An API_ERROR occurred
error message: Enable 'Allow Bill Rate Discount Override' option under Billing
Tab on Implementation Options window to provide Discount Percentage.

Error short name: PA_OVER_REASON_NOT_ALLOWED

The customer finds when the option is checked, the error is not returned.

When an override is create for this same emplopyee through the application, the error is not returned. 

 

Steps to Reproduce:

1.  Modify the API from Sample Script For API UPDATE_PROJECT Using Composite Datatypes (Doc ID 206391.1)'

2.  Run the script via SQLPLus

SQL> @update.sql

3.  The error is returned

An API_ERROR occurred
error message: Enable 'Allow Bill Rate Discount Override' option under Billing
Tab on Implementation Options window to provide Discount Percentage.

PL/SQL procedure successfully completed.



Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.