Search Results xtr_misc_p




Overview
Explore in AI Chat

Overview

XTR_MISC_P is a miscellaneous utility package within the Oracle E-Business Suite Treasury (ETRM) module, owned by the APPS schema. It consolidates a collection of procedural routines that support deal validation, deal action bookkeeping, audit reporting, multi-language text maintenance, actuals insertion for funds and portfolios, projected balance maintenance, counterparty/company authorization checks, and set-off processing. The package is classified as an "OTHER" API rather than a formal public API, meaning it is primarily intended for internal consumption by ETRM forms, concurrent programs, and other ETRM packages rather than as a supported external integration surface. It is referenced by nine other packages, which indicates it functions as a shared procedural library underpinning core treasury processing logic across deal lifecycle, confirmation, and exposure-related functionality.

Key Procedures and Functions

  • FPS_AUDIT — Drives audit reporting based on an audit requestor, event name, and a date range, generating audit output from the audit summary and column definitions.
  • MAINTAIN_LANGUAGE — Maintains language-specific text values, accepting old and new values, an option indicator, a language code, and the original text, supporting translatable ETRM content.
  • DEAL_ACTIONS — Records or processes deal-related actions, capturing deal type, deal number, transaction number, action type, counterparty and client codes, creation date, company code, status, file name, deal subtype, currency, counterparty and client advices, an amount, and an organization flag.
  • INS_ACTUALS — Inserts actual fund or portfolio figures over a date range, including company, currency, portfolio, amount unit, income/interest guarantee indicators, a unique reference number, and floating-less attributes.
  • VALIDATE_DEALS — Performs validation of a specific deal, keyed by deal number, transaction number, deal type, action type, and the validating user. This is the routine associated with the user search term "validate_deals".
  • MAINT_PROJECTED_BALANCES — Maintains projected balances, typically invoked as part of balance recalculation or period processing.
  • CHK_PRO_AUTH — Checks product or processing authority for a given event, company code, user, deal type, and action, enforcing authorization rules.
  • SETOFF — Executes set-off processing, netting or offsetting related treasury positions.

Tables Accessed

The package reads and writes through APPS synonyms. Deal-centric procedures such as DEAL_ACTIONS and VALIDATE_DEALS interact with XTR_DEALS, XTR_DEAL_DATE_AMOUNTS, and XTR_DEAL_TYPES. Confirmation handling touches XTR_CONFIRMATION_ACTIONS and XTR_CONFIRMATION_DETAILS. Audit routines use XTR_AUDIT_COLUMNS and XTR_AUDIT_SUMMARY. Cash and bank processing relies on XTR_BANK_ACCOUNTS, XTR_BANK_BALANCES, and XTR_BANK_BAL_INTERFACE. Authorization checks reference XTR_COMPANY_AUTHORITIES. Exposure and futures processing use XTR_EXPOSURE_TRANSACTIONS, XTR_INTEREST_RATE_EXPOSURE, and XTR_FUTURES, while inter-account movements use XTR_INTERACCT_TRANSFERS.

Usage Notes

XTR_MISC_P is typically invoked from ETRM deal entry and confirmation forms, concurrent programs that perform audit reporting or projected balance maintenance, and from peer ETRM packages that require deal validation or authorization verification. Because VALIDATE_DEALS is called during deal booking and amendment workflows, customizations that extend deal validation should reference it rather than duplicate its logic. As an OTHER-classified API, it carries no formal backward-compatibility guarantee across patch levels or releases; developers extending ETRM should treat these signatures as internal and validate behavior against the specific 12.1.1 or 12.2.2 environment in use.