Archiving Data
This section provides overviews of the archive process flow and history tables, and lists the pages used to archive data.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
Archive Data to History Page |
PSARCHRUNCNTL |
Select an archive template and query and select the action you want to take in the archiving process. See the product documentation for PeopleTools: Data Management, Accessing the Data Archive Manager Homepage. |
|
Define Archive Query Binds Page |
PSARCHRUNQRYBND |
Enter the date used to select the transactions to archive by clicking the Reset Query Bind Variables button. See the product documentation for PeopleTools: Data Management, Managing Archive Jobs. |
|
Audit Archiving Page |
PSARCHIVEAUDIT |
View the number of rows selected to be archived for each table for a specific archive run. See the product documentation for PeopleTools: Data Management, Accessing the Data Archive Manager Homepage. |
Archive transaction data as follows:
Archive transaction data to the history tables by selecting the archive template and query for the data type that you want to archive on the Archive Data to History page.
Also, enter the From and To date used to select the transactions by clicking Reset Query Find Variables on the Define Archive Query Binds page. There is also a Process Instance field that will be pre-filled with 9999999999. This can be whatever value, the Archive Pre-Process Application Engine program will populate the Process Instance with the actual value
This table shows what the system compares the archive date to for the different data types:
Data Type
Archive Date
Payment
From Date, To Date, Process Instance.
From Date, To Date, Bank SetID, Bank Code, Bank Account Key, Process Instance.
Voucher
From Date, To Date, Process Instance.
From Date, To Date, Business Unit, Process Instance.
Supplier
As of Date.
As of Date, SetID.
As of Date, SetID, Supplier Classification.
As of Date, SetID, Supplier Persistence.
As of Date, SetID, Supplier Status.
Note: You can run the process multiple times to create various "what-if" scenarios based on the archive date.
(Optional) Review the number of rows that were selected for archiving for each table on the Audit Archiving page.
This page lists the number of rows that were selected for archiving for each archive ID (template), archive batch number, and table combination.
Note: This page displays data only if you selected the Audit Row Count check box on the Archive Data to History page.
Delete the data from the transaction tables for a specific archive ID (template) and batch number on the Archive Data to History page.
(Optional) Rollback the transaction data from the history tables for a specific archive ID (template) and batch number on the Archive Data to History page if you deleted the transaction data in error.
Remove the transaction data from the history tables for a specific archive ID (template) and batch number on the Archive Data to History page.
PeopleSoft Payables updates these history tables when you run the selection process:
|
Data to Archive |
FROM History Table |
TO History Table |
|---|---|---|
|
Payment data |
PAYMENT_TBL |
AP_ARC_PYM_TB_H |
|
PAYMENT_RCN_TBL |
AP_ARC_PYM_RC_H |
|
|
PYMNT_ADVICE |
AP_ARC_PYM_AD_H |
|
|
Voucher data |
BCH_XREF_EXT |
AP_ARC_BCH_XR_H |
|
DISTRIB_LINE |
AP_ARC_DIST_L_H |
|
|
DISTRIB_LINE_NP |
AP_ARC_DIST_N_H |
|
|
PYMNT_VCHR_MSG |
AP_ARC_PY_MSG_H |
|
|
PYMNT_VCHR_WTHD |
AP_ARC_PYM_WT_H |
|
|
PYMNT_VCHR_XREF |
AP_ARC_PYM_XR_H |
|
|
VCHR_ACCTG_LINE |
AP_ARC_VCH_AC_H |
|
|
VCHR_DOCSEQ_HDR |
AP_ARC_VCH_DO_H |
|
|
VCHR_FRGH_CHRG |
AP_ARC_VCH_FR_H |
|
|
VCHR_LINE_TXGEO |
AP_ARC_VCH_TG_H |
|
|
VCHR_LINE_WTHD |
AP_ARC_VCH_WT_H |
|
|
VCHR_LN_EXS_DTL |
AP_ARC_VCHL_E_H |
|
|
VCHR_LN_TX_DTL |
AP_ARC_VCH_TX_H |
|
|
VCHR_MISC_CHRG |
AP_ARC_VCH_MS_H |
|
|
VCHR_RECV_MTCH |
AP_ARC_VCH_RM_H |
|
|
VCHR_SALETX_CHG |
AP_ARC_VCH_ST_H |
|
|
VCHR_USETAX_CHG |
AP_ARC_VCH_UT_H |
|
|
VCHR_VNDR_IBANK |
AP_ARC_VCH_VI_H |
|
|
VCHRLN_MISC_CHG O |
AP_ARC_VCHL_M_H |
|
|
VOUCHER_LINE |
AP_ARC_VCH_LN_H |
|
|
VOUCHER |
AP_ARC_VOUCH_H |
|
|
VOUCHER_HIPAA |
AP_ARC_VCH_HP_H |
|
|
VCHR_VNDR_BANK |
AP_ARC_VCH_VB_H |
|
|
VCHR_VNDR_INF |
AP_ARC_VCH_VN_H |
|
|
Supplier data |
VENDOR |
AP_ARC_VENDOR_H |
|
VENDOR_ADDR |
AP_ARC_VND_AD_H |
|
|
VENDOR_ADDR_PHN |
AP_ARC_VND_PH_H |
|
|
VENDOR_CNTCT |
AP_ARC_VND_CN_H |
|
|
VENDOR_ID_NBRS |
AP_ARC_VND_ID_H |
|
|
VENDOR_INVOICE |
AP_ARC_VND_IN_H |
|
|
VENDOR_LOC |
AP_ARC_VND_LC_H |
|
|
VENDOR_PAY |
AP_ARC_VND_PY_H |
|
|
VENDOR_TYPE |
AP_ARC_VND_TP_H |
|
|
VENDOR_WTHD |
AP_ARC_VND_WT_H |
|
|
VENDOR_WTHD_JUR |
AP_ARC_VND_WJ_H |
|
|
VNDR_ADDR_SCROL |
AP_ARC_VND_AS_H |
|
|
VNDR_BANK_ACCT |
AP_ARC_VND_BK_H |
|
|
VNDR_CNTCT_PHN |
AP_ARC_VND_CP_H |
|
|
VNDR_CNTCT_SCR |
AP_ARC_VND_CS_H |
|
|
VNDR_GOV_CERT |
AP_ARC_VND_GC_H |
|
|
VNDR_GOV_SRC |
AP_ARC_VND_GS_H |
|
|
VNDR_HDR_IND_CL |
AP_ARC_VND_HN_H |
|
|
VNDR_IBANK_ACCT |
AP_ARC_VND_IB_H |
|
|
VNDR_IND_CLASS |
AP_ARC_VND_IC_H |
|
|
VNDR_LOC_ID_NBR |
AP_ARC_VND_LI_H |
|
|
VNDR_LOC_SCROL |
AP_ARC_VND_LS_H |
|
|
VNDR_RTV_FEE |
AP_ARC_VND_RT_H |
|
|
VNDR_URL |
AP_ARC_VND_UR_H |
|
|
VNDR_VAT_RGSTRN |
AP_ARC_VND_VT_H |
|
|
VNDR_RPT_ELEM |
AP_ARC_VND_RP_H |
|
|
Payment Request data |
PR_REQUEST |
PR_REQUEST_H |
|
PR_ATT |
PR_ATT_H |
|
|
PR_LINE |
PR_LINE_H |
|
|
PR_DIST |
PR_DIST_H |
|
|
PV_ATTACHMENTS |
PR_ATTACHMENT_H |
|
|
PR_VNDR |
PR_VNDR_H |
|
|
Payment Request Message data |
PR_CONVER_REC |
PR_CONVER_REC_H |
|
PR_CONVER_HDR |
PR_CONVER_HDR_H |
|
|
PR_CONVER_LINE |
PR_CONVER_LINE |
The data in these tables is keyed by the archive ID (template) and batch number for each archive run. If you want to see all transactions that are selected to archive you can run a query on the history tables or you can run one of the PeopleSoft Payables archive reports.
You may not want to delete data from the history tables each time that you select and delete data from the transaction tables. This way the data will be available for a period of time to enable you to restore the data into the transaction tables. Oracle recommends that you create a schedule for deleting data from the history tables. Before you delete data from the history tables, you should use a third-party database utility to copy the contents to a flat file.
Important! If you decide to run the archive selection process again because you didn't select the correct data, you must first use the Data Archive Manager option to remove the data from the history tables.
Note: After archiving is complete for any tables which are part of a Search Definition (index) for this product, the search indexes should be incrementally built to remove the records from the index.