R12 "The value of the billable column for tasks within indirect projects must be 'N'" While Publishing an Indirect Project. (Doc ID 2086607.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After applying recommended patch collection (RPC) 3, when trying to publish a workplan, the following error is received:

Project:'Project name' The value of the billable column for tasks within indirect projects must be 'N'.  
You entered an invalid API parameter.  Please enter a valid parameter and try
again.  Parameter Name:  Pm Task Reference Parameter Value:  11954095

When looking at pa_proj_elements, the billable_flag for the newly created tasks is Y.  The customer finds that when a new task is created, the billable flag is defaulting to Y.  

PAXPREPR: Peer Tasks Not Defaulting To Non Billable From The Projects Template (Doc ID 298970.1) indicates this flag is based first on the work type and second on the project type class.  From this note:

"When creating a new peer task in a Contract project or project template, the new task does not have the billable flag checked, even thought the previous tasks do have it checked.  Is there a way to make all the new tasks default to non-billable as per the template?

Fix

If there is any worktype defined then the billable flag on the tasks will be defaulted from the billable capitalizable flag of the worktype.

If there is no worktype defined then, the defaulting mechanism is as below:

--For a Contract project, the billable flag is always defaulted to Yes.
--For a Indirect Project, the billable flag is always defaulted to No
--For a Capital project, the billable becomes capitalizable and is set to Yes.

The default functionality cannot be overridden."

For this project, the work type is not billable.  

Steps to Reproduce:

1.  Create a new task (Workplan Details > Update Current Working Version) on an indirect project where the work type on the project is NOT billable
2.  Select the last task and hit the 'Create' button.
3.  Provide details and click Apply
4.  Process Updates and click Go => the new task is created
5.  Click Update icon against the new task and select the Setup tab.  Note the 'Billable' flag is checked.

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