My Oracle Support Banner

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

Last updated on OCTOBER 11, 2021

Applies to:

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


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.

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

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

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(




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


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

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