Mobile Field Service - MFS Multiplatform App: ORA-01403 Third Party Part Requirement Order Form (Doc ID 2048984.1)

Last updated on SEPTEMBER 09, 2015

Applies to:

Oracle Mobile Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3 - Planner's Desktop, trying to create the Part Requirement Order from MFS Multiplatform.

When selecting the Technician, it worked just fine.
But when selecting "Third Party", system is automatically converting it to "Technician".

Also, when trying to change the Address Type on the requirement, system is not allow users to change to "Third Party" and it is failing with below error.

Error:

Your last transaction failed with following message:

(In red)
Execution of procedure Update_requirement_headers failed because the following unexpected errors occurred:
Cause: ORA-01403: no data found.
Action: Please contact your technical representative.

Steps:

Phone - Trying order Part ABC-1000-0010 for order

- Select Address Type = 'Third Party'
- Search.
=> Part ABC-1000-0010 is retrieved.
- Click 'Done' button (top right)
=> The Address Type changed back to 'Technician'.

- Changed it back to 'Third Party'
- Click 'Order' button (top right)
=> The part requirement is created again with 'Address Type' = 'Technician'.
 
- When trying to change it again, the error mentioned above appears.

Cause

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