SQL Based Auto Accounting Rule Displays PA_AA_WRONG_PARAM|RULE Error While Query Runs Successfully Outside the AutoAccounting. (Doc ID 1676548.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When running the process, the following error is received in the log file.

Current system time is 22-MAY-2014 10:40:29
Firing rule 'Supplier Invoice Cost Intercompany Rule' ...
 
PA_AA_WRONG_PARAM|RULE|Supplier Invoice Cost Intercompany Rule
paccdlb =>: DEBUG: [2]wa->pafvcslid [3009:ALL:N:40]

pavcaa: paccdl() returned false
Unable to create cost distribution lines
pavcei: pavcaa() returned error
pavcei() returned error while processing VENDOR_INVOICES.

When the query in the auto accounting rule is run outside the application, the select is successful. The query is:

Select segment7 from gl_code_combinations_kfv where CODE_COMBINATION_ID=(select DR_CODE_COMBINATION_ID from PA_COST_DISTRIBUTION_LINES_ALL where expenditure_item_id=(select min(expenditure_item_id) from PA_Expenditure_items_all where ORIG_TRANSACTION_REFERENCE=:ORIG_TRANSACTION_REFERENCE)).

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