Search Results iby_docs_payable_gt




Overview
Explore in AI Chat

Overview

IBY_DOCS_PAYABLE_GT is a global temporary table (denoted by the _GT suffix) owned by the IBY schema within Oracle EBS Payments. It serves as a transient staging structure for Oracle Payments (IBY) payable document processing. Unlike the persistent IBY_DOCS_PAYABLE_ALL table, which stores the definitive record of payable documents, IBY_DOCS_PAYABLE_GT holds working-set rows scoped to a single session or transaction during payment build, formatting, and instruction generation. Its role is procedural: it carries document-level attributes into the payment engine so that formatting programs and payment instruction build routines can consolidate, group, and serialize payable records without committing intermediate state to the permanent schema.

The ETRM Data Vault classification for this object is standalone, indicating that the FK heuristic did not identify it as a conventional hub, link, or satellite. Modelers can interpret this as guidance that the table behaves as a session-scoped staging satellite rather than a durable Data Vault construct; its data typically maps to a satellite keyed on the persistent payable document identifier held in IBY_DOCS_PAYABLE_ALL.

Key Information Stored

The documented physical schema contains 81 columns. The most significant are:

Common Use Cases and Queries

The table is used almost exclusively by Oracle Payments internal concurrent programs during payment instruction build and formatting. Typical investigative queries suppress duplicates and restrict to the current session because the table is global temporary:

  • Reconcile a staged payable against its persistent parent: SELECT g.* FROM iby.iby_docs_payable_gt g WHERE g.document_payable_id = :id joined to IBY_DOCS_PAYABLE_ALL.
  • Report grouped payments: aggregate PAYMENT_AMOUNT by PAYMENT_GROUPING_NUMBER, PAYMENT_METHOD_CODE, and PAYMENT_CURRENCY_CODE.
  • Diagnose missing payments by comparing expected source documents (via CALLING_APP_DOC_UNIQUE_REF1–5) to rows present in the GT.
  • Validate document sequencing outcomes using DOC_SEQUENCE_ID and DOC_SEQUENCE_VALUE.

Related Objects

  • IBY_DOCS_PAYABLE_ALL — the persistent parent, joined on DOCUMENT_PAYABLE_ID.
  • IBY_ACCT_PMT_PROFILES_B — payment profile configuration, joined on PAYMENT_PROFILE_ID.
  • FV_LEGAL_ENTITIES — legal entity context, joined on LEGAL_ENTITY_ID.
  • FND_DOCUMENT_SEQUENCES — sequence assignment, joined on DOC_SEQUENCE_ID.
  • IBY_PAY_SERVICE_REQUESTS and IBY_PAY_INSTRUCTIONS_ALL — downstream payment instruction and service request objects that consume staged rows.
  • IBY_FD_PAYMENT_FORMAT_APIS — formatting routines that read GT rows to produce output.