3/18/2020 Document 732189.
1
Copyright (c) 2020, Oracle. All rights reserved. Oracle Confidential.
R12.0.6+ : Oracle Receivables AutoInvoice Setup Setup Test (Doc ID 732189.1)
R12.0.6+ : ORACLE RECEIVABLES (AR): AUTOINVOICE SETUP SETUP DIAGNOSTIC TEST
Disclaimer
The information, software, products and services contained on this web site may be out of date or include omissions, inaccuracies or other errors. The information, software products and services contained on
this web site, including the materials, are provided "as is" and without warranty. Oracle does not warrant that the information in the materials is up to date or error free, nor does it provide any other warranties,
whether expressed or implied in law, including the implied warranties of merchantability or fitness for a particular purpose. The materials are not a program or documentation under the terms of your license
agreement(s) with Oracle.
In no event shall Oracle be liable for any direct, indirect, incidental, special or consequential damages, or damages for loss of profits, revenue, data or use, incurred by you or any third party, whether in an action
in contract or tort, arising from your access to, or use of, this web site or any other hyperlinked web site.
Oracle reserves the right to make changes or updates to this web site or the products or programs described in this web site at any time without notice.
In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision
instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
Description Reference & Resources Menu
This diagnostic validates and documents the basic setup of AutoInvoice for a given batch source in
a given operating unit. It provides System option, Batch Source, Grouping Rules, Flexfield Submit Feedback
information, Pro*C file versions, table indexes and disabled triggers. Community: EBS Diagnostic Tools
Overview
Run this test to verify the setup of AutoInvoice or to troubleshoot issues like bad performance Installation Guide
encountered when running AutoInvoice. FAQ
11i Diagnostic Catalog
Error and warning messages, followed by suggested actions, identify possible problem areas. R12 Diagnostic Catalog
Training
EBS Applicable Releases: 12.0.6 + Tips and Tricks
Application Name: Oracle Receivables Latest Diagnostic Patches
Test Group: Transactions Latest XML Files
Test Name: AutoInvoice Setup RDA 4 Getting Started
This test was last released on: 05-NOV-08 Master Reference List of Maintenance Wizard
USAGE INSTRUCTIONS
To execute the test, do the following:
[Link] 1/4
3/18/2020 Document 732189.1
1. Start Oracle E-Business Suite
2. Connect to responsibility Application Diagnostics
3. Select the Diagnose menu option
4. Click button Select Application and select Application "Oracle Receivables"
5. Scroll down to group "Transactions"
6. Select test name "AutoInvoice Setup"
7. Input Parameters (* required)
Responsibility ID
Operating Unit Id
Batch Source Id
8. Output contains
Database Information
Application Information
Oracle Diagnostics Information
Product Installation Status and Patchset Level
Parameters
System Options
Batch Source
Grouping Rule
Ledger Definition
Open Calendar Periods Oracle Receivables
Open Calendar Periods General Ledger
Accounting Flexfield
Territory Flexfield
Line Transaction Flexfield
Invoice Transaction Flexfield
Linkto Transaction Flexfield
Reference Transaction Flexfield
Profile Options
Application Setup
Active Import Batch Sources
AutoAccounting Setup
Pro*C File Versions
AutoInvoice Interface Totals
Indexes on RA_CUSTOMER_TRX_ALL
Indexes on RA_CUSTOMER_TRX_LINES_ALL
Indexes on RA_INTERFACE_LINES_ALL
Indexes on RA_INTERFACE_DISTRIBUTIONS_ALL
Indexes on RA_INTERFACE_SALESCREDITS_ALL
Indexes on GL_CODE_COMBINATIONS
Indexes on MTL_SYSTEM_ITEMS_B
Indexes on RA_TERRITORIES
Interface Database Triggers
Invalid Objects
Disabled Triggers
References
[Link] 2/4
3/18/2020 Document 732189.1
If this test is not available click on the "Installation Guide" link in the "Reference & Resources Menu".
ADDITIONAL INFORMATION
View Sample Output
End of Document
[Link] 3/4
3/18/2020 Document 732189.1
Didn't find what you are looking for?
[Link] 4/4