Tables for the General Ledger - Journals (GL) in Oracle fusion.

Here are the tables for the GL Ledger in Oracle fusion. This tables will store the details of the General Ledger Journals and related data information tables. 

• GL_JE_HEADERS

• GL_JE_LINES

• GL_CODE_COMBINATIONS

• GL_LEDGERS

• GL_JE_SOURCES

• GL_JE_CATEGORIES

• GL_JE_BATCHES

• GL_BALANCES 

• GL_PERIODS

• GL_INTERFACE : The interface table used for the GL Journal Import process.

Other modules related tables list here :

Tables for the PO(Purchase Order) in Oracle fusion

Tables for the Items in Oracle fusion

Tables for the Sales Contracts in Oracle fusion

Supplier Site Import Process Not Populating The Tax Registration Number (VAT Registration Number) - Oracle fusion Cloud

Supplier Site FBDI has two columns VAT Code and Tax Registration Number. These two fields are not imported through the Supplier Site FBDI import process. 

Supplier Site gets created successfully, however the VAT code and Tax Registration numbers are not getting populated anywhere. 

Also notice that in the interface table, these two columns are not getting populated with the FBDI data values( due to the FILLER options while loading into the interface tables - POZ_SUPPLIER_SITES_INT, which is getting skipped). Please see screenshot provided below.

Oracle has confirmed the same. Both Vat Code and Tax Registration Number are not supported functionality via the Supplier Site import process.  Please see below the Doc ID provided.

Supplier Site Import Process Not Populating The Tax Registration Number (VAT Registration Number) ( Doc ID 2034667.1 )  

Cause : "Populating the Tax Registration Number via the Supplier Site import process is currently not supported functionality."

 

SQL Query to fetch the Unposted GL Journal Batches in Oracle fusion.

 Here is the SQL query to fetch the Unposted GL Journal batches in the Oracle fusion.This query might be helpful in case if you want to find how many Unposted GL Batches exists.

SELECT

 GL.NAME "Ledger Name",

 GLJB.NAME "Batch name" , 

 GLJH.PERIOD_NAME,

 GLJH.STATUS, 

 GLJH.JE_CATEGORY CATEGORY ,

 GLJH.JE_SOURCE SOURCE , 

 GLJH.CURRENCY_CODE CURRENCY 

 FROM 

 GL_JE_HEADERS GLJH,

 GL_JE_BATCHES GLJB, 

 GL_LEDGERS GL

 WHERE 

 GLJB.JE_BATCH_ID = GLJH.JE_BATCH_ID AND

 GLJH.LEDGER_ID = GL.LEDGER_ID AND

 GLJH.STATUS <> 'P'

ORDER BY GL.NAME,GLJB.NAME,GLJH.PERIOD_NAME