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 laterInformation 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: 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
----------------------
- Log into a Projects self service responsibility
- Search for related project
- Navigate to Performance Obligation
- Create a Performance Obligation
- Perform a refund activity for a performance with the FOB = Destination
- Run Intergovernmental Performance Interface Program
- A Receipt is created successfully, but the Unapply process does not complete correctly
- The program completes with no error in log or output
- 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 |