My Oracle Support Banner

G-Invoicing: Performance Order With Freight On Board (FOB)= Destination Creates the Receivables Receipt but the Refund Fails to Unapply with Reason ARAR_RAPI_CUST_TRX_ID_NULL (Doc ID 2907890.1)

Last updated on NOVEMBER 18, 2022

Applies to:

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

Symptoms

The Intragovernmental Performance Interface Program is failing to unapply a receipt.

In View Performance History a Performance Type of Accepted/Received has a Status = Receipt failed and a Failure Reason = ARAR_RAPI_CUST_TRX_ID_NULL.

The negative amount errored out but after clicking on reprocess. The error goes away but the refund activity was not applied to the receipt.

The Intragovernmental Performance Interface Program fnd_log contains an error -

ar.plsql.Validate_Rev_gl_date          1    Validate_unapp_info: Recevable appln id return status E
ar.plsql.Validate_Rev_gl_date          1    Validate_unapp_info: Rev_gl_date_return_status :S
ar.plsql.Validate_unapp_info .end    2    Validate_unapp_info ()-
ar.plsql.Validate_unapp_info           1    Before calling arp_acct_event_pkg.upgrade_status_per_doc, inside Unapply
ar.plsql.Validate_unapp_info           1    Apply: 100
ar.plsql.Validate_unapp_info           1    Apply: ORA-01403: no data found
ar.plsql.Validate_unapp_info           1    Message 1. Customer transaction identifier is null.
ar.plsql.Validate_unapp_info           1    Message 2. UNAPPLY : ORA-01403: no data found
ar.plsql.Validate_unapp_info           1    "Message 3. ORA-01403: no data found
ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Unapply"
ar.plsql.Validate_unapp_info           1    Receipt is unapplied API return status not successful.

Steps to Reproduce
----------------------

  1. Log into a Projects self service responsibility
  2. Search for related project
  3. Navigate to Performance Obligation
  4. Create a Performance Obligation
  5. Perform a refund activity for a performance with the FOB = Destination
  6. Run Intergovernmental Performance Interface Program
  7. A Receipt is created successfully, but the Unapply process does not complete correctly
  8. The program completes with no error in log or output
  9. Review Performance History to see Status = Failed and Failure Reason = ARAR_RAPI_CUST_TRX_ID_NULL

Changes

This occurred after applying patches 34619882:R12.PA.C (June CU for G-Invoicing) and 34335852:R12.PA.C (Negative Delivery for AP Credit Memos)

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.