General Ledger Useful SQL Scripts – Oracle Applications 11i-优快云博客

本文档提供 Oracle Applications 11i 中总账模块的详细 SQL 脚本集合，包括总账科目配置概览、总结账科目模板定义审查、段值列表、会计期间状态等内容，适用于系统管理和财务数据处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

General Ledger Useful SQL Scripts – Oracle Applications 11i

Contents

GL Set of Books Configuration Overview 1

GL Summary Account Template Definition Review 2

GL Segment Value Listing 3

GL Period Status 3

GL Chart of Accounts Structure 4

GL Chart of Accounts Structure Overview 4

GL Journal Header Summary 5

GL Journal Line Based Trial Balance Report 5

GL Journal Lines With AP Source Reference Fields 6

GL Mass Allocation Rule Migration Script in Dataload Classic Format 7

GL Balances and Movements 8

GL Chart of Account Segment Hierarchy Ranges 9

GL Code Combinations CCIDs 9

GL CVR Cross Validation Rule Detail Listing 10

GL CVR Cross Validation Rule Overview 11

GL Flexfield Security Rule Assignments 11

GL Flexfield Security Rule Definitions 11

GL FSG Report and Components Overview 12

GL Interface Details 13

GL Interface Summary 13

GL Mass Allocation Formula review script 14

GL Mass Allocation Migration Script in Dataload Professional FLD format 14

GL Mass Allocation Rule Migration Script in Dataload Classic Format 17

GL ADI Journal Balances script 18

GL Autopost Definitions 19

HR Operating Unit and Legal Entity Configuration 19

Dataload .dld GL Cross Validation Rules 20

Dataload Professional .fld -- Daily Rates load 21

GL Set of Books Configuration Overview

/* SET OF BOOKS CONFIGURATION OVERVIEW

WRITTEN BY DANIEL NORTH, ORAFINAPPS LIMITED 2007

THIS SQL GIVES AN OVERVIEW OF THE SET OF BOOK DEFINITIONS AND CAN BE USED WHEN IMPLEMENTING MULTIPLE SETS OF BOOKS

TO ENSURE CONSISTENT SETUP ACROSS COUNTRIES AND BETWEEN ENVIRONMENTS.

WHERE CLAUSE CAN BE ADDED OR COMMENTED OUT TO JUST LOOK AT SPECIFIC COUNTRIES. */

SELECT SOB.SET_OF_BOOKS_ID "ID"

, SOB.NAME

, SOB.SHORT_NAME

, SOB.DESCRIPTION

, SOB.CHART_OF_ACCOUNTS_ID "COA ID"

, FST.ID_FLEX_STRUCTURE_CODE "CHART OF ACCOUNTS"

, SOB.CURRENCY_CODE "CURR"

, PT.USER_PERIOD_TYPE "PERIOD"

, SOB.PERIOD_SET_NAME

, SOB.FUTURE_ENTERABLE_PERIODS_LIMIT "FUT. PER"

, SOB.LATEST_OPENED_PERIOD_NAME "LATEST OPEN"

, SOB.ATTRIBUTE1"OPERATIONAL BOOK"

, SOB.ATTRIBUTE2"PPL ?"

, SOB.ENABLE_REVAL_SS_TRACK_FLAG||'.'||ENABLE_SECONDARY_TRACK_FLAG"SEC SEG TRACK?"

, RET.SEGMENT1||'-'||RET.SEGMENT2||'-'||RET.SEGMENT3||'-'||RET.SEGMENT4||'-'||RET.SEGMENT5||'-'||RET.SEGMENT6 "RETAINED EARNINGS"

, TRAN.SEGMENT1||'-'||TRAN.SEGMENT2||'-'||TRAN.SEGMENT3||'-'||TRAN.SEGMENT4||'-'||TRAN.SEGMENT5||'-'||TRAN.SEGMENT6 "TRAN EARNINGS"

, '---JOURNALS---'

, SOB.ALLOW_INTERCOMPANY_POST_FLAG"INTERCO?"

, SOB.ENABLE_JE_APPROVAL_FLAG"JRNL APP?"

, SOB.ENABLE_AUTOMATIC_TAX_FLAG"AUTO TAX?"

, SOB.SUSPENSE_ALLOWED_FLAG"SUSP?"

, SOB.TRACK_ROUNDING_IMBALANCE_FLAG"TRK RND?"

, '---AV BAL---'

, SOB.ENABLE_AVERAGE_BALANCES_FLAG||SOB.CONSOLIDATION_SOB_FLAG||SOB.TRANSACTION_CALENDAR_ID||SOB.NET_INCOME_CODE_COMBINATION_ID

||SOB.DAILY_TRANSLATION_RATE_TYPE||SOB.TRANSLATE_EOD_FLAG||SOB.TRANSLATE_QATD_FLAG||SOB.TRANSLATE_YATD_FLAG "NOT USED"

, '---BUDGET CNTL---'

, SOB.ENABLE_BUDGETARY_CONTROL_FLAG||SOB.REQUIRE_BUDGET_JOURNALS_FLAG||SOB.RES_ENCUMB_CODE_COMBINATION_ID "NOT USED"

, '---MRC---'

, SOB.MRC_SOB_TYPE_CODE "NOT USED"

FROM GL_SETS_OF_BOOKS SOB, FND_ID_FLEX_STRUCTURES FST, GL_CODE_COMBINATIONS TRAN, GL_CODE_COMBINATIONS RET, GL_PERIOD_TYPES PT

WHERE FST.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID

AND RET.CODE_COMBINATION_ID(+) = SOB.RET_EARN_CODE_COMBINATION_ID

AND TRAN.CODE_COMBINATION_ID(+) = SOB.CUM_TRANS_CODE_COMBINATION_ID

AND PT.PERIOD_TYPE = SOB.ACCOUNTED_PERIOD_TYPE

--AND SUBSTR(SO

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow