My Oracle Support Banner

PAIGEN: PRC: Generate Draft Invoice for a Range of Projects Not Finding Projects Because of the Billing Cycle. How Can a Billing Cycle Be Setup to Not Require the Use of the Client Extension? (Doc ID 3062173.1)

Last updated on DECEMBER 04, 2024

Applies to:

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

Goal

PRC:  Generate Draft Invoices for a Range, does not find projects to bill based on the billing cycle in use.  Per the documentation the following is the selection criteria:

Oracle Project Billing User Guide

https://docs.oracle.com/cd/E26401_01/doc.122/e49079/T178714T178721.htm#2299411

Selection Criteria

Projects: Oracle Projects first determines if a project is eligible for invoice generation using the following criteria:

Must be a contract project

Must have a status that allows invoice generation. For more information, see: Project Statuses, Oracle Projects Implementation Guide.

Must have a baseline budget and funding

Must have expenditure items or events that are eligible for invoice generation or transaction-independent billing extensions that are assigned at the project type, project, or top task level

If you submit the process for all projects, it checks the eligibility of each project to bill according to its billing cycle. A project must meet the following billing cycle criteria before it can generate an invoice:

Must not have any pending invoices (Unreleased)

At least one bill cycle past the bill through date (or creation date if no bill through date exists) of the last non-crediting invoice

At least first bill offset days past the project start date (or project creation date if no start date exists) if you have not yet invoiced a particular project

If the billing date is calculated by a client extension, and the client extension returns a null value for the billing date, then the process will not pick up the project.

To generate retention invoices, the project must be eligible to bill retention.

When submitted for a single project, the Generate Draft Invoices process ignores billing cycle. Also, if you have any unreleased draft invoices, they are deleted and a new draft invoice is created.

 

Customer asks:  Our Current Design has all projects with a 'Billing Cycle Type' of 'User Defined' which users assumed meant the billing cycle was on demand.  They later learned this billing cycle type requires the use of the billing cycle extension.  If users want the ability to bill daily without use of the extension, do they configure a new billing cycle type called something like 'Daily' with a Type of 'Billing Cycle Days' and a Value of '1'? This would not require the deployment of the Billing Cyce Extension and we could essentially bill on any day?  Then users would update the billing cycle on the Project Type and for current projects, update the Billing Cycle under the Billing Options, then we could use this PRC:  Generate Draft Invoices for a Range of Projects versus having to run the PRC:  Generate Draft Invoices for a Single Project?
 

Solution

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
Goal
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.