Refund Issue: Receipt API AR_RECEIPT_API_PUB.ACTIVITY_APPLICATION Ignores P_APPLY_GL_DATE Being Passed and Uses SYSDATE Instead (Doc ID 1499297.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to create a refund using the receipt API AR_RECEIPT_API_PUB.ACTIVITY_APPLICATION. 

The GL_DATE defined in the API script is not passed correctly.  The SYSDATE is passed to the Payables (AP) Invoice created.

If the AP period is closed then the following error is generated:

API error : ACCT DATE NOT IN OPEN PD

Example:
p_apply_gl_date => 01-AUG-2012
Refund in AR populated with GL_DATE 01-AUG-2012
AP Invoice populated with GL_DATE 10-OCT-2012 (SYSDATE)

Cause

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 hundreds of Community platforms