Components comparison between IFS Applications 2004 AND Applications 7

Foundation1 Component	Applications 2004	Applications 7	Sales Part
IFS Base Server(FNDBAS)	3.1.0	4.0.0	Foundation1 Runtime
IFS Extended Server(FNDEXT)	3.0.0		Foundation1 Runtime
IFS Web Client(FNDWEB)	3.6.0	3.7.0	IFS Web Client Runtime
IFS Data Migration (FNDMIG)	1.0.0	1.1.0	IFS Data Migration
IFS Mobile Client Framework(FNDMOB)	1.0.0	1.1.0	IFS Mobile Client Runtime
RegNet(RegNet)	4.2.3
RegTime(RegTim)	2.2.2
Application Services(APPSRV)	3.4.0	3.5.0	Foundation1 Runtime
Application Services Web(APPSRW)	2.2.0	2.3.0	IFS Web Client Runtime
IFS Administration(FNDADM)		1.0.0	Foundation1 Runtime
IFS Development Tools(FNDDEV)		1.0.0	IFS Foundation1 Development
IFS Terms(Terms)		1.0.0	Foundation1 Runtime

Performance Analyzer Set up for IFS devtool.exe

Prerequisites:
1.Required oracle Sqlplus 8.0 or higher.
2.Required oracle files:
Oracle_Home\rdbms\admin\profload.sql
Oracle_Home\rdbms\admin\proftab.sql
3.Required IFS Foundation files:
F1_Home\Utilities\DbagrantProfiler.sql
F1_Home\Utilities\Performance.apy

Step by Step for Installation :
(examples with win2oo3 server in oracle9.27 and IFS2004-Flux)
1.startup by command mode C:\
2.C:\sqlplus /nolog
3.SQL>connect sys/manager@lgprog as sysdba
connected.
4.SQL>@C:\oracle\ora92\rdbms\admin\profload.sql

5.SQL>@C:\oracle\ora92\rdbms\admin\proftab.sql

6.SQL>@D:\IFS2004_SP5\Utilities\DbagrantProfiler.sql

7.6.SQL>@D:\IFS2004_SP5\Utilities\Performance.apy

8.Open Analyze - Overview in folder Performance Analyzer by executing devtool.exe.

The Internal Logic for Refresh of Security cache

Refreshing the security cache after changing the security settings is very important.
Both security windows Security Permissions and Grant Administration
include the possibility to refresh the cache.

The operation of refreshing the security cache consists of the following steps:

1. Remove method restriction entries in table SECURITY_SYS_TAB where no grants
   for the corresponding package are found in USER_TAB_PRIVS_MADE.
   
   
2. Copy package and view grants from USER_TAB_PRIVS_MADE to SECURITY_SYS_PRIVS_TAB.
   
   
3. Synchronize the contents of FND_USER_ROLE_TAB and SYS.DBA_ROLE_PRIVS (upgrade issue).
   
   
4. Update the table SECURITY_SYS_RPRIVS_COPY_TAB according to SYS.DBA_ROLE_PRIVS and FND_USER_ROLE_TAB to be used
   for performance boost of the next step.
   
   
5. Update the expanded role lists in tables FND_USER_ROLE_RUNTIME_TAB
   and SECURITY_SYS_ROLE_PRIVS_TAB
   by using non-expanded role relations in SYS.DBA_ROLE_PRIVS.
   (above is a example of IFS-2001 etc)
   

Shared Pool Administration IN Admin.exe

1.before Shared Pool administration functionality in IFS/Deployment Administrator can be used, Oracle package DBMS_Shared_Pool has to be installed in the database. This is normal done by executing the files: rdbms/admin/dbmspool.sql and prvtpool.plb as user SYS.
2.
The Shared Pool Administrator can be used to pin Oracle packages in the shared pool preventing them from being swapped out by Oracle.
There are two possible reasons for keeping a package permanently in the shared area:

• a package is large, so there is a risk that it won't fit back if it gets swapped out
  
  
• a package is often executed and swapping it out will increase the overhead

To be kept in the database, the package has to be loaded in the shared area.
The administrator window shows all the packages presently loaded,
so there is little point in running it unless the database has been running for a while.
Through the pop-up menu the packages can be sorted according to size or number of executions.
A Kept package will reside permanently in the shared pool until the Oracle restarts.
If the same packages are to be kept in the shared pool even after a restart,
a script that will load and pin those packages can be created from this tool.
This script should be run immediately after a database restart.

3.path:Installation/SQL File Executor
select pool, name,round(bytes/1024/1024) as mb from v$sgastat order by pool,mb desc

pool name mb
java pool free memory 32
shared pool free memory 332
shared pool sql area 6
shared pool miscellaneous 6
shared pool library cache 5
shared pool PL/SQL MPCODE 3
shared pool 1M buffer 2
shared pool PL/SQL DIANA 2
shared pool dictionary cache 2
shared pool KGLS heap 2
shared pool KQR M PO 1
shared pool message pool freequeue 1
shared pool KSXR receive buffers 1
shared pool KSXR pending messages que 1
shared pool event statistics per sess 1

4. init.ora
....
#######################
# Pools
#######################
java_pool_size =33554432
ared_pool_size =367001600

Custom RMB on Quick Report Results with parameters

Here is an example of one parameters
(Testing result is quite good in IFS2004 Flux !)

step by step as below:

1.create a sql expression on quick report as below:

SELECT a.Contract ,a.Part_No,
IFSAPP.INVENTORY_PART_API.GET_DESCRIPTION(a.contract, a.part_no)"PART_DESC",
round(a.Latest_Purchase_Price,4) "Latest_Purchase_Price",
round(a.Average_Purchase_Price,4)"Average_Purchase_Price"
,b.inventory_value "inventory_value"
from IFSAPP.INVENTORY_PART_CONFIG a,IFSAPP.INVENTORY_PART_UNIT_COST b
where a.part_no like '&PART_NO'
and a.contract=b.contract and a.part_no = b.part_no
and (a.Latest_Purchase_Price >0 or a.Average_Purchase_Price >0)
order by a.contract,a.part_no

2.let QUICK_REPORT_ID is 30

(SELECT QUICK_REPORT_ID,DESCRIPTION
from QUICK_REPORT)

3.In Custom Menu:(new)
--Action Type:SAL code
--window:tbwPurchaseOrderLine

--parameter:
InfoService.QuickReportStart(SalNumberToStrX(30,0) II
'@PART_NO=' IItbwPurchaseOrderLine.colPartNo II'^')

4.Testing okay in IFS2004 Flux

To enable PDF Print use teh following steps (provided by gojose)

1. Printserver.ifm. Set $PDF_DIR and changethe value of $PDF_ACTIVE to TRUE.
2. IFS Admin, Configuration.
Set "Print Server archiving setup" to "DEFAULT OFF".
Set "Path to Pdf-Archive directory" to "PDF_DIR".
3. ASPConfig.ifm -$PDF_ARCHIVE_PATH=PDF_DIR
4. Test

All IFS applications supports Command Line Parameters

All applications created with the IFS/Client framework supports a number of optional command line parameters. These parameters may be specified when starting an application.

Command-line parameters can be specified in three different ways:

• Start the application from a command prompt (using the start command) and specify parameters
• Start the application with the run command in the start menu and specify parameters
• Create a shortcut and specify the application with all parameters in the target field.

All parameters have the general form =. If multiple parameters are specified they should be separated with a space character.

Example:
c:\>start D:\IFS2004_SP5_runtime\Admin.exe DATABASE=LGPROD USER=IFSAPP PASSWORD=IFSAPP

Install IFS Mobile Web Client

Install IFS Mobile Web Client
These are the components that must be installed
before installing IFS Mobile Web Client:

1. IFS Base Server
2. IFS Extended Server
3. IFS Web Client

Folder References
In order to get IFS Mobile Web Client working properly
some of it's jsp files need to be edited manually.
The IFS Mobile Web Client *.jsp files are located in the common\mobile folder.
All possible locations for common directory are given below.

1. IFS Web Client template structure:
\fndweb\3.6.0\templates\applications\base\dist\b2e.ear\b2e.war\common
\fndweb\3.6.0\templates\applications\base\dist\b2b.ear\b2b.war\common

2. If you have initialized the IFS Web Client
(a) If a site is defined to use JAP method to communicate to IFS Extended Server:

\fndext\3.0.0\deploy\\dist\.ear\.war\common
\fndext\3.0.0\jboss\server\\deploy\.ear\.war\common

(b) If a site is defined to use RMI method:

\fndext\3.0.0\deploy\\dist\fndext.ear\.war\common
\fndext\3.0.0\jboss\server\\deploy\fndext.ear\.war\common

Manual Installation
1. Adding links to IFS Mobile - Start Menu
Open common\mobile\menu_page.jsp and include Navigator.jsp pages
to it for the links of the installed mobile pages to be visible.

The Navigator.jsp pages should be included
between the IFS header and IFS footer sections as shown in the code segment below.

Example:
// IFS Header include
section
.....
<% /**** Include Invenm Navigator ****/%>
<%@ include file="../../invenm/InvenmNavigator.jsp" %>

<% /**** Include Orderm Navigator ****/%>
<%@ include file="../../orderm/OrdermNavigator.jsp" %>

<% /**** Include Purchm Navigator ****/%>
<%@ include file="../../purchm/PurchmNavigator.jsp" %>

// IFS Footer include section
......
2. Localization fix.
For some languages (e.g. Japanese) to translate correctly the content type directive
which specifies the UTF-8 character set should be added to all Mobile Web Client *.jsp pages. (including that of other mobile web components)

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

Additionally the font types used in all *.jsp files should support double byte as well.
3. Application Server Users.
To be able to use IFS Mobile Client every user has to be added as
an Application User with the role SYSDEV.

4. Restart JBoss server and IIS/Apache.
5. Use a Mobile Device with a Web Browser and browse to the Mobile start page:
http:////mobile.html Login with your Application Server user id and password.

IFS/Business Analytics Overview

An IFS built, Excel add-in

• For reporting, analysis and planning

• l With 100% Excel experience

Access data from any business process within IFS Applications optimized for information workers:

• Fancials, projects, work order, etc

Business users can generate the most accurate, useful spreadsheet reports possible using the tools they already know.

IFS/BI Services (Solution Manager)

• New storage and presentation of the data within IFS Applications
• Meta Data that transforms data into logical information templates
• Administration and configuration
• Data base storing and publishing of report templates

IFS/Info Services

• Online and scheduled report deployment and delivering

IFS/Document Management

• Scheduled reports can automatically be stored in Document Management
  

With IFS/Business Analytics, your data is protected with the same high level of security as IFS Applications – down to row level security

• Accurate and secure data capture and storage – data from Excel is saved in the IFS database
• Secure workspaces
• Proactive monitoring of controls
• The integration and data access is based on .Net, IFS SOA and no usage of SQL which protects the IFS database from vulnerability

The IFS Supply Chain Management

The IFS SCM is based on the assumption that our customers benefit the most from starting with their internal supply chains where most of our customers still have a large potential for improvement. In addition we can then help our customers when they start moving outwards to their external value chains, working with visibility and collaboration, EDI/XML based messaging etc. The only supply chain management solution the customer will ever need IFS Applications software offers a non-stop solution to challenges of bridging the gaps in our customers supply chains. The inter-site functionality and portal technology in IFS Applications enables to improve supply chain and streamline operations regardless of numbers of sites. With IFS Applications it is easy to plan, execute and evaluate supply chain performance. The result is faster return on investments, happier, more loyal and satisfied customers. The IFS approach The IFS/Supply Chain Management approach is based on a process-oriented strategy to optimize supply chain performance. The approach is to provide visualization of supply chains for people making informed and cost efficient decisions. By using the ERP product suit based on the Supply Chain Management concept we can use the power of integration, visualization, collaboration and event notification to support people in the decision making process along the supply chain. Views of solutions IFS addresses the complexity of the Supply Chain by giving the customer three views of solutions. · Supply chain planning: Visibility and collaboration; through portals covering forecasting, demand planning, supply chain event management, and more. (VMI, collaborative planning, program management) · Supply chain execution: Supported through a combination of the portal strategy and site-centric planning and execution functionality. Based on SCOR process definitions. Here we include Source, make, deliver and return processes. (Think always in a multi-site environment). (Internal ordering, e.g. customer and supplier schedules via EDI/XML and more.) · Supply chain performance: Focusing business and supply chain effectiveness, with solutions for business performance, key performance indicators and scorecards. (Based on SCOR process Performance attributes & metrics.)

Oracle9i Considerations

Standard Edition vs. Enterprise Edition

Oracle distributes their software in two alternative releases, Standard Edition (SE) and Enterprise Edition (EE). From Oracle9i release1 both these releases are on the same CD-ROM so when you install Oracle you have to choose either to install Standard Edition or Enterprise Edition. IFS Applications are built to work with Standard Edition but some extra features are available when IFS Applications is used with Enterprise Edition. Remember to install the edition you have chosen to license from Oracle.

Besides the license fee for the different releases the only difference between Standard Edition and Enterprise Edition, from an IFS Applications perspective, is which Oracle software has been installed and that Enterprise Edition offers some more sophisticated features. Oracle Standard Edition includes all the software needed to run the database e.g. RDBMS, SQL*Plus, SQL*Net, administration software etc. There is no performance difference between Standard Edition and Enterprise Edition (unless using some additional EE features), just the amount of products being installed. So installing EE instead of SE will not always gain performance in your instance, in fact performance can decrease since the EE installation is much larger and starts a number unused background processes.

IFS recommends that you install Oracle Standard Edition unless you need to use Enterprise Edition functionality such as Oracle Real Application Cluster, Oracle StandBy Database, Partitioning, OLAP etc.

Due to an unpublished bug 2211325 it is impossible to make a custom Standard Edition installation using the Oracle9i release2 CD.

The only way to make a proper Standard Edition installation of Oracle9i release2 is to make a complete Standard Edition installation and then uninstall all unnecessary products.

All other attempts to make a custom Standard Edition installation will end up in an Enterprise Edition installation and this will cause licensing problems. Therefore it is extremely important to make the installation right from the beginning.

Disable Remember Password in client

Disable Remember Password

To disable "Remember Password",
just disable "Remember Password" check box.

IFS Windows ClientIf system administrator or security officers
wishes to disable "Remember Password" for some reason
(e.g. security policy compliance)
it is possible to manually disable the functionality for all clients and all users.
Removing the IFS file Ifslsa.dll from the runtime folder achieves this.
Warning!
All client executables started this runtime folder
will loose the ability to locally remember password.