Search 800 + Posts

Nov 16, 2013

ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")

ORA-01400: cannot insert NULL into .....

Recently while working on XML/BI Publisher reports I encountered following error message
+------------- 1) PUBLISH -------------+
Beginning post-processing of request 39091331 on node VISION at 15-NOV-2013 02:13:12.
Post-processing of request 39091331 failed at 15-NOV-2013 02:13:13 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

from the description of error message , it was not clear what went wrong.But during the analysis of the Post processor Log file , i saw the error message 
ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")
for my concurrent request 

Reason - System will raise this error while processing the BI Publisher report if value for profile option 
FND: Default Template Output Type has not been entered.

Solution - 

  1. Logon to System Administrator responsibility
  2. Navigation: Profile > System
  3. Set the profile option , this Profile  can be set at Site, Application, Responsibility and User level
  4. Select the value from the LOV based on your business need and set at the level as per your business requirements.
Once profile option set , Run the Concurrent program again , and it should work as per expectations.

1 comment:

  1. Thank you for your valuable input... It helped me for my reports finishing in Warning...