Year end process in Oracle

Hi,

During year end system checks all the P&L account strings and for all such strings which have a transaction ,system generates retained earning accounting string.

may times if such these retained earnings accounting string is not enabled ,or any of the segments of such accounting string is not valid ,or some CVR stops it from being geneated or it voilates some security rule .

In all such instances the open year program errors out  and we have to maually make correction and resubmitt the program.

if we want to avoid this route and before opening new year we want to  run a report which will list all such possible scenerios and also enable them on the fly,what should be the approach and what is the best practice for this problem.??