Oracle EBS：安全打开成本期间与恢复脚本

/* +=======================================================================+
 *                     Undo/Reset OPM Costed Flags 
 * +=======================================================================+
 *
 * IMPORTANT NOTE:
 * ===============
 *
 * 1. This script should be used by authorised Oracle personnel only.
 *  Use of this script must be approved by:
 *    OPM Financial Manager
 *    OPM Level 2 Support Manager
 *    Customer Management
 *
 * 2. Running this script without control/due care may severly damage the 
 *    customer's sub-ledger.
 *  a.  Advice the customer to perform a complete backup and
 *      create a test environement.
 *  b.  Make sure that the customer understands that this script will
 *      only resets costed flags for transactions in process enabled 
 *    organizations, so that these transactions can be considered 
 *    for processing by ACP/Preprocessor during next runs. For 
 *    reversing/deleting of GL postings , Please reverse GL batches posted. 
 *  c.  Run the script in the test environment first.
 *  d.  Ask customer to run the process (ACP/Pre-processor) again.
 *    Verify the results. 
 *  e.  IF THE RESULTS ARE ACCEPTABLE RUN THE SCRIPT IN PRODUCTION
 *      ENVIRONMENT.
 * 
 * 3. This script must be immediately removed from the customer's machine
 *    as soon as possible.  This is to prevent any accidental execution

 *    by the customer's personnel.
 *
 *
 * How to Use:
 * ===========
 *   - Make sure you backup all the related tables
 *     mtl_material_transactions
 *     gmf_rcv_accounting_txns
 *     gmf_invoice_distributions
 *     gmf_incoming_material_layers
 *     gme_resource_txns
 *     gme_batch_header
 *     gmf_lot_cost_adjustments
 *     gmf_period_balances
 *     cm_adjs_dtl
 *     gl_aloc_dtl
 *     gmf_transaction_valuation
 *     xla_distribution_links
 *     xla_ae_lines
 *     xla_ae_segment_values
 *     xla_ae_headers
 *     gmf_xla_extract_lines
 *     gmf_xla_extract_headers
 *
 *
 *   - Perform reversing/deleting of GL postings based on GL batches posted. 
 *         After performing the reversals of batches make sure that the reversal/deleting 
 *         of GL postings has happened correctly from GL side. 
 *         Once that is made sure, only then proceed 
 *     for next step to reset OPM costed flags using THIS script.