This blog contains experience gained over the years of implementing (and de-implementing) large scale IT applications/software.

Category: Oracle EBS

Oracle Doc: EBS R12 Upgrade/Patch Forms and Reports

There’s a nice Oracle doc on how to upgrade the Oracle AS 10g Forms & Reports component of an Oracle EBS R12 instance:
Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 [ID 437878.1]
Once you’ve read it, you’ll realise what a mammoth task it is.
It’s interesting that out-of-the-box, the Forms & Reports upgrades don’t work with EBS, you need the interoperability patches to be installed ontop.

APP-FND-01630 DBC File Oracle EBS R12

If you receive error APP-FND-01630 “Cannot open file xxxx” in a popup window whilst working on an Oracle R12 E-Business Suite instance:

If you get the the administrator to add read permissions for everyone, for the DBC file under $FND_SECURE.
As the applmgr user, change to the $FND_SECURE directory and add permissions to the dbc file:

chmod g+r,o+r <file>.dbc

No restart of EBS is required.
This should fix the issue.