My Oracle Support Banner

R12.PA.PATTGL - PRC: Generate Revenue Accounting Events Program Errors With "ORA-01417: a table may be outer joined to at most one other table" (Doc ID 3049443.1)

Last updated on SEPTEMBER 24, 2024

Applies to:

Oracle Project Billing - Version 12.2.13 and later
Information in this document applies to any platform.

Symptoms

When attempting to Generate Revenue Accounting Events for the Projects,
the following error occurs.

ORA-01417: a table may be outer joined to at most one other table


The issue can be reproduced at will with the following steps:

1. Navigate to Projects responsibility > View > Requests
2. Run PRC: Generate Revenue Accounting Events
3. Verify the error captured in the log file

Changes

 NA

Cause

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
Symptoms
Changes
Cause
Solution
References


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