Projects Supplier Invoice Account Generation Error: APP-SQLAP-97734: The System Cannot Generate Distributions (Doc ID 823787.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to select all distributions' option in invoice workbench, the following error occurs.

ERROR
APP-SQLAP-97734: the system cannot generate distributions for line 1 because '&TOKEN2'

There can be a secondary workflow error:
ORA-20002: 3136: Item 'PAAPINVW/#SYNCH' cannot be accessed while synchronous process in progress.

STEPS
The issue can be reproduced at will with the following steps:
1. Payables>Invoices>Entry>Invoice Batches>Invoices

2. Press “ALL distributions” button and get next error:
APP-SQLAP-97734: The system cannot generate distributions for line 1 because '&TOKEN2'

Cause

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 hundreds of Community platforms