Configure Transaction Types for Oracle General Ledger and Profitability Analytics

 configure Transaction Types for Oracle General Ledger and Profitability Analytics, Release 12, using the configuration file domainValues_Xact_Types_DocTypes_ora12.csv.

To configure Transaction types for Oracle General Ledger and Profitability Analytics:

1. Identify the entry types in the Oracle Inventory application by using the following SQL:

2.   select mtt.transaction_type_id, mtt.description from mtl_transaction_types mtt;

This query gives the transaction type codes in the Oracle Inventory application and their corresponding descriptions.

3. Open the domainValues_Xact_Types_DocTypes_ora12.csv file using a text editor in the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles).

Look for only the rows in the file which has XACT_CODE = 'COGS' or XACT_CODE = 'DEFERRED_COGS'. From among these records, look for those with W_XACT_TYPE_CODE = 'DELIVERY' or 'RETURN'. The column XACT_TYPE_CODE will contain the entry type codes from the Oracle Inventory application, and the column W_XACT_TYPE_CODE is the corresponding domain value to which this entry type code will be mapped to.

4. Map the entry type codes returned by the query above from the Oracle Inventory application to the domain values.

Make sure the entry type codes go into the XACT_TYPE_CODE column in the file. Note that it is not necessarily a one-to-one mapping between the domain values and the entry types. For example, you can have multiple entry types mapped into the DELIVERY/RETURN domain value. Be careful not to map the same entry type to two different domain values.

5. Save and close the file.
6. In Informatica PowerCenter Designer, open the mapping SDE_ORA_GLCOGSFact in the folder SDE_ORAVersion_Adaptor.
7. Open the mapplet mplt_BC_ORA_GLCOGSFact contained inside this mapping
8. Open the Source Qualifier SQ_MTL_TRANSACTION_ACCOUNTS.
9. Modify the SQL so that it extracts the additional transaction type IDs, from step 1, that need to be extracted.
10. In Informatica PowerCenter Workflow Manager, make the same change to the SQL Override in the full load session SDE_ORA_GLCOGSFact_Full.