To see the detailed message of the error code given by api.

SELECT message_text
   FROM fnd_new_messages
  WHERE message_name = 'AP_DISTS_NO_OPEN_FUT_PERIOD'
    AND language_code = 'US';

Interfaces

Purchase Order interface

http://www.youritbox.com/index.php?option=com_content&view=article&id=202:po-interfaces&catid=121:interfaces&Itemid=439

Item Interface

http://www.youritbox.com/index.php?option=com_content&view=article&id=203:inv-interfaces&catid=121:interfaces&Itemid=439

OM Interfaces

http://www.youritbox.com/index.php?option=com_content&view=article&id=204:om-interfaces&catid=121:interfaces&Itemid=439

Script for Forms Personalization

The below script list all the forms in Oracle Applications that have been customized using Forms Personlization:

select distinct a.form_name , a.enabled, c.USER_FORM_NAME, d.APPLICATION_NAME from FND_FORM_CUSTOM_RULES a, FND_FORM b, FND_FORM_TL c, fnd_application_tl d where enabled = 'Y' and a.form_name = b.form_name and b.form_id = c.form_id and b.application_id = d.application_id order by application_name