R12: OIE: Fusion Expenses Mobile App: Mobile App for iOS (iPhone) with OID and SSO Fails Authentication

(Doc ID 2132217.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

When using OID with passwords stored in AD and the External Authentication Plugin implemented users are not able to login to the Fusion Mobile Expenses application with SSO enabled.

In the FND_USERS table, ENCRYPTED_FOUNDATION_PASSWORD and ENCRYPTED_USER_PASSWORD are currently set as EXTERNAL.

The mobile device shows the following error:
---------------------------------------------
Fusion Expenses Login

Host URL: <your host URL>
User Name: <your user name>

Alert
Login failed. Please ensure
that the server name, user
name and password are correct

---------------------------------------------

When testing per the steps documented in MOS <Note 1625446.1> "Oracle Fusion Expenses iOS/Android App for Internet Expenses" under section 'Steps to Debug Expenses Mobile App Failures' for mlogin an authentication failure message occurs. The Fusion Expenses Mobile app accesses mLogin URL for cookie information and it uses that cookie for all further web-service related communication.

Why is this authentication failure message occurring?

Example of mLogin failure.

Complete the mlogin test from MOS <Note 1625446.1> "Oracle Fusion Expenses iOS/Android App for Internet Expenses" under section 'Steps to Debug Expenses Mobile App Failures':

1. Open the url http(s)://<your-instance>:< port>/OA_HTML/RF.jsp?function_id=mLogin
2. A basic authentication login dialog should appear

3. The above dialog is not seen, instead the following data appears (example only)
<response>
<status>
<code>401</code>
<description>Invalid username/password</description>
</status>
<data>
<accessToken>-1</accessToken>
<accessTokenName></accessTokenName>
<ebsVersion></ebsVersion>
</data>
</response>

4. Attempt the same mLogin test from a desktop instead of mobile device, user still not able to open the URL.

HTTP/1.1 401 Unauthorized
Date: Thu, 28 Apr 2016 18:43:00 GMT
Set-Cookie: JSESSIONID=99a0f02436f9823c91fa8902eccc9b9bfab1f5c42c1b802a10b6187a6219b8f0.e34PbxaPb38PaO0Lb3aLchqSa34Te0; path=/OA_HTML
Content-Location: /rest
Cache-Control: no-cache
Pragma: no-cache
WWW-Authenticate: BASIC realm="_fndrealm_"
Transfer-Encoding: chunked
Content-Type: application/xml

<response>
<status>
<code>401</code>
<description>Invalid username/password</description>
</status>
<data>
<accessToken>-1</accessToken>
<accessTokenName></accessTokenName>
<ebsVersion></ebsVersion>
</data>
</response>

 


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms