Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.4.4
  • All Products

Table of Contents

Search

  1. Preface
  2. Start Here
  3. Financial Management
  4. Human Capital Management
  5. CRM
  6. Logistics and Discrete Manufacturing
  7. Process Manufacturing
  8. Trade Management
  9. Order Management
  10. Payroll
  11. Projects
  12. Workflow (FND)
  13. Business Intelligence

Oracle E-Business Suite Accelerator Reference

Oracle E-Business Suite Accelerator Reference

Back Next

Worksheet: Customer Transactions

Worksheet: Customer Transactions

The following table lists the parameters for the Receivables entity.
Parameter
Description
Operating Unit
The Operating Unit to purge transactions for. If Operating Unit is NULL, Data Archive processes all operating units.
Default is NULL.
Period To
Required. Qualifying invoices, POs and Requisitions must not have any activity or updates prior to this date.
GL Date Type
Required. The GL Type to compare the Period To date. Valid GL Dates Types are:
  • Invoice. The Period To Date is compared to the GL Date on the Invoice Distribution lines.
  • Receipt. The Period To Date is compared to the GL Date for the Receipt.
  • All. The Period To Date is compared to the GL Date for both the Invoice and Receipt.
To ensure data integrity across modules, we recommend that you select 'All'. However, this will most likely result in fewer transactions being selected. The GL Date Type that you choose should be consistent with your archive or purge strategy.
Postable Items Only
Required. By setting this flag to Yes, Data Archive processes customer transactions that have been posted to GL.
We recommend that you select 'Yes' to process posted transactions only.
Open Receivables Only
Required. By setting this flag to No, Data Archive processes customer transactions that are closed. Open receivables can never be closed and therefore, never posted to GL. To ensure data integrity across modules, we recommend that you do not archive or purge Open Receivables.
We recommend that you select 'No' to process closed receivables only.
Customer
The Customer to purge Sales Orders for. If customer is NULL, Data Archive processes all customers.
Default is NULL.
0 COMMENTS
We’d like to hear from you!