Oracle Payments: Data Model For Funds Capture Transactions Starting From TangibleID (PSON) (Doc ID 1219993.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Payments - Version 12 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Purpose

The purpose of this article is to give information about Oracle Payments Data Model for the transactional part of the Funds Capture portion of the product.

For a script based on information from this article refer to <NOTE 1233263.1> Oracle Payments: Funds Capture Transaction Data Gathering Script

Scope

The aim of this document is to assist in understanding the data model, and track existing transactions for research or investigation of issues. Consultants customizing may find this article useful as well.

The article will focus on looking up all data starting from a central ID within Oracle Payments: the Tangible_ID (Also known as PSON or Payment System Order Number) which is a unique identifier for Credit Card Transactions.