How to make Hyperion 11.1.2.3 to run from IE10?

We all have faced quite some issues with the release of new version of extremely secure and fast browser (IE10 from Microsoft) but Oracle Hyperion not being quick enough to accept the same as standard supported browser (IE10 is not supported as a standard browser as per the support matrix released alongwith Oracle Hyperion EPM suite of products v11.1.2.3).

The initial screen as reported when you access the workspace url is a blank webpage. However, some small tweaks enable us to run the Hyperion from IE10. For this tweak to work, you would require direct access to server where the Foundation Services has been installed.
Please take a backup of ‘index.jsp‘ from the folder mentioned below. You can download the modified ‘index.jsp‘ and replace it within the folder. After a restart of Foundation Services, you can check if the issue is resolved. For geeks and other developers, changes in file has been mentioned in the below mail trail
C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\tmp\servers\FoundationServices0\tmp\_WL_user\WORKSPACE_11.1.2.0\340u89\war

• The annoying IE compatibility settings message is displayed when you try to open the Planning Administration page. But you can ignore the same as the page does open properly and we were able to successfully test the entire functionality

————————————————————————————————–
For all the geeks and other developers, who are interested in understanding what are the changes made in the above attached file, please continue below.
Browse to the folder within explorer which might be somewhat as below:
C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\tmp\servers\FoundationServices0\tmp\_WL_user\WORKSPACE_11.1.2.0\340u89\war
Edit ‘index.jsp‘ file. Locate entry which would read out as below:

Replace the text in above line from IE=Edge to IE=9. We found that our client platform supported this entry. However, you are free to replace the above with IE=5, IE=7 or IE=8 depending upon the client platform and compatibility. You can even try IE=5quirks if it suits your environment.
Restart Foundation Services and test if the workspace opens normally within IE10.

PO: Use requisition Line Numbers on the PO

PO: Use Requisition Line Numbers on Autocreated Purchase Order Lines

PO: Default Requisition Grouping. to 'REQUISITION' and while inserting the data into the PO_HEADERS_INTERFACE the GROUP_CODE must be 'REQUISITION'.

PO: Default Requisition Grouping

Indicates the default grouping method used when aggregating requisition demand to create a new document. Values are Default or Requisition.

• Default - combine lines from multiple requisitions to create a single line if possible.
• Requisition - create a separate line for each requisition line.

Create Supplier then Customer to Use Single Party in TCA

In order to create a one party representation of an entity in Oracle's TCA be sure to create the Supplier first! 

Set the profile option ‘AR: Show parties without Accounts in DQM’ to Yes before doing the following

STEP 1 – Log in to Payables application and create a new supplier. This will create a new party record in HZ_PARTIES which is linked to the supplier record in vendors table.

STEP 2 – In receivables query the Supplier name you used when creating the supplier in step 1.

STEP 3 – Select the party and click on the button ‘Create Account’ and continue to create the customer account under the same party.

FNDLOAD: Inventory Category Sets, Categories and Category Set Valid Categories

Load

1. Category Sets (load first)
2. Categories (load second)
3. Category Set Valid Categories

Using FNDLOAD in the usual manner one can download or upload the following Oracle Inventory Category related configurations. Naturally, some experience in using FNDLOAD is a prerequisite. It is not rocket science.

$INV_TOP/12.0.0/patch/115/import/

LCT File	Purpose	Upload Order	Download Params
invicset.lct	Load Category Sets	1	MTL_CATEGORY_SETS CATEGORY_SET_NAME
invcatcg.lct	Load Category Codes	2	MTL_CATEGORY_DTL CATEGORY_SET_NAME
invvlcat.lct	Load Category Set Valid Categories	3	MTL_VALID_CATEGORY CATEGORY_SET_NAME

Mapping Sets Diagrammed

Mapping Sets Diagrammed

• Essentially Mapping Sets are Hash Maps (Key ==> Value)
• Source column values are mapped to Segment Values in Mapping Sets
• Mapping Sets are then placed in Account Derivation Rules(ADR) to map the value in the source column to the corresponding Segment Value is the set

Key==>Value mapping

Target is the account segment:

The value in the TRXN_TYPE column of the transaction is matched to the corresponding value in the Mapping Set(Key==>Value) and the Output value is returned as that segment's value for the transaction line

EBTax: Tax Determining Factors

Tax Determining Factors

• These are set by Oracle and cannot be extended
• Determine:
• Tax Rules
• Tax Regime
• Tax Basis Formula
• Determining Factor Classes:
• Accounting
• Document
• Party Fiscal Classification
• Legal Party Fiscal Classification 
• Product - Inventory Linked
• Product - Non-Inventory Linked
• Registration
• Transaction Input Factor
• Transaction Generic Classification
• 
  

Oracle Receivables (AR) Set the Party Number Next Number

The database sequence that handles the creation of customer numbers is defined in HZ_PARTY_NUMBER_S.

select max(party_number) from ar.hz_parties;

Then using the number returned above, define the sequence to start with a higher value.

If for example the above returns 10001, then you can do the following to ensure the sequence will not create overlapping Party numbers:

DROP SEQUENCE AR.HZ_PARTY_NUMBER_S;10002 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;

Oracle Receivables (AR) Set the Customer Account Automatic Numbering

The database sequence that handles the creation of customer numbers is defined in HZ_ACCOUNT_NUM_S.

select max(account_number) from ar.hz_cust_accounts_all;

Then using the number returned above, define the sequence to start with a higher value.

If for example the above returns 1114, then you can do the following to ensure the sequence will not create overlapping account numbers:

DROP SEQUENCE AR.HZ_ACCOUNT_NUM_S;
CREATE SEQUENCE AR.HZ_ACCOUNT_NUM_S START WITH 1115 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;

Available Sources for Sub-Ledger Accounting (SLA) by Oracle Module 12.1.3

The table below lists the available sources 

in SLA for each modules

Module	SLA Sources
GL	NA
AP	973
AR	2137
CST	1221
PN	63
OZF	134
FV	351
LNS	131
OKL	345

Module	SLA Sources
CE	132
FA	380
PA	421
AGIS	65
PO	510
GMA	582
PAY	54
ONT	NA
SLA	80

OZF=Trade Management; GMA=Process Manufacturing; OKL=Lease & Finance Mgt; ONT=Order Management

Load Categories with Java for Oracle iProcurement

The code below can be used to pull in a text file that contains the Category information and then it writes an XML file that Oracle can pull in to load (or delete categories that are not used) categories in Oracle iProcurement.

import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.util.Date;
import java.util.Scanner;