Thursday 25 September 2014

Eliminating block.field issue while upgrading from EBS R11i to R12 versions

Eliminating block.field issue while upgrading from EBS R11i to R12 versions


Problem

In 11i, Customers are accessed through Oracle forms where :block.field reference is allowed to dynamically bring values in value sets. But in R12, Customers are accessed through OAF page where this will throw error.

Solution


The Customer OAF page can be personalized to dynamically bring the value referred in :block.field in 11i version. This is explained below:

Step 1: Create a stored function in APPS schema.



Step 2: Alter the WHERE clause of the value set ,

Instead of< Block.Field > Use the xx_get_customer_id function.


Step 3

Login to E-business suite. Ensure that profile option FND: Personalization Region Link EnabledPersonalize Self-Service Defn and FND:Diagnostics is set to 'Yes' at user level.

Navigate to Receivables manager->customers->Customers.

Query for Account number 5754(For example). Select the customer name link. Select on Details button under "Create Site" Region.


Step 4: Select the 'Personalize  Page' link as shown below.



Step 5: select 'Create item ' icon against the Message Component Layout: (acctInfo)



Step 6: Enter the details as shown in below screenshot and select 'Apply' button



Step 7: Select 'Create item' icon against the region "Flex: (SitesRN.AddressLocationSite.partySiteInformation)"




Step 8: Create a Flex map item as shown below and select 'Apply' once done.



Step 9: Select  'Create item' icon against the region "Flex: (SitesRN.AddressLocationSite.partySiteInformation)"



Step 10: Create a Flex map item as shown below and select 'Apply' once done.






2 comments:

  1. Hi Archana,

    I have followed your document to pass block.field value in iProcurement but my valueset LOC doesnot brig back values as p-er the block.field value. CWould you be able to help. I can send more details.

    ReplyDelete
  2. Hi Archana,

    I have followed your document to pass block.field value in iProcurement but my valueset LOC doesnot brig back values as p-er the block.field value. CWould you be able to help. I can send more details.

    ReplyDelete