Search Results icx_req_acct2




Overview
Explore in AI Chat

Overview

ICX_REQ_ACCT2 is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports requisition and shopping-cart charge account processing within the iProcurement (Internet Procurement) module. The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner, which is standard for iProcurement account-validation utilities that must respect the calling session's security context. Its documented header dates from release 11.5 and the package remains present in EBS 12.1.1 and 12.2.2 under API classification OTHER.

Functionally, ICX_REQ_ACCT2 resolves accounting flexfield combinations for requisition distribution lines, converts between segment arrays and concatenated account numbers, applies default accounts, and validates that a charge account is permissible for a given cart line. It is a core building block of the iProcurement checkout and distribution flow.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions:

  • VALIDATE_CHARGE_ACCOUNT — validates a charge account for a specified cart and cart line, optionally against a supplied account identifier and line number.
  • INSERT_ROW — creates a distribution record for a cart line, accepting an account identifier, a segment array, a concatenated account number, and allocation type/value attributes.
  • UPDATE_ROW — modifies an existing distribution row, including its account, segments, account number, and allocation details.
  • GET_ACCT_BY_SEGS — derives the account identifier and concatenated account number from a supplied segment array and accounting structure.
  • GET_ACCT_BY_CON — returns the segment array and account identifier for a supplied concatenated account number.
  • GET_ACCOUNT_SEGMENTS — returns the individual segment array for a given account identifier and structure.
  • UPDATE_ACCOUNT_NUM — updates the stored concatenated account number on a distribution.
  • UPDATE_ACCOUNT — updates the account assignment for a cart line.
  • GET_DEFAULT_ACCOUNT — retrieves the default charge account applicable to the cart or line context.
  • GET_DEFAULT_SEGS — retrieves the default account in segment-array form.
  • UPDATE_ACCOUNT_BY_ID — updates an account using an identifier reference.

Tables Accessed

The package reads and writes several categories of tables through APPS synonyms:

Usage Notes

ICX_REQ_ACCT2 is invoked primarily from iProcurement's account-selection and checkout user interfaces, including the Manage Requisitions and shopping-cart distribution pages, and from forms or Java/HTML pages that need to persist or validate charge accounts. The ETRM metadata records that the package is referenced by nine other packages, indicating it is a shared utility consumed across the procurement account-derivation stack. Custom deployments should treat this package as a private implementation object: it is not a documented open API, and callers should prefer supported public interfaces. Where the accounting flexfield structure is customized, the segment-array parameters (based on fnd_flex_ext.SegmentArray) require the correct chart of accounts context to resolve properly.