Search Results iby_f_t_ca_grntr_h




Overview
Explore in AI Chat

Overview

The table IBY_F_T_CA_GRNTR_H is a core data object within the Oracle E-Business Suite (EBS) Payments (IBY) module. It functions as a historical audit trail for changes made to the records of credit application grantors. A grantor is typically a financial institution or party that extends credit. This table is critical for maintaining a complete, immutable record of modifications—such as updates to contact details, credit limits, or status—to grantor master data stored in its parent table. Its existence supports compliance, auditing, and troubleshooting requirements within the financial operations of EBS.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure is defined by its primary and foreign keys. The central column is CA_GRNTR_HISTORY_ID, which serves as the unique primary key for each historical entry. The table's cardinal relationship is established via the foreign key column CREDIT_APP_GRNTR_ID. This column references the specific grantor record (in table IBY_F_T_CA_GRNTRS_B) for which the history is being logged. Typical data captured in such history tables includes the old and new values of changed columns, the date and time of the change, and the identifier of the user or process that initiated the modification.

Common Use Cases and Queries

The primary use case is auditing the evolution of a grantor's master data. This is essential for financial governance, internal controls, and resolving discrepancies. A common reporting requirement is to generate a timeline of changes for a specific grantor or for all modifications within a date range. Support personnel may query this table to understand the state of a grantor record at a specific point in the past, often prior to a particular transaction.

Sample Query Pattern:
SELECT h.*, b.GRNTR_NAME
FROM iby.iby_f_t_ca_grntr_h h,
iby.iby_f_t_ca_grntrs_b b
WHERE h.credit_app_grntr_id = b.credit_app_grntr_id
AND b.GRNTR_NAME = '<Grantor Name>'
ORDER BY h.<history_timestamp_column> DESC;

Related Objects

The table has a direct and fundamental relationship with the grantor master table, as documented in the provided metadata.

  • Primary Key: IBY_F_T_CA_GRNTR_H_PK on column CA_GRNTR_HISTORY_ID.
  • Foreign Key (References): The table IBY_F_T_CA_GRNTR_H contains a foreign key constraint where its column CREDIT_APP_GRNTR_ID references the primary key of the table IBY_F_T_CA_GRNTRS_B. This establishes a one-to-many relationship where one grantor master record can have multiple associated history entries.