Oracle General Ledger

EBS R12 General Ledger SQL to get GL Code Combinations records

The blog provides the EBS R12 SQL to get GL_CODE_COMBINATIONS records bases on last_run_date update and Char of Accounts Id SELECT GCC.CODE_COMBINATION_ID ,GCC.ALTERNATE_CODE_COMBINATION_ID ,GCC.CHART_OF_ACCOUNTS_ID ,GCC.DETAIL_POSTING_ALLOWED_FLAG ,GCC.DETAIL_BUDGETING_ALLOWED_FLAG ,GCC.ACCOUNT_TYPE ,GCC.ENABLED_FLAG ,GCC.SUMMARY_FLAG ,GCC.SEGMENT1 ,GCC.SEGMENT2 ,GCC.SEGMENT3 ,GCC.SEGMENT4 ,GCC.SEGMENT5 ,GCC.SEGMENT6 ,GCC.SEGMENT7 ,GCC.SEGMENT8 ,GCC.SEGMENT9 ,GCC.SEGMENT10 ,GCC.SEGMENT11 ,GCC.SEGMENT12 ,GCC.START_DATE_ACTIVE ,GCC.END_DATE_ACTIVE ,GCC.JGZZ_RECON_FLAG ,GCC.PRESERVE_FLAG ,GCC.DESCRIPTION ,GCC.TEMPLATE_ID ,GCC.ALLOCATION_CREATE_FLAG FROM   GL_CODE_COMBINATIONS GCC WHERE  GCC.LAST_UPDATE_DATE > TO_DATE […]

General Ledger ( GL) differences in EBS 11i and EBS R12

The blog provides the major changes in General Ledger ( GL) differences in 11i and R12 General Ledger EBS R11i vs EBS R12 Ledger: The ledger is a major concept change  in Release 12 which  replaces the 11i concept of a set of books. the Ledger represents an accounting representation for one or more legal entities or for […]

Oracle EBS R12 Journal Import Validation Process

The Oracle Apps Journal Import validates the accounting data received from other systems in the GL_INTERFACE Table. The list of  journal error lines will be published in the Journal Import Execution Report. Batch Level Validation: Journal Import validates the below attributes so that the  batch name available for processing should not already exist for the same Ledger Id  Period in the […]

Oracle EBS R12 General ledger interface tables

The Oracle apps General Ledger Interface Table – GL_INTERFACE is the entry point for all journals accounting data which have been imported from other systems. The Journal Import Program validates the accounting data received in the GL_INTERFACE Table and imports the available data into Journal entries in the Oracle Apps GL Application. The Journal Import Program […]

Oracle EBS R12 SQL to delete GL budget lines

General Ledger SELECT Query to get the details for the Budget Name and Budget Entity Name SELECT GBI.* FROM GL_BUDGET_INTERFACE GBI WHERE 1=1 AND GBI.LEDGER_ID = <PROVIDE_LEDGER_ID> AND GBI.BUDGET_NAME= ‘<PROVIDE_BUDGET_NAME>’ AND GBI.BUDGET_ENTITY_NAME= ‘<PROVIDE_BUDGET_ENTITY_NAME>’ AND GBI.FISCAL_YEAR = ‘<PROVIDE_FISCAL_YEAR>’ –2016 Get the count for the Budget lines from the Budget Interface Table that need to be deleted […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.