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 FEBRUARY 04, 2022

Applies to:

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


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.


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
ORA-00907 missing right parenthesis

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




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.