My Oracle Support Banner

How To Create Project Agreements With Advances Using PA_AGREEMENT_PUB API (Doc ID 2079652.1)

Last updated on JUNE 09, 2017

Applies to:

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


On : 12.2.4 version, Public API's

How can we create project agreements with advances using the PA_AGREEMENT_PUB API

The requirement is to be able to create the agreement with an advance and apply a receipt for a specific customer on the agreement
Then we need to create project funding via this API.
The goal is to convert agreements with advances in the same way as per the standard functionality available in the Agreements form.

Attempts to create these agreements with advances through this API by passing the ADVANCE_REQUIRED flag as 'Y' failed.  It seems that the API always sets this flag as 'N' during the agreement creation, and it only creates
agreement headers in the PA_AGREEMENTS table with ADVANCE_REQUIRED as N.

Is PA_AGREEMENT_PUB.create_agreement routine capable of creating agreements with advances, then applying receipts for the advance amount and creating project funding for the agreement?

If not, is there a workaround to achieve this functionality, as this is how it works on the standard form?


To view full details, 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 a vibrant support community of peers and Oracle experts.