My Oracle Support Banner

Troubleshooting Transaction Batch Sources For AutoInvoice and Transactions Workbench (Doc ID 1088132.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program
Executable:RAXMTR - Autoinvoice Master ProgramForm
RAXSUMSC.FMB - Define Invoice Sources
Form:ARXTWMAI.FMB - Transactions


For additional information, reference Note 1068008.1, Creating Transaction Sources Used For AutoInvoice and the Transactions Workbench.

Oracle Receivables (AR): AutoInvoice Information Center > Generic Setup and Troubleshooting Resources > Note 1088132.1

Oracle Receivables (AR): Transactions Workbench Information Center > Note 1088132.1

This note is intended to facilitate troubleshooting Transaction Source issues. It will explain common transaction source related problems that may be encountered while importing transactions via AutoInvoice or while creating transactions manually in the Transactions form.

Review this information whenever a new transaction source is defined and you experience issues in AutoInvoice of the Transactions form. For example, you add a new transaction source for legacy related invoices and the AutoInvoice process fails for the new transaction source but works for other sources.

Additional References:


Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 1.  Batch Source Tab
      a.  Transaction Numbering
         i.  Transaction Source Sequence
         ii.  Automatic Transaction Number Has Gaps
         iii.  AutoInvoice Fails Due to Missing Sequence
         iv. Transaction Source Form Fails with Error Selecting From Sequence
      b.  Copy Transaction Flexfield To Credit Memo
       c.  Line Level Balances
       d.  Receipt Handling For Credits
      e.  Transaction Source End Date 
 2.  AutoInvoice Options Tab
      a.  GL Date In A Closed Period
       b.  Invalid Line (Reject/Create Invoice)
       c.  Grouping Rules
 3.  Customer Information Tab
       a.  Customer Validation In AutoInvoice
       b.  Bank Account
 4.  Accounting Information Tab
       a.  Accounting Rules
       b.  Accounting Flexfield
       c.  Derive Date
       d.  Payment Term
 5.  Other Information Tab
       a.  Inventory Item
         i.  Margin Analysis Report
 6.  Sales Credit Validation Tab
      a.  Sales Credit Equals 100 Percent
      b.  Salesreps Required
 7.  Known Issues
      a.  Submitting AutoInvoice, No Values Listed for Parameter Transaction Source
      b.  Altered Seeded Transaction Sources
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.