Skip to Content
avatar image
Former Member

SQL Query

Hi All,

When I tried to add a GROUP BY token as follows:

GROUP BY T1.UNIQUE_DOC_NAME

where T1 is FCI_PRO_PROJECTS table & UNIQUE_DOC_NAME is project name.

I am getting an error saying:

SQL Exception: ORA-00933: SQL command not properly ended , ANSI-92 SQL State: 42000, Vendor Error Code: 933. ORA-00933: SQL command not properly ended

Can anyone provide me what actually is my mistake in using the GROUP BY token. When I remove the GROUP BY token the query works fine. But we are getting repeated entries for the same PROJECT ID.

Can anyone send me exact QUERY GUIDENCE for SAP SOURCING system. As I am new to this I am facing many problems.

Thanks & Regards,

Harish Sudhakar Pai

Email: harish.sudhakar.pai@accenture.com

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 04, 2013 at 10:31 AM

    Also can anyone provide me the description of FCI_GET_COMMA_LIST is usage.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2013 at 03:02 PM

    In addition to the above mentioned I found that while using the GROUP BY token for other test query the same worked fine but for the query which business is asking for where we have lots of joins & filters I am facing this issue. Please help me out in this.

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded