Thanks, Dad, for showing me how poor we are.”

“Thanks, Dad, for showing me how poor we are.”

One day, a father of a very wealthy family took his son on a trip to the country with the firm purpose of showing his son how poor people live. They spent a couple of days and nights on the farm of what would be considered a very poor family. On their return from their trip, the father asked his son, “How was the trip?”

“It was great, Dad.”

“Did you see how poor people live?” the father asked.

“Oh yeah,” said the son.

“So, tell me, what you learned from the trip?” asked the father.

The son answered, “I saw that we have one dog and they had four. We have a pool that reaches to the middle of our garden, and they have a creek that has no end. We have imported lanterns in our garden, and they have the stars at night. Our patio reaches to the front yard, and they have the whole horizon. We have a small piece of land to live on, and they have fields that go beyond our sight. We have servants who serve us, but they serve others. We buy our food, but they grow theirs. We have walls around our property to protect us; they have friends to protect them.”

The boy’s father was speechless.

Then his son added, “Thanks, Dad, for showing me how poor we are.”

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.