Troubleshooting Transaction Flexfields in AutoInvoice
(Doc ID 1077555.1)
Last updated on JUNE 05, 2024
Applies to:
Oracle Receivables - Version 11.5.10.0 and later Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform.
Executable:RAXMTR - AutoInvoice Master Program
Executable:RAXTRX - AutoInvoice Import Program
Form:FNDFFMDC.FMB - Define Descriptive Flexfield Segments
This note was created to facilitate troubleshooting issues regarding Transaction flexfields in AutoInvoice.
AutoInvoice relies heavily on transaction flexfields to validate and process interface data. The combination of values in the descriptive flexfield segments uniquely identifies each transaction line. The primary types of transaction flexfields used in AutoInvoice are:
Line Transaction Flexfield
Link-to Transaction Flexfield
Reference Transaction Flexfield
Invoice Transaction Flexfield
These are discussed in detail in Note 1068344.1, Setting Up Receivables Descriptive Flexfields. It is very important that you review this note to ensure that you populated the proper fields as part of your data load for AutoInvoice.
The following table shows how data from interface columns end up in core AR tables.
Descriptive Flexfield
Field in RA_INTERFACE_LINES_ALL
Table Name
Field name in core AR tables
Invoice Transaction Flexfield
INTERFACE_LINE_CONTEXT
RA_CUSTOMER_TRX_ALL
INTERFACE_HEADER_CONTEXT
INTERFACE_LINE_ATTRIBUTE1-15
RA_CUSTOMER_TRX_ALL
INTERFACE_HEADER_ATTRIBUTE1-15
Transaction Information
HEADER_ATTRIBUTE_CATEGORY
RA_CUSTOMER_TRX_ALL
ATTRIBUTE_CATEGORY
HEADER_ATTRIBUTE1-15
RA_CUSTOMER_TRX_ALL
ATTRIBUTE1-15
Invoice Line Information
ATTRIBUTE_CATEGORY
RA_CUSTOMER_TRX_LINES_ALL
ATTRIBUTE_CATEGORY
ATTRIBUTE1-15
RA_CUSTOMER_TRX_LINES_ALL
ATTRIBUTE1-15
Line Transaction Flexfield
INTERFACE_LINE_CONTEXT
RA_CUSTOMER_TRX_LINES_ALL
INTERFACE_LINE_CONTEXT
INTERFACE_LINE_ATTRIBUTE1-15
RA_CUSTOMER_TRX_LINES_ALL
INTERFACE_LINE_ATTRIBUTE1-15
Link-To Transaction Flexfield
LINK_TO_LINE_CONTEXT
none
none
LINK_TO_LINE_ATTRIBUTE1-15
RA_CUSTOMER_TRX_LINES_ALL
The values in the attribute fields are used to identify a particular row in RA_CUSTOMER_TRX_LINES_ALL and are used to retrieve a CUSTOMER_TRX_LINE_ID value, which is then stored in LINK_TO_LINE_ID
Reference Transaction Flexfield
REFERENCE_LINE_CONTEXT
none
none
REFERENCE_LINE_ATTRIBUTE1-15
RA_CUSTOMER_TRX_LINES_ALL
The values in the attribute fields are used to identify a particular row in RA_CUSTOMER_TRX_LINES_ALL and are used to retrieve a CUSTOMER_TRX_LINE_ID value, which is then stored in REFERENCE_LINE_ID
Issues regarding Transaction flexfields in AutoInvoice are typically setup related, please review the symptoms listed below.
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!
