Results for “account_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.IGI_ITR_ACCT_GENERATOR_PKG package body is a component of Oracle E-Business Suite's International Trade Management (ITM) / Intercompany Transaction Reconciliation (ITR) accounting infrastructure. Its primary business function is to generate and derive accounting flexfield combinations (CCIDs) used in intercompany charge processing. The package resolves charge service setups into valid Oracle General Ledger account combinations, applying the appropriate chart of accounts structure, account types, and segment values configured for intercompany billing relationships.
The best-known entry point, START_ACCT_GENERATOR_WORKFLOW, launches an Oracle Workflow process (item type ITRWKFAG) that drives account derivation. Supporting private logic resolves segments, counts, and names dynamically from the accounting flexfield definition. A private diagnostic helper, diagn_msg, writes conditionally filtered messages to the FND_LOG diagnostic framework based on the current runtime log level.
Key Procedures and Functions
START_ACCT_GENERATOR_WORKFLOW— Public entry point. Initiates the accounting generator workflow, accepting parameters that identify the chart of accounts, set of books, account type, charge center, preparer, charge service, cost center value, and additional segment value, and returns the derived CCID and concatenated segment string.ACCOUNT_TYPE— Determines or derives the relevant account type for the transaction being processed.FETCH_CREATION_ACCOUNT— Retrieves the account combination created during processing, typically used to confirm the generated CCID.FIND_NO_OF_SEGS— Determines the number of segments defined for the applicable accounting flexfield structure.INCREASE_COUNTER— Maintains an internal segment index/counter used while iterating over flexfield segments.FETCH_SEGMENTI_VALUEandFETCH_SEGMENTI_NAME— Retrieve the value and descriptive name of the i-th segment in the accounting flexfield.COST_CENTER_VALUE_CHOSENandADDITIONAL_SEG_VALUE_CHOSEN— Resolve the cost center and additional segment values selected by the caller into usable segment data.FETCH_ADDITIONAL_SEG_NAME— Returns the descriptive name associated with the additional segment value.FETCH_SERVICE_RECEIVING_ACCT— Derives the receiving-side account for the intercompany charge service being processed.
Tables Accessed
FND_ID_FLEX_SEGMENTS— The Application Object Library table defining accounting flexfield segments. It is queried to determine segment counts, segment values, and segment names.IGI_ITR_CHARGE_SERVICE— Stores intercompany charge service definitions; supplies the receiving account and related accounting attributes.IGI_ITR_CHARGE_SETUP— Stores intercompany charge setup configuration that governs how accounts are derived.DUAL— Used for simple single-row expression evaluation and function calls.
Usage Notes
The package is invoked programmatically rather than through a standard form. Its principal public function, START_ACCT_GENERATOR_WORKFLOW, is designed to be called from intercompany charge processing logic, which then hands control to the ITRWKFAG workflow to complete account generation. Customizations and extensions should call the public function only; the remaining routines are private helpers whose signatures may change between patches.
The diagn_msg helper is significant for troubleshooting: it compares a supplied level against FND_LOG.G_CURRENT_RUNTIME_LEVEL and forwards messages to FND_LOG.STRING only when the level threshold is met, prefixing paths with IGI.PLSQL.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.. Administrators diagnosing account-generation failures should enable FND logging at the appropriate module level to surface these messages. Because no other packages reference this one, its usage is confined to the ITR charge accounting flow.
-
Lookup Type: ACCOUNT_TYPE 12.2.2
-
Lookup Type: ACCOUNT_TYPE 12.1.1
-
Lookup Type: ACCOUNT_TYPE 12.2.2
-
Lookup Type: ACCOUNT_TYPE 12.1.1
-
Lookup Type: ACCOUNT_TYPE 12.1.1
-
Lookup Type: ACCOUNT_TYPE 12.2.2
-
Temporary table used for performance improvment in cost allocation process. This table is populated with values from GL_CODE_COMBINATIONS table.
-
Temporary table used for performance improvment in cost allocation process. This table is populated with values from GL_CODE_COMBINATIONS table.
-
View: PSB_WS_ACCOUNTS_V 12.1.1
APPS.PSB_WS_ACCOUNTS_V·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES·↳ PSB_WS_MATRIX·Explore PSB module →
-
APPS.PAY_XLA_PAYMENT_COSTS_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_PAYMENT_COSTS·Explore PAY module →
-
APPS.PAY_XLA_PAYMENT_COSTS_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_PAYMENT_COSTS·Explore PAY module →
-
Singapore localisation view.
APPS.PAY_SG_ASG_NET_PAYMENTS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_GENERAL·Explore PAY module →
-
Singapore localisation view.
APPS.PAY_SG_ASG_NET_PAYMENTS_V·↳ HR_API·↳ HR_GENERAL·↳ HR_LOOKUPS·Explore PAY module →
-
View: FABV_TRANS_LINES 12.1.1
- Retrofitted
-
View: FABV_TRANS_LINES 12.2.2
- Retrofitted
-
This table maps a type of user to a particular role and a particular application domain.
-
APPS.PSB_WS_POSITION_ACCOUNTS_V·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES_POSITIONS·↳ PSB_WS_MATRIX·Explore PSB module →
-
Chilean General Ledger "8 Columns Trial Balance" Report Account Hierarchy
-
The AR_CMGT_BANK_REF_ACCTS table stores detailed bank account balance information for the company under credit review.
-
View: JL_CO_GL_ACCOUNTS_V 12.1.1
APPS.JL_CO_GL_ACCOUNTS_V·↳ FND_APPLICATION·↳ FND_FLEX_VALUES·↳ FND_FLEX_VALUES_TL·Explore JL module →
-
This table maps a type of user to a particular role and a particular application domain.
-
View: JL_CO_GL_ACCOUNTS_V 12.2.2
APPS.JL_CO_GL_ACCOUNTS_V·↳ FND_APPLICATION·↳ FND_FLEX_VALUES·↳ FND_FLEX_VALUES_TL·Explore JL module →
-
APPS.CE_INTERNAL_BANK_ACCTS_GT_V·↳ CE_BANK_ACCTS_GT_V·↳ CE_BANK_BRANCHES_V·↳ CE_LOOKUPS·Explore CE module →
-
- Retrofitted
APPS.CE_INTERNAL_BANK_ACCOUNTS_V·↳ CE_BANK_ACCOUNTS_V·↳ CE_BANK_BRANCHES_V·↳ CE_LOOKUPS·Explore CE module →
-
- Retrofitted
APPS.CE_INTERNAL_BANK_ACCOUNTS_V·↳ CE_BANK_ACCOUNTS_V·↳ CE_BANK_BRANCHES_V·↳ CE_LOOKUPS·Explore CE module →
-
The AR_CMGT_BANK_REF_ACCTS table stores detailed bank account balance information for the company under credit review.
-
APPS.CE_INTERNAL_BANK_ACCTS_GT_V·↳ CE_BANK_ACCTS_GT_V·↳ CE_BANK_BRANCHES_V·↳ CE_LOOKUPS·Explore CE module →
-
View: HR_CERIDIAN_EFT_V 12.1.1
Ceridian Source 100 payroll interface view
APPS.HR_CERIDIAN_EFT_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_SOFT_CODING_KEYFLEX·↳ PAY_EXTERNAL_ACCOUNTS·Explore PER module →
-
View: HR_CERIDIAN_EFT_V 12.2.2
Ceridian Source 100 payroll interface view
APPS.HR_CERIDIAN_EFT_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_SOFT_CODING_KEYFLEX·↳ PAY_EXTERNAL_ACCOUNTS·Explore PER module →
-
Chilean General Ledger "8 Columns Trial Balance" Report Account Hierarchy
-
This table records all processed AP bank account results for Bank Upgrade Purging program
-
This table records all processed AP bank account results for Bank Upgrade Purging program
-
Import of Chart of Accounts Segment Values
-
View: HR_CERIDIAN_500_EFT_V 12.1.1
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_EFT_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_CERIDIAN·↳ HR_SOFT_CODING_KEYFLEX·Explore PER module →
-
View: PSB_WS_LINE_YEAR_XL_V 12.1.1
APPS.PSB_WS_LINE_YEAR_XL_V·↳ PSB_SERVICE_PACKAGES·↳ PSB_WS_ACCOUNT_LINES·↳ PSB_WS_LINES·Explore PSB module →
-
Foreign currency translation rates for historical accounts
-
APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →
-
APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →
-
Table: XLA_BAL_AC_CTRBS_GT 12.2.2
-
Table: XLA_BAL_AC_CTRBS_GT 12.1.1