Search Results fv_ye_carryforward




Overview
Explore in AI Chat

Overview

The APPS.FV_YE_CARRYFORWARD package is a U.S. Federal financials utility in Oracle E-Business Suite that performs year-end closing carryforward processing. Its business purpose is to move fund balances and related attribute balances from a closing fiscal year into the following fiscal year, generating the corresponding journal entries that establish opening balances in the new period. The package is part of the FV (Federal Financials) product family and operates against a specific ledger/sob and a target carryforward fiscal year, which are supplied as run-time parameters. In EBS 12.1.1 and 12.2.2 the package is registered in the APPS schema and declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than as definer. The header revision string (FVXYECFS.pls 120.5.12010000.1) indicates the source was last shipped on the 12.1.1 code line, and the same body is carried forward into the 12.2.2 environment.

Key Procedures and Functions

  • Main — The primary entry point and concurrent-program driver. It accepts the standard concurrent manager errbuf and retcode OUT parameters along with the sob and carryforward fiscal year, then orchestrates the remaining steps of the carryforward.
  • Get_Required_Parameters — Retrieves the system-level setup values (such as balancing segment options and processing flags) needed to drive the run.
  • Get_Period_Details — Determines the accounting periods associated with the closing and target fiscal years so that balances and journal entries are placed in the correct period.
  • Check_Carryforward_Process — Validates whether carryforward processing is permitted for the requested ledger and year, guarding against duplicate or invalid runs.
  • Get_Balances — Extracts the balances to be carried forward. A commented-out Get_Attribute_Balances declaration suggests attribute-balance handling was folded into or removed from this logic.
  • Setup_Gl_Interface — Populates the GL interface tables with the header and line records that represent the carryforward journal.
  • Submit_Journal_Import — Invokes the Journal Import process so the staged interface rows are converted into posted General Ledger journals.
  • Cleanup_Gl_Interface — Removes the temporary interface rows after import completes.
  • Convert_To_Num — A conversion utility that returns a numeric value from a character string, used when interface data requires numeric interpretation.
  • Check_Bal_Seg_Value — Validates a balancing segment value against the ledger and the applicable balancing segment value option code, returning a character result.

Tables Accessed

The package reads FV_SYSTEM_PARAMETERS for Federal system configuration and GL_PERIODS/GL_PERIOD_STATUSES to resolve and validate accounting periods. It writes to GL_INTERFACE, GL_INTERFACE_CONTROL, and GL_INTERFACE_CONTROL_S during journal staging, and reads GL_JE_HEADERS after import. GL_LEDGER_SEGMENT_VALUES supports balancing segment validation, while DBMS_SQL and DUAL are used for dynamic SQL and single-row queries.

Usage Notes

FV_YE_CARRYFORWARD is normally invoked through a concurrent program or Federal year-end closing form rather than called directly. The Main signature is designed for concurrent manager submission, with the ledger and carryforward year passed as program parameters. Because the package manipulates GL interface tables, it should not be run concurrently with Journal Import for the same ledger, and appropriate cleanup of prior interface rows is expected before execution. Custom code should not call the internal procedures independently, as they rely on sequencing and session state established by Main.