My Oracle Support Banner

OTM GL Code Assignment Failed With Exception "No general ledger code found for invoice/bill" Even Though Valid GL Code is Available (Doc ID 2929718.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Oracle Transportation Management Cloud Service - Version 22.3 and later
Information in this document applies to any platform.

Symptoms

Sometimes, valid General Ledger (GL) Code setup is available in OTM, but, system is unable to fetch it and assign against Invoice or/and Bill.

System is throwing exception - No general ledger code found for invoice/bill.

 

This scenario can be reproduced through the below steps-

  1. Define GL Code with required required Invoice Key and/or Bill Key
  2. Invoice Key and/or Bill Key are defined with required Lookup Keys with desired ranking of Key Components
  3. Some Lookups are valued for matching and some others are not valued with the expectation that system will not try to match those lookups with the source Invoice/Bill
  4. Select the required Invoice/Bill from the corresponding screen
  5. Select the record > Actions > Financial > Settlement > Assign Invoice/Bill General Ledger Code

 These activities should assign the available and matched GL Code gets assigned on the selected Invoice/Bill. However, actually, that did not get assigned and Log file shows the error/exception of  No general ledger code found for invoice/bill.

 

Sample Log:

 

Changes

 

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


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