Skip to main content

anyone meeting below type of error? same Sql, no issue in IFS10 UPD12 but with error in IFS10 UPD19. no issue run the sql within pl/sql developer.

 

Error details:

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-56900: bind variable is not supported inside pivot|unpivot operation

 

ORA-56900: bind variable is not supported inside pivot|unpivot operation

ORA-06512: at line 12

ORA-06512: at "IFSAPP.QUICK_REPORT_API", line 2075

ORA-06512: at "SYS.DBMS_SQL", line 1134

ORA-06512: at "IFSAPP.QUICK_REPORT_API", line 2031

ORA-06512: at "IFSAPP.QUICK_REPORT_API", line 2080

ORA-06512: at line 6

   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)

   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)

   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)

   --- End of inner exception stack trace ---

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)

   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()

   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()

   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)

   at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)

Hi @lion,

The reason for this error is attempting to use bind variables inside pivot/unpivot operation. Try to replace the bind variable with a constant and retry the query.

Hi Ashen, I change below system parameter and issue fix, thanks!

Reporting    Enable bind variables for SQL Quick Reports in IFS EE    NO    SQL Quick Reports bind variables disabled

Hi Ashen, I change below system parameter and issue fix, thanks!

Reporting    Enable bind variables for SQL Quick Reports in IFS EE    NO    SQL Quick Reports bind variables disabled

Thanks for letting us know!

Reply


Terms & ConditionsCookie settings