ORACLE - FUSION : Common Lookup DFF Configuration.

 Following steps will let you know how to configure DFF's for common lookups and use them while configuring common lookups. 

Normal common lookups will let you configure lookup code and corresponding meaning.  If you want to configure additional values for a lookup code then you can use DFF's to configure context and use them in lookups. 

MANAGE DFF

• Login into Fusion. 
• Go to Manage and Setup 
• Search for Manage Descriptive Flexfields
• Search for Lookup values descriptive flexfield (Name)
• Edit - Lookup values descriptive flexfield
• Manage Contexts
• Search for existing contexts or Create a new one. 
• Create
• Give a display name  - XXSCM_SHOP_ORG_MAP_LOOKUP
• API Name - XxscmShopOrgMapLookup
• Save
• Under Context Sensitive Segments add segments - ( additional lookup values )
• Give a Name - Ex: Inventory_Organization
• Data Type as Character
• Table Column will auto populated - Attribute1
• Under Value Set : Either select an existing one or create new
• Create a New Value Set
• Value Set Code - XXSCM_INV_ORG_NAME
• Module - Inventory Management
• Validation Type : Table   -- This will allow us to define table, column and where clause. 
•  Under Definition 
• From Clause - Provide Table Name - INV_ORGANIZATION_DEFINITIONS_V
• Value Column Name - Provide Column Name - ORGANIZATION_CODE
• ID Column Name :  ORGANIZATION_ID
• WHERE Clause :  INVENTORY_ENABLED_FLAG = 'Y'
• Save 
• This will validate TABLE and Column Values. 
• Save and Close the value set
• Save and Close the Segment
• Follow the above steps to create a new segment for inventory.
• Save and Close the Context

MANAGE COMMON LOOKUP:

• Go to Manage and Setup 
• Search for Manage Common Lookups
• Add Common Lookup +
• Lookup Type : XXSCM_SHOP_ORG_LOOKUP
• Meaning : Give some valid meaning 
• Description : Give some value Description
• Module : Common
• REST Access Secured :  Authenticated. 
• Lookup Code
• Add 
• Lookup Code : Shop1
• Meaning : Give a Name
• Enable
• Expand the lookup code
• Select the context created earlier
• Select the Org 
• Select the Inventory

Oracle OIC - ERP Adapter Filter Business Events

We can use ERP adapter to consume Business Events from Fusion and process them. Before we need to subscribe the events , we need to create a CSF key or Token based authentication schema in Fusion.  ERP event handler framework will use these key or authentication schema to invoke the OIC integration. 

Integration reactivated after 2021 - May will use the token based authentications. It doesn't require additional settings. 

Use the ERP adapter at trigger point and select Business Events Operations and select the particular business event. 

Example : Invoice Hold Applied. 

This will create a subscriber entry in Fusion.  We can verify subscriber details using following URL. This will ask for credentials and need to provide valid credentials. 

https://xx-vijay.fa.ocs.oraclecloud.com/soa-infra/PublicEvent/subscriptions

All events are triggered from Fusion.  Fusion will use the subscriber details and invoke integrations.  

Sample Invoice Hold Payload:

<ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/XXVV_SUBSCRIBE_TO_INVHOLD_REQUEST/types">   <ns0:ApInvHoldAppliedInfo xmlns:ns0="http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/model/entity/events">      <ns0:InvoiceId>         <ns0:newValue value="XXXXXXX00000001"/>         <ns0:oldValue/>      </ns0:InvoiceId>      <ns0:OrgId>         <ns0:newValue value="XXXXXXX00000002"/>         <ns0:oldValue/>      </ns0:OrgId>      <ns0:HoldId>         <ns0:newValue value="72011"/>         <ns0:oldValue/>      </ns0:HoldId>      <ns0:HoldLookupCode>         <ns0:newValue value="AMT REC"/>         <ns0:oldValue/>      </ns0:HoldLookupCode>      <ns0:HoldReason>         <ns0:newValue value="Amount billed exceeds amount received."/>         <ns0:oldValue/>      </ns0:HoldReason>      <ns0:LineNumber>         <ns0:newValue value=""/>         <ns0:oldValue/>      </ns0:LineNumber>      <ns0:HeldBy>         <ns0:newValue value="5"/>         <ns0:oldValue/>      </ns0:HeldBy>      <ns0:HoldDate>         <ns0:newValue value="2021-06-04T06:27:33"/>         <ns0:oldValue/>      </ns0:HoldDate>      <ns0:LineLocationId>         <ns0:newValue value="XXXXXXX00000003"/>         <ns0:oldValue/>      </ns0:LineLocationId>      <ns0:RcvTransactionId>         <ns0:newValue value=""/>         <ns0:oldValue/>      </ns0:RcvTransactionId>   </ns0:ApInvHoldAppliedInfo></ns01:onEvent>

Use the following Filter Expression to filter a specific Hold. 

<xpathExpr xmlns:ns0="http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/model/entity/events">$eventPayload/ns0:HoldLookupCode/ns0:newValue/@value='AMT REC'</xpathExpr>

$eventPayload: Inbuilt variable which will contain the payload.