oracle-apps

Why doesn't Oracle have foreign keys in Oracle Apps/ E-Business Suite?

Why doesn't Oracle have foreign keys in Oracle Apps/ E-Business Suite? I observed that Oracle doesn't have/use referential constraints on the Oracle Apps 11i Schema. All the logic is contained in PL/SQL packages. This seems odd coming from a RDBMS major. ...

Oracle: error while trying to use formulas

I created an element with an input value of type "Day" , when i write a formula i get this error. Any idea what's wrong? APP-FF-33232: EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE has null or not found allowed, but no default set specified. Cause: If a Database Item has null allowed, or not found allowed, the...

Percent Complete functionality in Oracle Apps Project module

hi to all I am talking about Oracle Apps Projects module. In Projects module there is a Project Status Inquiry which includes Percent Complete functionality. I want information regarding this functionality. Is it updated automatically? Does it require us to run any pre-requisites? Please give me information about what this f...

How can I communicate with Oracle Financials api from .Net?

Oracle ERP exposes a set of API but does anyone know how to communicae with it? Is there any third party tools that could help? Please note I am not interested in Oracle database but Oracle ERP Financials. Thanks ...