My Oracle Support Banner

How Can DRN Number Be Populated On AP (Accounts Payable) Refund Invoice? (Doc ID 2941594.1)

Last updated on APRIL 13, 2023

Applies to:

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


Accounts Receivable has provided a hook package AR_PREPAY_HOOK_PKG.get_refund_dff_attribute to populate the DRN number associated with Performance to the AP Refund Invoice.

The DRN (Document Reference Number) is a scheduled number which is leveraged for Reconciliation with IPAC (Intragovernmental Payments and Collections). The code was tested and the AP Invoice DFF (Descriptive Flexfield) is not getting populated since the cash receipt id in the performance table is not getting updated with the cash receipt id before the Refund AP Invoice is created.

So the cash receipt id in the pa_proj_ginv_perf_detail table needs to be populated first and then the AP Refund Invoice should be called or it should be available in that session so that DRN number can be derived through the hook and populate on the AP Refund Invoice.

How can the DRN be populated on the AP Refund Invoice?


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.