Search Results update_closing_status

Overview

FV_YE_CLOSE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under Treasury (FV) applications. Its primary business function is to execute the Year-End Close process for fund balances within the Oracle Treasury module. The package orchestrates the calculation, determination, and transfer of ending fund balances from one fiscal year to the next, supporting the accounting and reporting requirements of public-sector and treasury-oriented organizations that must formally close out fund accounting periods. The package operates only on the server side; it is not an API exposed to external callers, as indicated by its classification of OTHER and the absence of any dependent packages referencing it.

Key Procedures and Functions

The package is driven by a top-level MAIN procedure that accepts runtime parameters including ledger, time frame, fund group, treasury symbol, closing fiscal year, and journal import indicators. Supporting procedures are organized around three principal phases: validation, balance computation, and output generation.

• Parameter and Setup Procedures: GET_REQUIRED_PARAMETERS, CHECK_YEAR_END_PARAMETERS, GET_CLOSING_FYR_DETAILS, GET_YEAR_END_RECORD, and DETERMINE_PROCESSING_TYPE gather the configuration needed before processing begins.
• Account and Segment Determination: CHK_DYNAMIC_INSERTION, GET_BALANCE_ACCOUNT_SEGMENTS, CHK_TO_ACCOUNTS, DETERMINE_ACCT_FLAG, GET_YEAR_END_SEQACCT_INFO, DETERMINE_CHILD_ACCOUNTS, and PROCESS_ACCT identify the accounts and hierarchy relationships involved in the close.
• Balance Retrieval and Insertion: DETERMINE_BALANCE_READ_FLAG, GET_BALANCES, GET_FUND_VALUE, GET_SEGMENT_VALUES, DETERMINE_DRCR, and INSERT_BALANCES compute, classify, and persist ending balances. INSERT_BALANCES is the documented procedure that writes individual balance rows, taking an account code combination identifier, account string, balance amount, debit/credit indicator, read flag, remaining balance, processing type, and a segment array. It is the central write path for the close.
• Output and Cleanup: PURGE_BAL_TEMP_TABLE, UPDATE_CLOSING_STATUS, POPULATE_GL_INTERFACE, CLEANUP_GL_INTERFACE, SUBMIT_REPORT, CHECK_GL_DATA, and CHECK_BAL_SEG_VALUE manage staging tables, General Ledger interface population, report submission, and reconciliation checks.

Tables Accessed

The package reads and writes a defined set of Treasury and Flexfield tables. FV_YE_GROUPS, FV_YE_GROUP_SEQUENCES, FV_YE_SEQUENCE_ACCOUNTS, and FV_YE_SEQ_BAL_TEMP store the year-end group definitions, sequence accounts, and temporary balance staging data used during processing. FV_FACTSII_ENDING_BALANCES and FV_FACTS1_RUN hold the fact data and run references for fund balances, while FV_FACTS_ATTRIBUTES supplies descriptive attributes. FV_FUND_PARAMETERS, FV_SYSTEM_PARAMETERS, and FV_TREASURY_SYMBOLS provide the fund, system, and treasury symbol configuration. Standard Flexfield tables FND_FLEX_VALUES, FND_FLEX_VALUE_HIERARCHIES, FND_FLEX_VALUE_NORM_HIERARCHY, FND_ID_FLEXS, and FND_ID_FLEX_SEGMENTS are used to resolve account segments and hierarchy relationships.

Usage Notes

FV_YE_CLOSE is invoked through the concurrent program framework, typically when an administrator launches the Treasury Year-End Close process from a responsibility menu or the Standard Request Submission form. The MAIN procedure receives the concurrent manager parameters (errbuf and retcode) along with the ledger, time frame, fund group, treasury symbol, closing fiscal year, and journal import flag. It is not referenced by other packages, so customization should target the concurrent program or the MAIN entry point rather than calling internal procedures directly. INSERT_BALANCES is the documented insertion routine most relevant to searches for "insert_balances," and it should be treated as an internal implementation detail rather than a public API.