My Oracle Support Banner

Asset Posting Using ADFDI Asset Spreadsheet Fails With Error ORA-00907 Missing Right Parenthesis (Doc ID 2669843.1)

Last updated on JUNE 08, 2020

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

Posting from ADFDI: Asset spreadsheet upload fails with error ORA-00907 missing right parenthesis

User trying to post eligible records using ADFDI spreadsheet and running into upload error.

Steps:

1) Clicked on records for posting in Additions Infotile and then click Prepare All button.

2) It downloaded the ADFDI Spreadsheet, where queue name as changed to Post and the clicked on Post button. The upload process failed with below error:

An application error occurred. See the incident log for more information. Your help desk can use the following information to obtain a more detailed description of this incident Server Domain FADomain Server Instance


oracle.jbo.SQLStmtException JBO-27122: SQL error during statement preparation. Statement: SELECT DesktopAddInterfaceEO.BOOK_TYPE_CODE, DesktopAddInterfaceEO.ASSET_TYPE, DesktopAddInterfaceEO.QUEUE_NAME, DesktopAddInterfaceEO.DESCRIPTION, DesktopAddInterfaceEO.ASSET_NUMBER, DesktopAddInterfaceEO.CATEGORY_SEGMENT1, DesktopAddInterfaceEO.CATEGORY_SEGMENT2, DesktopAddInterfaceEO.CATEGORY_SEGMENT3, DesktopAddInterfaceEO.CATEGORY_SEGMENT4, DesktopAddInterfaceEO.CATEGORY_SEGMENT5, DesktopAddInterfaceEO.CATEGORY_SEGMENT6, DesktopAddInterfaceEO.CATEGORY_SEGMENT7, DesktopAddInterfaceEO.FIXED_ASSETS_COST, DesktopAddInterfaceEO.CLEARING_ACCT_SEGMENT1, DesktopAddInterfaceEO.CLEARING_ACCT_SEGMENT2, DesktopAddInterfaceEO.CLEARING_ACCT_SEGMENT3, DesktopAddInterfaceEO.CLEARING_ACCT_SEGMENT4, DesktopAddInterfaceEO.CLEARING_ACCT_SEGMENT5, DesktopAddInterfaceEO.CLEARING_ACCT_SEGMENT6%2
java.sql.SQLSyntaxErrorException">
ORA-00907 missing right parenthesis


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot user ADFDI to post Assets

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
References


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