Thursday, February 28, 2013

ORA-20100: Error: FND_FILE failure. Unable to create file

Issue : ORA-20100: Error: FND_FILE failure. Unable to create file 
        when run any request which are in large .


Solution : check the paremeter  UTL_FILE_DIR and delete the old tmp files 

Monday, February 11, 2013

File -> Export, it flashes and then goes away, with nothing being exported

Issue : File -> Export, it flashes and then goes away, with nothing being exported in oracle EBS


Solution:
         Need to check the Alert log for any ORA-1653  temporary tablespaces, and allocate more space.
        found : ORA-1653: unable to extend table CTXSYS.DR$WAITING by 1598 in  tablespace CTXD

       so  increased the tablespace CTXD .



Ref:Information You Should Upload When Creating an SR for File Export and Attachments [ID 427964.1]