Bank DFF while up gradation from 11i to R12

Issue in Bank DFF while up gradation from 11i to R12

Issue Description:

In 11i application we are having the DFF for capturing MICR and IFSC codes while defining banks and bank accounts. After upgrade the DFF details are migrated. We are able to see in back end tables. But we are not able to find the same in Bank account HTML form (Front end) in r12 application

Solution:

In 11i, both internal and external bank accounts were stored in the AP_BANK_ACCOUNTS_ALL table.

But in R12, this table is now obsolete and instead the internal banks accounts are stored in table CE_BANK_ACCOUNTS and the external bank accounts are stored in table IBY_EXT_BANK_ACCOUNTS.

So the flex fields will need to point to CE_BANK_ACCOUNTS and IBY_EXT_BANK_ACCOUNTS for internal and external bank accounts respectively.

The 11i descriptive flex field for Application: Payables, Title: Bank Account has been migrated to R12 but because the table it points to is obsolete, it will not be accessible in the R12 application.

Note: Reference Metalink ID- 1083095.1

Query to find out one of the bank account in issue in back hand:

<<R11i Data>>>

SELECT * FROM AP_BANK_ACCOUNTS_ALL
WHERE BANK_ACCOUNT_NAME = '&BANK_ACCOUNT_NAME_IN_R11i'

<<R12 Data>>>

SELECT * FROM CE_BANK_ACCOUNTS
WHERE BANK_ACCOUNT_NAME = '&BANK_ACCOUNT_NAME_IN_R12'

We have to Do:

In the 11i instance, the Payables "Bank Account" (AP_Bank_Accounts) descriptive flex field (DFF) is enabled with several segments defined. After upgrading to R12, not able to view the DFF information on the new Cash Management Bank Account screens.

However, there is a new DFF for Cash Management "Bank Accounts" (CE_Bank_Accounts) apparently created as part of the R12 upgrade, but it has no segments defined. There is no mention of needing to recreate DFFs for Banks as part of the R12 upgrade post tasks.
These must be manually re-created as a post-upgrade task. But there is no mention of this in the Upgrade Notes on Descriptive Flex fields.

Automatically the DFF in 11i will reflect to this Payable Application. But we have to define manually for Cash management Application.

Application: Cash management in DFF

  

Click on Segment

Create Value Set in screen shot

 

  

Then Freeze Flex field Definition and then Compile. 

Then Go to Bank Account we can view the MICR No and IFCS code in context value  in bank account information.