My Oracle Support Banner

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

Last updated on JULY 24, 2019

Applies to:

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


How can users 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 users 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!

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.