Search Results check_deal_duplicate_id




Overview
Explore in AI Chat

Overview

XTR_IMPORT_DEAL_DATA is an APPS-owned PL/SQL package within the Oracle E-Business Suite Treasury (ETRM) module. Its primary business function is to import, validate, and persist treasury deal data captured in the ETRM interface tables into the production deal tables. In practice, the package serves as the bridge between externally sourced or internally staged deal records and the live XTR_DEALS repository, translating interface staging rows into validated deal and transaction records while capturing errors, warnings, and confirmation messages for downstream review.

The package is documented with a VALID status in ETRM 12.2.2 and remains relevant to the 12.1.1 line. It is classified as an OTHER API type (not a public application programming interface), which indicates it is an internal processing utility invoked by ETRM transfer and import logic rather than an integration endpoint intended for direct external calls.

Key Procedures and Functions

The package exposes twelve documented procedures and functions:

  • TRANSFER_DEALS — the primary driver routine that moves deal records from the interface tables into the production deal tables.
  • TRANSLATE_DEAL_DETAILS — translates interface deal detail values, including descriptive flexfield data, into their production representations.
  • TRANSLATE_DEAL_DETAILS_UI — the UI-facing counterpart of the translation logic, used when deal details are processed interactively.
  • LOG_INTERFACE_ERRORS — records errors encountered during interface processing into the interface error repository.
  • LOG_DEAL_WARNING — captures non-fatal warnings arising from deal import processing.
  • LOG_SUCCESSFUL_DEAL — records confirmation that a deal was imported successfully.
  • LOG_FAILED_DEAL — records deals that could not be imported, preserving the failure context.
  • CHECK_DEAL_DUPLICATE_ID — checks whether a deal identifier already exists, supporting duplicate prevention.
  • PUT_LOG — writes a generic log entry to the ETRM logging mechanism.
  • CHECK_USER_AUTH — verifies that the executing user is authorized to perform the import.
  • VAL_DESC_FLEX — validates descriptive flexfield values supplied on the deal record.
  • VAL_TRANSACTION_DESC_FLEX — validates descriptive flexfield values on the associated transaction record.

Tables Accessed

The package operates across a focused set of ETRM tables, referenced through APPS synonyms:

  • XTR_DEALS_INTERFACE — the staging source of deal-level header data awaiting import.
  • XTR_TRANSACTIONS_INTERFACE — the staging source of transaction-level deal detail lines.
  • XTR_DEALS — the production deal table targeted by the transfer process.
  • XTR_INTERFACE_ERRORS — the error and message repository populated by the LOG_* routines.
  • XTR_INTERGROUP_TRANSFERS — supports intergroup transfer deal processing.
  • PLITBLM — the standard Oracle Applications PL/SQL table/library utility package used internally.

Usage Notes

XTR_IMPORT_DEAL_DATA is invoked indirectly rather than directly by end users. The metadata confirms it is referenced by four other packages: XTR_EXP_TRANSFERS_PKG, XTR_FX_TRANSFERS_PKG, XTR_IG_TRANSFERS_PKG, and XTR_NI_TRANSFERS_PKG. These transfer packages represent expense, foreign exchange, intergroup, and net investment hedging workflows respectively, and they call the import package to persist staged deals in each scenario.

Typical invocation occurs through ETRM concurrent programs and deal entry forms that submit interface records for processing, or through custom code that stages records into XTR_DEALS_INTERFACE and XTR_TRANSACTIONS_INTERFACE and then triggers the transfer. Because the package is classified as OTHER, Oracle does not guarantee its signature across releases; custom integrations should wrap calls defensively. Errors and warnings are surfaced through XTR_INTERFACE_ERRORS, so support and reconciliation activities should review that table after each import cycle.