When you interface invoices and invoice lines to Oracle Receivables, Oracle Projects places invoice information into Oracle Receivables interface tables.
The GL Date of the invoice determines the accounting period in which it affects your general ledger account. Oracle Projects determines the GL Date as the end date of the open or future GL period in which the invoice date falls as defined in Oracle Receivables, when you generate an invoice.
If you are using the enhanced period processing option, Oracle Projects determines the GL Date the same as the invoice date for open GL periods or the start date of the next open or future GL period.
See: Date Processing in Oracle Projects.
When you interface invoices to Oracle Receivables, Oracle Projects uses AutoAccounting to determine several default receivables accounts for each invoice. For details about these default accounts, see: Accounting for Revenue and Invoices, Oracle Projects Implementation Guide.
The accounting transactions that the process creates are interfaced to Oracle Receivables interface tables. Oracle Projects only uses Oracle Receivables AutoAccounting to determine default tax accounts for invoice lines with tax classification codes, see: Accounting Transactions.
You run the Submit Accounting process in Oracle Receivables to create accounting for the invoices in Oracle Subledger. If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Oracle Receivables derives using the Account Generator. To define your own Oracle Subledger Accounting setup for Oracle Receivables, you must access the Accounting Methods Builder from an Oracle Receivables responsibility. For more information, see the Oracle Subledger Accounting Implementation Guide.
When invoice lines are interfaced to Receivables, the Agreement Number from Projects is copied to the PURCHASE_ORDER column and the INTERFACE_LINE_ATTRIBUTE3 column of the RA_INTERFACE_LINES_ALL table. Receivables copies this value to the PURCHASE_ORDER column in the customer transaction table, RA_CUSTOMER_TRX_ALL.
If the invoice being interfaced is a canceled invoice, credit memo, or write off, these columns are populated by a null value.
Note: The INTERFACE_LINE_ATTRIBUTE3 column contains a maximum of 30 characters. If the agreement number is longer than 30 characters, it is truncated in this column.
Oracle Receivables automatically matches invoices to the prepayments that have been applied to the agreement.
Each time you interface invoices to Oracle Receivables, Oracle Projects prints output reports (Account Receivables Interface Report and Account Receivables Interface Exception Report) which allow you to track your successfully interfaced invoices, as well as those invoices which fail to interface. You should correct any exceptions in Oracle Projects and resubmit the process to successfully import rejected invoices. See: Interface Invoices to Receivables.