Self-service Assignment Costing Function Gives Unexpected Error (Doc ID 2009671.1)

Last updated on APRIL 03, 2017

Applies to:

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

Symptoms

Cost Allocation Key Flexfield (KFF) is setup and mapped separately at business group level and all segments of Cost allocation KFF are qualified at "Assignment" level. 

By logging in using seeded Manager Self-Service responsibility, user tried to enter Assignment costing information. Upon clicking "Search" button" or "Create" button, they are receiving an unexpected error.

ERROR
-----------------------
Unexpected error
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT /*
$Header: KeyFlexfield.java 120.8.12010000.9 2014/03/14 14:44:36 svedi ship $
*/
PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID FLEX_CCID

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)


STEPS TO REPRODUCE THE ISSUE :
-----------------------
1. Cost Allocation Key Flexfield setup
2. All segments are qualified at assignment level.
3. Profile option to use workflow for assignment costing is set to Yes
4. Using seeded responsibility Manager Self-service, go to Assignment Costing
5. Search Employee name
6. Click on Action
7. Accept system date as effective date and click Continue
8. No previous costing records are present.
9. Click add another row
10. Enter Proportion as any value
11. Click on Search button
12. Enter Costing KFF values
13. Click Search –Error comes up


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