My Oracle Support Banner

Bills Receivable Portfolio Management Unable To Unpaid And Cancel Bills Receivables (Doc ID 2442787.1)

Last updated on FEBRUARY 18, 2019

Applies to:

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

Symptoms

On : 12.2.5 version, Bills Receivable

Bills Receivable Portfolio Management Unable to unpaid and cancel Bills Receivables



ERROR
-----------------------
AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()+
>>>>>>>> arp_cr_batches_pkg.fetch_p
EXCEPTION: arp_cr_batches_pkg.fetch_p
>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()
SQLCODE : 100
SQLERRM : ORA-01403: no data found
EXCEPTION: ARBRCOMM_DB.unpaid_br(
P_API_VERSION=>1
x_RETURN_STATUS=>E
X_MSG_COUNT=>
X_MSG_DATA=>
P_CUSTOMER_TRX_ID=>15923851
P_UNPAID_GL_DATE=>14-AUG-2018
P_UNPAID_DATE=>14-AUG-2018
P_UNPAID_COMMENTS=>
P_UNPAID_REASON=>AC01
P_UNPAID=>)
Return KO from API - ARBRPORT_DBFOUND


STEPS

------

!. Query Bills Receivable

2. Click UNPAID

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Cancel / unpaid BR

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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