I've got the following situation:
a user of Oracle Financials (12.1.3) runs an FSG report set; Financial Statement Generator part completes normally, but the Publish and Presentation Program completes with warning.
The user ran the same FSG report set multpile times on the same day, with intervals of between 5 to 30 minutes and some of the request completed successfully, some other not. It seems to be random - I checked parameters used for all 22 reports and did not find any pattern whatsoever.
Of the total number of 22 reports run, 12 completed successfully.
I reviewed the log files of the ones with warning and compare to the ones completed successfully.
The warning always coincides with no value set for two parameters:
"... processing parameters, NVT name MENU_TYPE val END PARAM processing parameters, NVT name MENU_ID val END PARAM ..."
Then the final message reads:
"... Param size? 31 Is In set? falsein set - , NVT name = PUBLISH_SET_ID, val = END PARAMJan 8, 2015 12:37:08 PM oracle.adf.share.config.ADFConfigFactoryfindOrCreateADFConfig INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found Publishing completed successfully with document id: -1 Published doc Id: -1Publishing did not complete successfully, unable to insert data into database ..."
When compared to the log file of the program completed successfully, I found the above lines showing:
"... processing parameters, NVT name MENU_TYPE val Document END PARAM processing parameters, NVT name MENU_ID val 8473 END PARAM ... in set - , NVT name = PUBLISH_SET_ID, val = END PARAM Param size? 31 Is In set? falsein set - , NVT name = PUBLISH_SET_ID, val = END PARAMJan 8, 2015 12:43:43 PM oracle.adf.share.config.ADFConfigFactoryfindOrCreateADFConfig INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found Publishing completed successfully with document id: 8473 Request Id 13888123 submitted to generate FO for the document 8473 Published doc Id: 8473About to create menu with these details: ... " Never experienced this problem before.
There were no patches applied or maintenance programs run that could affect FSG reports as far I know.
I wonder if anyone experienced this issue and would be able to provide me with some hints on how to deal with it?
You are dead-on in your assumption that it follows the lack of value-set in the parameters. I recommend reading MOS Doc ID 1385357.1.
You must set this content set then republish the FSG.
Final answer to this problem:
Content Set was OK.
User used an obsolete template, which resulted in the report completing with warning.
Problem stopped occuring when the right template was used.