Posted Customer Data

After you post pending items to a customer and age them, the posted customer data tables contain summary data. If you do not use subcustomer qualifiers, none of the three subcustomer-oriented tables will contain information.

When no more open items exist in a business unit and customer combination, and after you run the Aging process, the customer aging and subcustomer aging tables do not contain any rows.

The PS_CUST_DATA and PS_SUBCUST_DATA tables contain balance and event information. Unless you know that you will never post to the customer or subcustomer again, do not remove or archive data from these tables.

If you archive these tables, delete rows for a customer only if the customer has no item information and has been inactive for a significant period of time. Do not delete these rows if another business unit has data that you need to maintain for the customer.

The PS_CUST_HISTORY and PS_SUBCUST_HISTORY tables contain one row for each history element for each fiscal year and accounting period. Unless you need history at the business unit level for the period, you can delete or archive history information that you no longer need. The system does not store business unit summary information. Instead, it derives that information by combining customer-level information.

You should compare the fiscal year and accounting period of the data that you selected to delete to your target fiscal year and accounting period. Because the system needs some of the history elements for other elements to work correctly, Oracle suggests keeping all history elements for a given fiscal year and accounting period.