My Oracle Support Banner

R12: PATTAR Completes AutoAccounting Error Code=1: Problem Determining Invoice Type (Doc ID 108051.1)

Last updated on AUGUST 19, 2022

Applies to:

Oracle Project Billing - Version to 12.2.3 [Release 11.5.10 to 12.2]
Oracle Projects - Version to 12.2.3 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Executable:PATTAR - PRC: Interface Invoices to Receivables
Executable:PAXARTRX - IMP: Create Invoice Organization Transaction Types


When interfacing invoices from Projects (PA) to Receivables (AR), the PRC: Interface Invoices to Receivables process (PATTAR), completes with an error while determining Invoice Type. The Debug Log file looks similar to the following:

The user has previously run the process: IMP: Create Invoice Organization Transaction Types (PAXARTRX)to create invoice types in AR without error or exception. Users have also gone through steps 1 to 8 in Note: 1041009.6 and ensured all steps were properly completed.

Users may be adding PA functionality to an existing install or this problem may be surfacing now when the process worked previously.

Users are employing a User Defined Flexfield (DFF) in the transaction type screen (RAXSUCTT) that populates RA_CUST_TRX_TYPES.ATTRIBUTE1. After creating the transaction types (PAXTRARX). Navigate to the transaction type screen (RAXSUCTT) and query through the PA types (PA Invoices, PA invoice, Projects Invoice PA Credit Memo etc.). Note the value populated in the DFF you defined is not from your previously defined lookup set.

If the user makes changes to this transaction type but does not change the DFF value and attempt to save, the user MAY receive a message that an invalid value is entered.




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

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

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