As the name suggests fields which are flexible and can be customized as per business requirement are called flexfields A flexfield is a field made…
2 CommentsCategory: ORACLE APPLICATIONS
Basic information on the types of tables that are there in EBS database which every Apps DBA should be aware of. Table-types and names used…
Leave a CommentThere are various components in Oracle Applications setup. Below commands can be used to find the exact version of the components: FIND APPS VERSION (11i/R12)…
1 CommentOracle provides a utility called FNDCPASS that allows you to change passwords in batch mode. It is highly advisable to back up the FND_ORACLE_USERID table…
2 CommentsThe look and feel of the Self Service EBS Application gets distorted with fonts showing garbled/distorted as shown below Below solutions have helped us…
Leave a CommentOracle is tightening up security around Java. Java is one of the most wildly exploited piece of software by viruses and malware bots. Code signing…
2 CommentsWe had implemented SSL on our R12.1.3 instance according to below MOS Note Id: 376700.1 Enabling SSL in Release 12 After starting up application, we…
Leave a CommentWhat is ‘Gather Statistics’?
————————————-
When the data is updated continuously by updating, inserting or deleting of by users (Functional/Technical/End users), it becomes necessary to gather statistics as the performance of database goes down.
Oracle has provided a nice solution for it. This can be done by simply submitting a request from EBS. Oracle E-Business Suite provides concurrent programs that use the package FND_STATS to gather statistics for your applications database objects.
4 CommentsParallel Concurrent Processing (PCP):
PCP is the method by which we configure the Concurrent Manager in a multi tier environment with 2 or more concurrent nodes. This allows concurrent processing load to be distributed across the nodes and provides high availability in case of node failure. Managers migrate to surviving node (failover)when one of the concurrent nodes goes down and migrate back (failback) when the failed node comes back.
8 CommentsPosted by Arindam Mukherjee Recently I encountered an interesting performance issue while working with Oracle EBS seeded components and these issues are tied to wrong use…
Leave a Comment