Blog / Oracle Application Blog
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.
: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:
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.
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.
manager->customers->Customers.
Query
for Account number 5754(For example). Select the customer name link.
Select on Details button under “Create Site” Region.
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.
