Previous | Next | Contents | Index | Navigation | Glossary | Library |
Note: The GL Date Type parameter does not apply if you choose to include transactions not eligible for posting. In this case the transaction date will be used for date checking.
Invoice | Invoice balance is reduced to zero by application of one or more of the following: Cash Receipts, Credit Memos, Approved Adjustments, or Deposits. |
Debit Memo | Debit Memo balance is reduced to zero by application of one or more of the following: Cash Receipts, Credit Memos, or Approved Adjustments. |
Credit Memo | Credit Memo balance is fully applied to one or more of the following: Invoices, Debit Memos, Chargebacks, or Cash Receipts. |
Chargeback | Chargeback is fully applied to either a Cash Receipt, Credit Memo, or an Approved Adjustment. |
Deposit | Deposit balance and commitment balance is fully applied to one or more invoices. |
Guarantee | Commitment balance is fully covered by one or more invoices. |
Cash Receipt | Receipt balance is fully applied to one or more of the following: Invoice, Debit Memo, Credit Memo, Chargeback, Deposit. If the receipt was not applied but has been reversed, it is also eligible for purge. |
Adjustment | Approved and Applied to an Invoice, Debit Memo, or Credit Memo. |
Note: No transactions in Oracle Projects are purged.
You specify your own criteria of what invoices to purge by adding your logic to the Receivables Invoice Purge client extension provided by Oracle Project Accounting. You first determine the logic that you want to include in the client extension. You then add and test your logic in the PL/SQL function client_purgeable in the package pa_ar_trx_purge. This function exists in the file PAXARPGB.pls located in the Oracle Project Accounting install/sql/ directory. Oracle Project Accounting provides the parameter of customer_trx_id to the client_purgeable function.
For more information on implementing your own logic using a client extension, refer to the Client Extensions and AutoApprove Profile Options chapter in the Oracle Personal Time and Expense System Administrator's Guide.
You specify your criteria by customizing the PL/SQL function trx_purgeable in the package arp_trx_purge. This function exists in the file ARPUPRGB.pls located in the Receivables install/sql/ directory. Receivables provides the parameter customer_trx_id to the trx_purgeable function which by default returns a true value. You need to add your logic to return a value of false for the customer_trx_id of the transactions you do not want to purge.
Previous | Next | Contents | Index | Navigation | Glossary | Library |