My Oracle Support Banner

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

Last updated on JULY 14, 2020

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 xxxxxxxx for order

- Select Address Type = 'Third Party'
- Search.
=> Part xxxxxxxx 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.