eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FTP.FTP_CF_CORRECTIONS

Object Details

Object Name:	FTP_CF_CORRECTIONS
Object Type:	TABLE
Owner:	FTP
Subobject Name:
Status:	VALID

The FTP_CF_CORRECTIONS table contains a log of data inconsistencies found, and corresponding data corrections made, during a Cash Flow Edits rule run. You can access the log using Oracle Discoverer and should review the log following the execution of any transfer pricing process.
The FTP_CF_CORRECTIONS table replaces the OFSA_PROCESS_CASH_FLOWS table used in Oracle Financial Data Manager (FDM), Release 4.5.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTP_CF_CORRECTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID SEQUENCES

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(10)	Yes	Key column that corresponds to system identifier number of Transfer Pricing Process rule. All results for Cash Flow Edit processing run are stored with same object identifier value.
SEQUENCES	NUMBER	(5)	Yes	Sequence number for the error
ID_NUMBER	NUMBER	(25)	Yes	Identifies the instrument record that generated the error or correction
SOURCE_SYSTEM_CODE	NUMBER		Yes	Application from which the cash flow edit processing was initiated
FIELD_NAME	VARCHAR2	(30)		Name of field, or column, in the table for which error or correction was raised
FIELD_VALUE	VARCHAR2	(80)		Value of FIELD_NAME before the process was completed
CORRECTED_VALUE	VARCHAR2	(80)		Value of FIELD_NAME after the process was completed
DEFAULT_VALUE	VARCHAR2	(80)		Default value for FIELD_NAME
SEVERITY	NUMBER	(7)		Severity of the error
TABLE_NAME	VARCHAR2	(30)	Yes	Table name for the column identified in FIELD_NAME
ERROR_DESCRIPTION	VARCHAR2	(400)		Describes the error
ERROR_CODE	NUMBER	(9)	Yes	Code for the message sent to the log table
ERROR_DATE	DATE			Date the error or correction was generated
CREATION_DATE	DATE		Yes	Standard Who column. Date cash flow edit rule was created.
CREATED_BY	NUMBER		Yes	Object that created the row
LAST_UPDATED_BY	NUMBER		Yes	Object that last updated the row
LAST_UPDATE_DATE	DATE		Yes	Date of last update to the row
LAST_UPDATE_LOGIN	NUMBER			Last login associated with last update

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_ID
,      SEQUENCES
,      ID_NUMBER
,      SOURCE_SYSTEM_CODE
,      FIELD_NAME
,      FIELD_VALUE
,      CORRECTED_VALUE
,      DEFAULT_VALUE
,      SEVERITY
,      TABLE_NAME
,      ERROR_DESCRIPTION
,      ERROR_CODE
,      ERROR_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FTP.FTP_CF_CORRECTIONS;

Dependencies

[top of page]

FTP.FTP_CF_CORRECTIONS does not reference any database object

FTP.FTP_CF_CORRECTIONS is referenced by following:

APPS: FTP_CF_CORRECTIONS