We have created a custom package where in we are trying to call the standard API's of Oracle projects i.e PA_PROJECT_PUB.When we are trying to call these APIs we are facing the below issue.
We have tried testing in two instances ,Initially it worked in both instances.
Using the same API's multiple times we tested the same data set in these instances.
For the first few runs it works fine.But when we go on using the same API's again and again for our testing we face now and then the below issue.
ORA-20100: File o2670336.tmp creation for FND_FILE failed.You will find more information on the cause of the error in request log. in Package PA_OPPORTUNITY_MGT_PVT Procedure modify_project_attributes ORA-20100: File o2670336.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log. in Package PA_PROJECT_PUB Procedure update_project:ORA-0000: normal, successful completionError while publishing the task
Please let us know if anyone of has come across the same situation.