Tables updated by p_acq_05 and p_acq_06

• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
You are planning to run the p_acq_05 and p_acq_06 fiscal year rollover and want to know what files/tables they update (so that you can back out, if necessary, without doing a full restore).

Resolution:

z76 (budgets)
z601 (budget transactions)
z68 (orders)
z71 (order log)
z79 (order index)
z602 (sublibraries for Budget and Vendor) 
z62 (budget permissions)
z75 (invoice lines)
z77 (general invoice)

You can use either p_file_03 or the Oracle exp command for backing up the tables.

See also, the article " "Renew Order Encumbrance (p_acq_06)": pre-processing and back-up"  (KB 5510).