My Oracle Support Banner

Interface In-Service Program Ending In Error: Cse_others_exception (Doc ID 1092868.1)

Last updated on MAY 18, 2020

Applies to:

Oracle Asset Tracking - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 version,

When attempting to run program ' Interface In-Service Transactions to Oracle Projects - Normal Items'
the following error occurs.

ERROR
-----------------------
Inside OTHERS in interface_nl_to_pa : CSE_OTHERS_EXCEPTION (ERR_MSG=cse_proj_item_in_service_pkg=ORA-01403: no data found)
error interfacing nl_to_pa CSE_OTHERS_EXCEPTION (ERR_MSG=cse_proj_item_in_service_pkg=ORA-01403: no data found)

This happens when following two flows are used.

1. Parent and child issue to project then put in service
-----------------------
1) Parent asset (normal item) is stored in inventory (OAT shows one component child).
2) Issue parent asset to project. (run move program)
3) Install parent asset.
4) Place parent asset in service.
5) Run Interface In-Service Transactions.

2. Non-serialized item issue to project then put in service
-----------------------
1) PO receives quantity to project
2) Install some received quantity
3) Put some installed quantity in service
4) Run Interface In-Service Transactions.

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
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.