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 Enabled
Personalize
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.





  • September 26, 2014 | 31 views