Search Results fv_tp_ts_amt_data

Overview

The table FV_TP_TS_AMT_DATA is a core data repository within the Federal Financials (FV) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is owned by the FV schema and holds a VALID status, indicating it is an active and supported object. This table plays a critical role in the Treasury Payment (TP) and Treasury Settlement (TS) processes, which are integral to the U.S. federal government's financial management. Specifically, it stores detailed transactional amount data related to payment instructions, acting as a junction table that links federal financial transaction details to the broader Oracle Payments (IBY) framework for execution and settlement.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationship explicitly reveals one of its most critical columns: PAYMENT_INSTRUCTION_ID. This column is the direct foreign key to the IBY_PAY_INSTRUCTIONS_ALL table, which is the central Oracle Payments table for all payment instructions. This structure confirms that FV_TP_TS_AMT_DATA stores granular financial data—such as obligation, accrued expenditure, or outlay amounts—associated with specific federal payment instructions. Other columns in this table would typically store identifiers for the source transaction (e.g., from Federal Budgetary Accounting), amount types, and the monetary values themselves, enabling detailed audit trails and reconciliation for Treasury reporting.

Common Use Cases and Queries

This table is primarily accessed for generating Treasury reports, reconciling payment batches, and troubleshooting settlement issues. A common use case involves tracing the financial amounts of a settled payment back to its original budgetary accounting entries. A typical query would join this table to the payments instruction table to analyze amounts for a specific batch or document. For example:

• Reporting on Payment Instruction Amounts: SELECT tp.payment_instruction_id, tp.amount_type, tp.amount, iby.payment_instruction_status FROM fv_tp_ts_amt_data tp, iby_pay_instructions_all iby WHERE tp.payment_instruction_id = iby.payment_instruction_id AND iby.creation_date > SYSDATE - 30;
• Reconciliation: Financial analysts use queries against this table to ensure the total amounts being sent for Treasury settlement match the sums of obligations or accrued expenditures in the general ledger.

Related Objects

The primary and most significant related object is the IBY_PAY_INSTRUCTIONS_ALL table, as defined by the foreign key relationship. This link is essential for integrating Federal Financials' proprietary accounting logic with the standard Oracle Payments engine. The table is also intrinsically related to other core FV tables that feed it transaction data, such as those underlying the Funds Available, Budget Execution, and Payment Manager processes. While not listed in the excerpt, it is common for such a table to have associated public Application Programming Interfaces (APIs) or views (e.g., FV_TP_TS_AMT_DATA_V) that provide a secure and validated method for programs and reports to access this sensitive financial data.