AutoAccounting Rule in Project Fails When Sql Statement is Used But Succeeds With A Constant (Doc ID 580529.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Project Costing - Version 11.5.1 to 12.0.6 [Release 11.5 to 12.0]
Information in this document applies to any platform.
FORM:PAXAAASR.FMB - Assign Rules

***Checked for relevance on 15-Sep-2013***



Symptoms

The AutoAccounting Rule fails if a SQL statement is used to derive the segment values and completes with error:


"AA-paxsql paccdlb =>: ORACLE error occurred while filling in Burden Costs and Rates"

Steps:

1. Created SQL AA rules and tested in TOAD. They worked as expected.
2. Assign these rules in PA.
3. Enter project and labor transactions as pre-approved batch.
4. Run Distribute Labor Coat process. Completes with error in log as noted.
5. Change AA rules to constants.
6. Rerun the PRC: Distribute Labor Costs and ensure the error is no longer encountered.

 

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