R12 Identify the Ledger Name From The Internal Bank Account Table (Doc ID 1965317.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Identify the Name of the Ledger in which a Bank Account is configured using SQL Plus.

 

The following was used in Release 11i and earlier

SELECT NAME
FROM GL_SETS_OF_BOOKS
WHERE GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID =
AP_BANK_ACCOUNTS_ALL.SET_OF_BOOKS_ID
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms