Search Results iby_f_t_ca_grntrs_b




Overview
Explore in AI Chat

Overview

The IBY_F_T_CA_GRNTRS_B table is a core data object within the Oracle E-Business Suite (EBS) Payments (IBY) module, specifically for releases 12.1.1 and 12.2.2. It functions as the base table for storing transactional information about grantors associated with credit applications. In the context of the Payments module's credit management functionality, this table is essential for managing the relationships between credit applications and the parties (grantors) who authorize or guarantee the credit. It serves as the central point of reference for all grantor-related data tied to a specific credit application, enabling detailed tracking and audit capabilities.

Key Information Stored

The primary data stored in this table revolves around the unique identification of a grantor record and its linkage to a parent credit application. The documented primary key is the column CREDIT_APP_GRNTR_ID, which uniquely identifies each grantor record in the system. A critical foreign key column is CREDIT_APP_ID, which ties each grantor back to its originating credit application record in the IBY_F_T_CRDT_APPS_ALL_B table. While the full column list is not detailed in the provided metadata, the structure implies the table holds the core, non-translatable attributes of a grantor, such as creation dates, status identifiers, and references to related party or contact information.

Common Use Cases and Queries

This table is primarily accessed for reporting, data validation, and integration processes related to credit application approvals. A common use case is generating a report of all grantors for a specific set of credit applications to understand authorization hierarchies. A typical query would join to the credit applications table and potentially the grantor history table for a complete audit trail.

  • Sample Query: Retrieving grantor details for a specific credit application ID. 
    SELECT grntr.*
FROM iby.iby_f_t_ca_grntrs_b grntr
WHERE grntr.credit_app_id = :p_credit_app_id;
  • Data Validation: Ensuring every active credit application has at least one associated, active grantor record as per business rules.
  • Integration: Serving as the source for feeding grantor information to downstream financial or CRM systems during credit lifecycle events.

Related Objects

The IBY_F_T_CA_GRNTRS_B table is a central node in a defined relational schema, with documented foreign key relationships to several other Payment tables.

  • IBY_F_T_CRDT_APPS_ALL_B: The parent table. Each record in IBY_F_T_CA_GRNTRS_B must relate to a single credit application via the CREDIT_APP_ID column.
  • IBY_F_T_CA_GRNTRS_TL: A translation table that holds language-specific, translatable descriptions for the grantor records, joined via the CREDIT_APP_GRNTR_ID.
  • IBY_F_T_CA_GRNTR_H: A history table that tracks changes to the grantor records over time, linked by the CREDIT_APP_GRNTR_ID.
  • IBY_F_T_EMAIL_NOTIF_LOG: Stores logs of email notifications sent concerning grantors, referenced by the CREDIT_APP_GRNTR_ID.