Results for “validate_segments”

18 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMF_VALIDATE_ACCOUNT is an Oracle EBS Application Object Library package owned by the APPS schema that supports cross-validation and account combination validation for the Process Manufacturing (GMF) and General Ledger (GL) accounting flexfield. The package is compiled with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which allows the validation logic to respect the caller's access to the underlying accounting flexfield structures and tables.

The principal business function of this package is to determine whether a given combination of company code, accounting unit, and account identifier forms a valid Accounting Flexfield combination, and to return the resulting combination identifier (CCID) along with any diagnostic error messages. This validation is essential wherever journal entries, subledger transactions, or account mappings must reference valid GL accounts before posting or mapping occurs. The package encapsulates calls to the Flexfield validation APIs and manages the retrieval of the descriptive flexfield context for accounts used within Process Manufacturing.

Key Procedures and Functions

  • VALIDATE_SEGMENTS — The main cross-validation procedure. It accepts company code, accounting unit, account identifiers, and account numbers, and performs flexfield cross-validation to confirm the account combination is valid. It returns the concatenated segment value, the CCID, a status flag, and any error message. It also supports an optional flag controlling whether a new combination should be created if one does not already exist.
  • CROSS_VALIDATE — Invoked from the account mapping form. It generates account combinations using all account units defined for the company and delegates the cross-validation logic to VALIDATE_SEGMENTS. An additional parameter for account number was introduced to address a prior defect (Bug 3080232).
  • GET_ACCU_ACCT_IDS — Retrieves the accounting unit and account identifier values, typically to drive the combination generation used during cross-validation from the form.
  • GET_ACCT_NO — Returns the account number associated with a given account identifier.
  • GET_ACCTG_UNIT_NO — Returns the accounting unit number associated with a given accounting unit identifier.
  • GET_ERROR_MESSAGES — Returns the accumulated error messages populated by the validation routines, using the package-level errors record that stores invalid combinations and their corresponding messages.

Tables Accessed

The package references the following objects through APPS synonyms: GL_ACCT_MST (account master, providing account numbers and identifiers), GL_ACCU_MST (accounting unit master, providing accounting unit numbers and identifiers), GL_PLCY_MST (company policy master, supplying company code context), GL_ACCU_MAP (account unit mapping used when generating combinations), FND_APPLICATION and FND_ID_FLEX_STRUCTURES (Flexfield definition metadata used to resolve the correct key flexfield structure), and PLITBLM (the standard PL/SQL table used by the FND validation routines). These tables are read to assemble, validate, and return account combination data.

Usage Notes

GMF_VALIDATE_ACCOUNT is invoked from both form-based and concurrent program contexts. The account mapping form calls CROSS_VALIDATE, which in turn calls VALIDATE_SEGMENTS; Subledger programs call VALIDATE_SEGMENTS directly. Custom code may call the public procedures to validate account combinations before inserting journal or mapping data. Because the package uses AUTHID CURRENT_USER and relies on FND Flexfield APIs, callers must have appropriate privileges on the underlying GL and FND objects. The package is referenced by two other packages within the EBS schema.