PJO_PROCESS_REPORT

This table is used to store errors reported during the Import process. The records will be used to generate the BI reports.

Details

• Schema: FUSION

• Object owner: PJO

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PLAN_VERSION_XFACE_ID	NUMBER		18		To hold the PLAN_VERSION_XFACE_ID from PJO_PLAN_VERSIONS_XFACE table
MESSAGE_USER_DETAILS	VARCHAR2	4000			MESSAGE_USER_DETAILS
PROCESS_CODE	VARCHAR2	30		Yes	The code the ess job that is logging the error.
REPORT_LINE_TYPE	VARCHAR2	30		Yes	The type of error line that is logged.
REPORT_LINE_NUM	NUMBER		5	Yes	The line num of the error. This will be stored for other summary data as well.
LOADER_REQUEST_ID	NUMBER		18		The request Id of the central ess job that is used to load data into the interface tables.
LOAD_REQUEST_ID	NUMBER		18		The request Id of the central ess job that is used to load data into the interface tables.
LOADER_REQUEST_FILE_NAME	VARCHAR2	240			Name of the file that is used to load data into interface tables.
DATA_REF_COL1	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL2	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL3	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL4	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL5	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL6	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL7	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL8	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL9	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL10	VARCHAR2	255			The data which will be used to identify the error record.
DATA_REF_COL11	VARCHAR2	255			Reserved for Future Use
DATA_REF_COL12	VARCHAR2	255			Reserved for Future Use
DATA_REF_COL13	NUMBER		20		Reserved for Future Use
DATA_REF_COL14	NUMBER		20		Reserved for Future Use
DATA_REF_COL15	VARCHAR2	255			Reserved for Future Use
DATA_REF_COL16	NUMBER		18		Reserved for Future Use
RESOURCE_FORMAT	VARCHAR2	240			Resource format name for the resource which has errored out.
FIRSTLEVEL_RSRC_NAME	VARCHAR2	300			First level resource name.
SECONDLEVEL_RSRC_NAME	VARCHAR2	300			Second level resource name.
THIRDLEVEL_RSRC_NAME	VARCHAR2	300			Third level resource name
DATA_REF_COL17	NUMBER		18		Reserved for Future Use
DATA_REF_COL18	VARCHAR2	255			Reserved for Future Use
DATA_REF_COL19	VARCHAR2	255			Reserved for Future Use
MESSAGE_NAME	VARCHAR2	70			The error code which is predefined for interface.
MESSAGE_TEXT	VARCHAR2	2000			The deatils text of the message.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PLANNING_CURRENCY	VARCHAR2	15			To display planning currency in the output report

Indexes

Index	Uniqueness	Tablespace	Columns
PJO_PROCESS_REPORT_N1	Non Unique	FUSION_TS_TX_DATA	REQUEST_ID, PROCESS_CODE