Process Exchange Derivatives Portfolio Product Definition

This topic describes the systematic instruction to process Exchange Derivatives Portfolio Product Definition screen.

You can capture information pertaining to a portfolio product through the Exchange Derivatives Portfolio Product Definition screen.

1. On the Home page, enter EDDPFPRD in the text box, and then click next arrow.

   The Exchange Derivatives Portfolio Product Definition screen is displayed.

   Figure 5-1 Exchange Derivatives Portfolio Product Definition

   
   Description of "Figure 5-1 Exchange Derivatives Portfolio Product Definition"
2. On the Instrument Definition screen, click New.
3. On Instrument Definition screen, specify the following Instrument Details, and then click Enter Query.

   For more information on the fields, refer to the below Field Description table.

   Table 5-1 Instrument Definition - Field Description

   Field	Description
   Product Code and Product Description	You can identify a product that you maintain with a unique Product Code, and a brief description. In the Product Code field, you must assign the product a unique code (which is unique across all the modules of Oracle Banking Treasury Management). This code helps in identifying the product. You can briefly describe a product that you create in the Description field.
   Product Module	The services that you offer in a module will be specific to the module. For example, a portfolio maintenance scheme is specific to the ETD (Portfolio) module. To view the module in which you are creating a product in the Product Module field.
   Product Type	The first attribute that you define for a portfolio product is its type. You can broadly classify portfolio products into two types: Customer Portfolio (C) – the definition and maintenance of customer portfolio products help you manage your customer’s trades and investments. Own Portfolio (O) – the definition and maintenance of Own portfolio products help you manage your banks own trades and investments. Under each type you can create multiple portfolio products.
   Product Slogan	Type a slogan for the product that you are creating. In the Slogan field enter a slogan that suitably announces the product to your customers. If you are creating your own portfolio, you can identify it with an appropriate slogan for your bank’s internal reference purposes.
   Product Group	Grouping products according to the common features they share, helps you organize information relating to the services you provide. This helps you retrieve information easily. You can invoke a list of all the product groups that you have maintained in your bank. Choose the product group to which the product you are creating belongs.
   Product Start Date and End Date	When you create a product, you must also specify a date from which it can be offered. You may also specify the date up to which you would like to offer the product. Enter these dates in the Start Date and End Date fields. Note: You cannot offer a product beyond the specified end date. If you do not specify an end date for a product, you can offer it for an indefinite period.
   Remarks	If you want to enter any remarks regarding the product, do so in the Remarks field.

4. On the Exchange Derivatives Portfolio Product Definition screen, specify the other Details for the Portfolio Product

   Every product that you maintain in Oracle Banking Treasury Management, will impact specific accounting heads (GLs). When you build a Class of Accounting Roles and Heads, you will have to identify all heads specific to a service and indicate their roles, individually.

   The different stages in the life cycle of a portfolio are referred to as events. After identifying accounting roles and mapping them with account heads, you will have to identify the accounting entries, which ought to be posted when individual events are triggered in Oracle Banking Treasury Management. For instance, the opening of long and short positions will be recorded as two separate events in Oracle Banking Treasury Management.

   The mapping of accounting roles to respective account heads and the identification of life-cycle events at which they ought to be triggered automates the process of posting accounting entries.

   A single portfolio product can have multiple portfolios within it. Although, the various events that are likely to occur in a portfolio can be defined under a single product, you can choose to post accounting entries to specific GLs for the different portfolios and Instruments within a portfolio product.

   Assume this scenario: Your bank is trading in a variety of Currency, Index Options and in Commodity, Index and Interest Rate Futures.

   Typically on a daily basis you would like to process the following activities or events for all types of Options and Futures:

   • Open Long / Short Positions
   • Revalue Long/Short Positions
   • Close Long /Short positions
   • Process expiry of Long/Short positions
   • Exercise Long positions
   • Assign Short positions
   • Exchange for physicals in Long / Short positions

   When each of these events is triggered in Oracle Banking Treasury Management, appropriate accounting entries need to be posted to a variety of GLs.

   Besides, you would also like to perform notional revaluation for the open positions on a daily basis.

   To cater to these diverse requirements you would need to set-up portfolio products, wherein for each product you have to:

   • Identify the GL types and GLs that would be impacted
   • Define life-cycle events
   • Create role to head mappings

   In addition to identifying the accounting entries, you would also need to identify the MIS Heads under which you would like to report the portfolio

   To eliminate the process of defining multiple portfolio products, and to restrict portfolios within a product from holding specific instrument products, you need to follow a preferential hierarchy while defining accounting roles and account heads. The order in which you would need to define Role to Head mappings is as follows:

   • A portfolio and the Instrument involved in the portfolio.
   • A portfolio and the Instrument Product involved in the portfolio.
   • A specific portfolio.
   • A portfolio product as a whole.

   By defining role to head mappings at the four hierarchical levels you can maintain a single, comprehensive portfolio product, which can be used to process all possible events for options as well as futures for all portfolios.

   Let us assume that your bank has maintained a portfolio product titled BKPF. Since a product can have multiple portfolios, you have maintained several portfolios within BKPF. Each of these portfolios will cater to specific instrument types.

   Figure 5-2 Portfolio Product – Portfolio Relationship Diagram

   

   The portfolio PF1 is meant for deals involving Currency and Index Options

   As per the preferential hierarchy method, the role to head mappings specified for this product is as follows:

   Table 5-2 Preference I - Portfolio ID + Instrument ID

   Portfolio ID	Instrument ID	Accounting Class
   PF1	DEM_OPTION_LIFFE	ACR01

   Table 5-3 Preference II – Portfolio ID + Instrument Product

   Portfolio ID	Instrument ID	Accounting Class
   PF1	CCYO	ACR02

   Table 5-4 Preference III – Portfolio ID

   Portfolio ID	Accounting Class
   PF1	ACR03

   Table 5-5 Preference IV – Portfolio Product

   Portfolio Product	Accounting Class
   BKPF	ACR04

   Table 5-6 AR01

   Accounting Role	Account Head
   BOT_ASSET	CA001
   SOLD_CCY_EQ	CL001

   Table 5-7 AR02

   Accounting Role	Account Head
   BOT_ASSET	CA002
   SOLD_CCY_EQ	CL002

   Table 5-8 AR03

   Accounting Role	Account Head
   BOT_ASSET	CA003
   SOLD_CCY_EQ	CL003

   Table 5-9 AR04

   Accounting Role	Account Head
   BOT_ASSET	CA004
   SOLD_CCY_EQ	CL004

   Scenario I

   You want to Open a Long Position (EOLG), in the Currency Option – USD_Options_CME in PF1

   Table 5-10 Accounting Entries

   Accounting Role	Description	Dr./Cr. Indicator
   Contingent Asset	Asset Value	Debit
   Contingent Asset	Asset Value	Credit

   When this event is triggered, the system posts the relevant accounting entries only after identifying the respective Role to Head mapping based on the preferential hierarchy that we have set up.

   Since we have not associated an accounting class with the PF1+ USD_Options_CME (Portfolio ID+ Instrument ID) combination, it will move to the next level and search for the class associated with the PF1 + CCYO (Portfolio ID + Instrument Product) combination.

   We have already associated the accounting class ACR02 with this combination; therefore the relevant accounting entries are posted to GLs maintained within this class:

   Table 5-11 AR04

   Accounting Role	Account Head
   BOT_ASSET	CA004
   SOLD_CCY_EQ	CL004

   Scenario II

   Similarly, assume you want to Open a Long Position in the Index Option – DAX_OPTION_FSE in PFI. As in the previous case, the Contingent Asset is to be debited and the Offset account is to be credited.

   Since the system has to pick up the relevant accounting entries based on the hierarchical preference, it will search for the accounting class associated with the:

   • PF1 + DAX_OPTION_FSE (Portfolio ID + Instrument ID) combination.
   • PF1+INDO (Portfolio ID + Instrument Product) combination.
   • PF1 (Portfolio ID)

   Table 5-12 Accounting Entries

   Accounting Role	Description	Account Head	Dr./Cr. Indicator
   BOT_ASSET	Option Strike Price	CA003	Debit
   SOLD_CCY_EQ	Option Strike Price	CA003	Credit

   Note:

   Therefore, to open a long position for both Index and Currency options within the portfolio PF1, the accounting treatment remains the same. However, the Account Heads (GLs) that are impacted (debited/credited) while posting the entries differ.

   For the Currency Option, in P F1 the account heads that are impacted are:

   • CA002 (Contingent Asset)
   • CL002 (Contingent Asset Offset)

   For the Index Option, in PF1 the account heads that are impacted are:

   • CA003 (Contingent Asset)
   • CL003 (Contingent Asset Offset)

   Scenario III

   Assume, you have not maintained the first three hierarchical preferences. When the search results prove unsuccessful, the accounting entries will be posted directly to the default GLs maintained at the portfolio product level.

   Table 5-13 Accounting Entries

   Accounting Role	Description	Account Head	Dr./Cr. Indicator
   BOT_ASSET	Option Strike Price	CA004	Debit
   SOLD_CCY_EQ	Option Strike Price	CA004	Credit

5. On the Exchange Derivatives Portfolio Product Definition screen, click the Accounting Roles tab.

   The Accounting Role screen is displayed.

   You can map appropriate Accounting Roles to Account Heads for the portfolio product through the Role to Head mapping screen.

   For a detailed procedure on how to map Accounting Roles to Account Heads, refer to the Common Procedures User Manual of Oracle Banking Treasury Management.

   Note:

   The Role to Head mapping definition for the following hierarchical levels:

   • Portfolio + Instrument ID
   • Portfolio + Instrument Product
   • Portfolio ID
6. On Exchange Derivatives Portfolio Product Definition screen, click the Events tab.

   The Events Details screen is displayed.

   After mapping accounting roles to specific heads you have to define life-cycle events for deals involving this product and identify the accounting entries which ought to be posted when individual events are triggered in Oracle Banking Treasury Management.

   For a detailed procedure on how to map Accounting Roles to Account Heads, refer to the Common Procedures User Manual of Oracle Banking Treasury Management.

   The following is the list of events for a portfolio, which you can maintain in Oracle Banking Treasury Management:

   • Assignment of Exercise
   • Closing of Long /Short positions
   • Exchange of physicals - Take /Make delivery
   • Opening of Long /Short positions
   • Revaluation of Long / Short positions
   • Expiry of Long / Short options
   • Exercise of Options
   • Reversal – Assignment of Exercise
   • Reversal – Closing of Long / Short position
   • Reversal Exchange of Physicals – Take /Make delivery
   • Reversal – Opening of Long / Short positions
   • Reversal – Reversal of Long position
   • Reversal – Reval of Short positions
   • Reversal – Expiry of Long / Short positions
   • Reversal Exercise of Options

   You have to identify the life-cycle events which need to be associated with the portfolio product you are setting up.

   When each of these events is triggered in Oracle Banking Treasury Management, appropriate accounting entries need to be posted. For instance, while ‘Opening a Long Position’ you will:

   • Debit the Contingent Asset
   • Credit the Contingent Asset Offset

   Therefore you need to associate every event with appropriate accounting entries. You can define the accounting entries that have to be passed for a set of events, as an ‘Event Accounting Entries and Advices Class’. You can associate event-wise accounting entries through The Event Accounting Entry and Advice definition of the Product Definition screen. To do this, click ‘Events’ button from the Portfolio Product screen.

   Note:

   Refer to the Common Procedures User Manual of Oracle Banking Treasury Management for a detailed procedure on how to associate accounting entries with events.

   For further details on maintaining Accounting Entries and Advices, refer Product Definition User Manual under Modularity.

7. On Exchange Derivatives Portfolio Product Definition screen, click the MIS tab.

   The MIS Details screen is displayed.

   Figure 5-3 MIS Details

   
   Description of "Figure 5-3 MIS Details"

   Through the MIS product details screen you can link the product to transaction MIS codes. The transaction codes linked to the portfolio product are defaulted to all the portfolios involving the product.

   For more details on MIS Details screen, refer MIS User Manual.

8. On the Exchange Derivatives Portfolio Product Definition screen, click the Preferences tab.
   The Preferences screen is displayed.

   Figure 5-4 Preferences

   
   Description of "Figure 5-4 Preferences"

   Table 5-14 Preferences - Field Description

   Field	Description
   Costing Method	costing method is used to determine your holding cost in a portfolio. Based on the preference of your bank you can select an option from the option list: The costing methods are as given below: Weighted Average Cost (WAC) Last in first out (LIFO) First in first out (FIFO) Deal matching (DMAT) Note: In Oracle Banking Treasury Management profit and loss calculations are maintained only for the bank’s own portfolio. Therefore, you can specify this preference only while setting up your own portfolios.
   Allow Deal Matching	Select this box to indicate that intra-day manual matching should be allowed, even though the costing method selected is FIFO or LIFO. This check box is enabled only when costing method selected is ‘FIFO/LIFO’. For any other costing method, this is disabled.
   Open Individual Position	Select this box to indicate that accounting entries for opening and closing of positions should be posted individually for each deal, when the costing method is DMAT. This checkbox is enabled only when costing method selected is ‘DMAT’. For any other costing method, this is disabled.
   Post Deal -wise PL Entries	Select this box to indicate that accounting entries for realized PL should be posted individually for each pair of deals matched, when the costing method is FIFO, LIFO or DMAT. This checkbox is enabled only when costing method selected is ‘FIFO/LIFO/DMAT’.