Oracle eBS經驗分享

<Error log>

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

MSG-00100: done with get_predicate ps
MSG-00101: done with get_predicate aite
MSG-00101: done with get_predicate addr
MSG-00101: done with get_reporting_entity_name
MSG-00101: done with get_reporting_level_name
MSG-00102:  p_org_where_ps     AND NVL(ps.ORG_ID,  :p_reporting_entity_id ) =  :p_reporting_entity_id  
MSG-00102:  p_org_where_site   AND NVL(site.ORG_ID,  :p_reporting_entity_id ) =  :p_reporting_entity_id  
MSG-00102:  p_org_where_addr   AND NVL(acct_site.ORG_ID,  :p_reporting_entity_id ) =  :p_reporting_entity_id  
ORA-00979: not a GROUP BY expression
  ==> SELECT ps . invoice_currency_code Currency_Main , nvl ( status . meaning , '' ) Account_Status , decode ( upper ( : p_order_by ) , 'CUSTOMER' , substrb ( party . party_name , 1 , 50 ) , NULL ) Dummy_Cust , decode ( upper ( : p_order_by ) , 'CUSTOMER

Report Builder: Release 6.0.8.27.0 - Production on Thu Mar 31 02:13:20 2011

======================================

Oracle support feedback:

That because our database version is 11.1.0.x.

There is a bug in this report.

We need change the database value “_replace_virtual_columns” = False

<response from oracle support>

On your 11.1.0.7 database server , try setting _replace_virtual_columns = FALSE