You should always be going through APIs for the Oracle ERP modules. There are specfic APIs for the types of different modules and things you need to manipulate. ERP Application Dev should know this. You can seriously muck up the dependencies especially in Financial and HR modules if you don't use the APIs. You should not be using Toad except to modify data, I think we only used to is correct some Flex Field data. If you are not sure what APIs to use you probably can either google or open an SR to clarify. Oracle Support won't help you much if/when they find out you update data not using the APIs. --- On Sun, 5/16/10, Mostafa Eletriby <m_etrib@xxxxxxxxx> wrote: From: Mostafa Eletriby <m_etrib@xxxxxxxxx> Subject: Reg. APIs at updating standard EBS tables To: "Oracle DBAs Group" <ora-apps-dba@xxxxxxxxxxxxx> Date: Sunday, May 16, 2010, 2:01 AM Hello DBAs, Please I need to know what is API ? & how should we update Standard Tables at Oracle EBS (11.5.10.2) by such APIs while using TOAD ? & if this is mandatory to use them for updating standard Tables - as I knew that EBS will be desupported by Oracle if standard tables updated directly by TOAD. Also I see that most of Apps developers use TOAD with Apps & oracle documentations assure that it is NOT recommended to use third parties like TOAD to access & update Oracle EBS tables- but this is always done !! .... So I have little conflicts about such used actions at most of customers. Please can you clarify for me & give me your recommendations? Thanks a lot. Thanks and Best Regards Mostafa Eletriby