Unexpected Error When Clicking On the Additional Details Link on Supplier's Bank Accounts Page

Unexpected Error When Clicking On the Additional Details Link on Supplier's Bank Accounts Page [ID 1186427.1]

Applies to:

Oracle Cash Management - Version: 12.0.6 and later   [Release: 12 and later ]
Information in this document applies to any platform.
ceextbab.pls

Symptoms

When clicking on the Additional Details link on Supplier's Bank Accounts page, the following OA Exception error occurs:

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details.

Exception Details:
oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)

STEPS
-----------------------
1. Navigate to Supplier >banking details
2. Click on update

BUSINESS IMPACT
-----------------------
Due to this issue, users not able to update supplier bank details

Cause

This issue has been fixed on the following file version ceextbab.pls-120.12.12000000.7

1) Bug Summary
 A. Functional
1. Description
   1. Updating the Bank Account details using the  CE_BANK_PUB.UPDATE_BANK_ACCT
   2. Querying for the details about the Bank Account in the  Bank Account Search page.
   3. Click on the account name.
 The page errors out displaying an exception.
2. Resolution
  The page does not error out and displays the account  details.

This issue has been addressed on the following bug
Bug 8407297 Abstract: R12: BANK ACCOUNT: OAEXCEPTION:
Bug 8627701 SUPPLIERS - MODIFY BANK DETAILS - JAVA NULLPOINTEREXCEPTION

Solution

1. Download and review the readme and pre-requisites for Patch 10024682:R12.CE.A

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
        ceextbab.pls 120.12.12000000.13
    You can use the commands like the following:
        strings -a $XX_TOP/filename |grep '$Header'

5- migrate solution to production only if you are satisfied with result.

if  the following queries returned any records then please log Datafix with Oracle support to provide you with Data fix

1-Select Country_code from iby_ext_bank_accounts where bank_account_num = '@Enter  affected bank account Number here'

2-select bank_id, branch_id from iby_ext_bank_accounts
where bank_id < 0 or branch_id < 0;

Note:-  For existing data corruption, Please log a service request with Oracle Support requesting for datafix.

For Support (Log datafix Bug with Development):








To avoid future  occurrence please apply Patch 10024682:R12.CE.A>

Confirm the following file version
ceextbab.pls 120.12.12000000.13


@Another Possible corruption