My Oracle Support Banner

Approving a Loan and Receive Error - Invalid Ussgl Transaction Code Has Been Specified (Doc ID 1670433.1)

Last updated on JULY 18, 2018

Applies to:

Oracle Loans - Version 12.2.2 and later
Information in this document applies to any platform.


When trying to approve a loan, the following error occurs:

Invalid Ussgl Transaction Code has been specified
Call to AR_ADJUST_PUB.Create_Adjustment failed. unknown
The following SQL error occurred: Failed API call: LNS_BILLING_BATCH_PUB.ADJUST_ORIGINAL_RECEIVABLE SQLERRM: User-Defined Exception. Contact your system administrator

Steps to Reproduce:
: Loan Agent
: Loans Dashboard
Attempt to approve a loan


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.