My Oracle Support Banner

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 DECEMBER 04, 2019

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.


Firing rule 'Supplier Invoice Cost Intercompany Rule' ...
 
PA_AA_WRONG_PARAM|RULE|Supplier Invoice Cost Intercompany Rule
paccdlb =>: DEBUG: [2]wa->pafvcslid

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)).

Changes

 

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


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