How to verify data loaded by ERP Integrator into table

You can execute Data Load Rule by clicking on Execute button.
It will display the process ID.

Go to Process Details.

If you click on Show you can see the record count in the log.
Go to SQL Plus and run following query.

SELECT * FROM ERPI.TDATASEG

ERPI is my ERPI Schema name. If you have different name use that.
You can see the data into the table.

TDATASEG.LOADID is your process ID.
VALID_FLAG = Y indicates data is valid.

Check EPM 11.1.2.2 AIF Web Services

If you want to see what all web services are running on your Application Server type following URL.
http://<server>:<port>/aif/services

It will display web services.

And now... Some Services

• RuleService (wsdl)
  • executeMetadataRule
  • executeDataRule
  • getDataRuleNames
  • getLocationNames
  • getPeriodNames
• EPMAService (wsdl)
  • exportMetadataToEPMA
  • exportDataToEPMA
• FDMRuleService (wsdl)
  • executeRule
• EssbaseService (wsdl)
  • loadMetadata
  • loadData
• AdminService (wsdl)
  • AdminService
• HPLService (wsdl)
  • importWritebackData
  • executeDataLoad
• FusionGLService (wsdl)
  • loadWritebackData
• DrillService (wsdl)
  • getDrillURL
• Version (wsdl)
  • getVersion
• HFMService (wsdl)
• createDrillRegions 

If you click on any wsdl URL and if you see following than that is normal.

AXIS error

Sorry, something seems to have gone wrong... here are the details:

Fault - java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl; nested exception is:

        java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl

AxisFault

 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException

 faultSubcode:

 faultString: java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl; nested exception is:

        java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl

 faultActor:

 faultNode:

 faultDetail:

        {http://xml.apache.org/axis/}hostname:<your_host_server_name>

Set Field Foreground Color Using Visual Attribute

We had a requirement that based on some conditions we wanted to display Item number in red color as shown below.

We could use oracle provided custom visual attribute and set item instance property to change foreground color as given below.

SET_VA_PROPERTY('CUSTOM5',FOREGROUND_COLOR,'r255g0b0');                          SET_ITEM_INSTANCE_PROPERTY('QUANTITY_FOLDER.ITEM',CURRENT_RECORD,VISUAL_ATTRIBUTE,'CUSTOM5');

Problem we noticed that it takes more time to set the color than to fetch data from database.

To improve the performance instead of using seeded Custom 5 visual attribute  we added new custom visual attribute X_RED_FG. In properties set foreground color to Red. 

Used new custom visual attribute X_RED_FG in set item instance property. This improved performance significantly. We did not used SET_VA_PROPERTY command.

SET_ITEM_INSTANCE_PROPERTY ('QUANTITY_FOLDER.ITEM',CURRENT_RECORD,VISUAL_ATTRIBUTE,'X_RED_FG');

EPM 11.1.2.2 Help is not working

We installed EPM 11.1.2.2.When we click on help we got following error.
Server Error in Application "DEFAULT WEB SITE/EPMSTATIC"Error SummaryHTTP Error 404.0 - Not FoundThe resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

Solution:If you are using IIS as your web server so you need to install the help files locally.

See page 120 "Installing and Configuring Online Help" at this link: http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf