My Oracle Support Banner

Oracle Fusion Goal Management: Goal Approval Fails With Error JBO-FND:::FND_CMN_INVALID_ATTRB_API_SERV: The value of the attribute Query isn't valid. (Doc ID 2691862.1)

Last updated on JULY 23, 2024

Applies to:

Oracle Fusion Goal Management Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Time and Labor Cloud Service - Version 11.13.21.07.0 to 11.13.21.07.0 [Release 1.0]
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.23.07.0 to 11.13.23.07.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Goal Approval Transaction fail even with Seeded rule conditions

Seeded rules:

PerformanceGoalManualApproval:
=============================

((transactionApprovalRequest.attribute25 == "Y") AND (transactionApprovalRequest.attribute10 != "") AND (Performance Goals != null) AND (Performance Goals.Goal Version Type Code == "PENDING_APPROVAL") AND (Performance Goals.Private Flag != "Y") AND ((Performance Goals.Goal Created Flag == "Y") OR ((Performance Goals.Goal Deleted Flag == "Y") OR ((Performance Goals.Legacy Key Attribute Updated == "Y") OR ((Performance Goals.Status Code == "CANCEL") OR (Performance Goals.Status Code == "COMPLETED"))))))

PerformanceGoalAutoApproval:
===========================
((transactionApprovalRequest.attribute25 == "Y") AND (transactionApprovalRequest.attribute10 != "") AND (Performance Goals != null) AND (Performance Goals.Goal Version Type Code == "PENDING_APPROVAL") AND (((Performance Goals.Goal Created Flag != "Y") AND (Performance Goals.Goal Deleted Flag != "Y") AND (Performance Goals.Status Code != "CANCEL") AND (Performance Goals.Legacy Key Attribute Updated != "Y") AND (Performance Goals.Status Code != "COMPLETED")) OR (Performance Goals.Private Flag == "Y")))

PerformanceGoalBlankTxnApproval:
==============================
((transactionApprovalRequest.attribute25 == "Y") AND (transactionApprovalRequest.attribute10 == ""))


ERROR
-----------------------
Client received SOAP Fault from server : JBO-FND:::FND_CMN_INVALID_ATTRB_API_SERV: The value of the attribute Query isn't valid.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a goal and send to approval
2. Transaction failed

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


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