My Oracle Support Banner

Funds Accrual Engine Error"ORA-00932: Inconsistent Datatypes: Expected - Got APPS_NE.ASO_LINE_VAR_TYPE" (Doc ID 2957509.1)

Last updated on JUNE 27, 2023

Applies to:

Oracle Trade Management - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

FAE Error-ORA-00932: inconsistent datatypes: expected - got APPS_NE.ASO_LINE_VAR_TYPE

In the process of setting up the 12.2.11 instance and ran the Funds Accrual Engine for the first time . It is not processing any data. Log file is showing the below errors.


ERROR:

Queue Return Error
(1) ORA-00932: inconsistent datatypes: expected - got APPS_NE.ASO_LINE_VAR_TYPE in Package ASO_ORDER_FEEDBACK_GET_PVT Procedure GET_NOTICE
(2) Program Error: An error has occurred while retrieving order feedback information from Oracle Order Capture.

STEPS:
The issue can be reproduced at will with the following steps:
1. (R) Oracle Trade Management Administrator-->Run 'Funds Accrual Engine' concurrent program.


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