I m using Oracle Fusion Middleware 11g Reports and in the Formula column query when I m using bind variable with same datatype then it gives an errors with OS window XP.

"no PL/SQL translation for the bindtype given for this bind variable"

Please see blow query.

/*

function CF_1FORMULA0007 return Number is
CR NUMBER(12,2);

begin

SELECT SUM(NVL(GL_TRANS_DETAIL.CREDIT_DC,0))INTO CR

FROM GL_TRANS_HEADER, GL_TRANS_DETAIL,GL_ORGANIZATION,GL_JOURNAL_CATEGORY

WHERE (GL_TRANS_DETAIL.GL_TRANS_HEADER_ID = GL_TRANS_HEADER.GL_TRANS_HEADER_ID)
AND (GL_TRANS_HEADER.GL_ORG_ID = GL_ORGANIZATION.GL_ORG_ID)
AND GL_TRANS_HEADER.REPORTING_DATE BETWEEN :FROMDATE AND :TODATE
AND GL_ORGANIZATION.GL_COMPANY_ID=:COMPANYID
AND GL_TRANS_HEADER.TRANS_TYPE NOT IN ('V','T')
AND GL_TRANS_DETAIL.GL_NATURAL_ACCT_ID=:GL_NATURAL_ACCT_ID
AND GL_TRANS_HEADER.GL_JOURNAL_CATEGORY_ID=GL_JOURNAL_CATEGORY.GL_JOURNAL_CATEGORY_ID
AND GL_JOURNAL_CATEGORY.IS_ZAKAT =:CATEGORYID ;

Please see blow query.
I created manual user parameter with data type varchar2(1) Name Categoryid and when I used in Formula column this gives error.

AND GL_JOURNAL_CATEGORY.IS_ZAKAT =:CATEGORYID ;

Is_Zakat variable also data type varchar2(1)

both variable which I created and compare in a quary have same data type varchar2.

/*

function CF_1FORMULA0007 return Number is
CR NUMBER(12,2);

begin

SELECT SUM(NVL(GL_TRANS_DETAIL.CREDIT_DC,0))INTO CR

FROM GL_TRANS_HEADER, GL_TRANS_DETAIL,GL_ORGANIZATION,GL_JOURNAL_CATEGORY

WHERE (GL_TRANS_DETAIL.GL_TRANS_HEADER_ID = GL_TRANS_HEADER.GL_TRANS_HEADER_ID)
AND (GL_TRANS_HEADER.GL_ORG_ID = GL_ORGANIZATION.GL_ORG_ID)
AND GL_TRANS_HEADER.REPORTING_DATE BETWEEN :FROMDATE AND :TODATE
AND GL_ORGANIZATION.GL_COMPANY_ID=:COMPANYID
AND GL_TRANS_HEADER.TRANS_TYPE NOT IN ('V','T')
AND GL_TRANS_DETAIL.GL_NATURAL_ACCT_ID=:GL_NATURAL_ACCT_ID
AND GL_TRANS_HEADER.GL_JOURNAL_CATEGORY_ID=GL_JOURNAL_CATEGORY.GL_JOURNAL_CATEGORY_ID
AND GL_JOURNAL_CATEGORY.IS_ZAKAT =:CATEGORYID ;

What is the datatype of the bind variables CATEGORYID and COMPANYID?
Also the columns GL_JOURNAL_CATEGORY.IS_ZAKAT and GL_ORGANIZATION.GL_COMPANY_ID?
Crosscheck whether those are matching or not. Correct, if needed.

I Find out the solution of this error.
" no PL/SQL translation for the bindtype given for this bind variable "

when you received this error Just Save your report and close the existing report and then again open this report and compile it after that your report will be run with out errors.( I think this is report Builder 11g bugs. ).