How To Create Project Agreements With Advances Using PA_AGREEMENT_PUB API
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms