OAF download problem from MessageDownload solved
Posted by pacesettergraam
I had a problem in the below Query on using Bind variable where I was not able to download the attachment.
Above is the screenshot of my page where open/view file is the Message Download Item. After I used FND_GLOBAL.USER_ID instead of using Bind Variable in VO(View Object) my problem got resolved.
Below is the screenshot what I got as problem by using the bind variable.
Just have a look at below Query. I had a Message Download item by which I download a file and the below Query contains a Bind variable by which i was not able to download the file . After I changed the bind variable in VO I was able to download it.
check_switcher (DOC_ID, :1)
where SYSDATE between EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, trunc(sysdate)+1)
ORDER BY Document_number, VERSION_NUMBER
The Query given below is the place where I use the Bind variable for the function as input.
CREATE OR REPLACE FUNCTION CHECK_SWITCHER(DOC_ID_F IN NUMBER, USER_ID_F IN
CURSOR C1 IS SELECT DISTINCT DOC_ID, USER_ID FROM MOISS_DOC_LIBRARY_USER;
FOR I IN C1
IF (I.DOC_ID = DOC_ID_F AND I.USER_ID = USER_ID_F)
RETURN_VAR := ‘CheckDisable’;
RETURN_VAR := ‘CheckEnable’;
My New Modified Query which solved the problem. This was said by my senior Raghunathan. Here there is no bind variable in the Query and fucntionality is done by FND_GLOBAL.USER_ID.
CHECK_SWITCHER (DOC_ID, FND_GLOBAL.USER_ID) CHECK_SWITCHER,
WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,
About pacesettergraamA good and realistic person
Posted on December 18, 2013, in OAF, Oracle and tagged Bind variable problem, Message Download problem, OAF page Message Download, oracle.jbo.InvalidObjNameException, oracle.jbo.InvalidObjNameException: JBO-25005. Bookmark the permalink. Leave a comment.