The Cycle Count Open Interface Is Not Working For The Stock In Api (Doc ID 818977.1)

Last updated on OCTOBER 08, 2024

Applies to:

Symptoms

On 12 in Production:
In Oracle Warehouse Management,Cycle count open interface is not working for LPN related counts

EXPECTED BEHAVIOR
Expected that the system will consider the LPN while doing the count using interface table

STEPS
The issue can be reproduced at will with the following steps:
1. Create a Cycle Count
2. Enter the Manual Cycle Count Entry.
3. Run the program 'Perform Complete Cycle Count' Program to generate generate cycle count request
4. Post the count Entries using the by calling the API using the below Script

DECLARE
x_return_status VARCHAR2(4000);
x_errorcode NUMBER;
x_msg_count NUMBER;
x_msg_data VARCHAR2(4000);
p_interface_rec APPS.MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;
x_interface_id_list
APPS.MTL_CCEOI_VAR_PVT.INV_CCEOI_ID_TABLE_TYPE;
v_msg_data VARCHAR2(2000);
v_msg_index_out NUMBER;
BEGIN
-- USER_ID , RESP_ID and RESP_APPL_ID needs to be passed
fnd_global.apps_initialize(1068,56229,724);

--Data based on the Count Request
p_interface_rec.PARENT_LPN_ID := 370;
p_interface_rec.OUTERMOST_LPN_ID := 370;
p_interface_rec.ORGANIZATION_ID := xxxx;
p_interface_rec.LAST_UPDATE_DATE := sysdate;
p_interface_rec.LAST_UPDATED_BY := -1;
p_interface_rec.CREATION_DATE := sysdate;
p_interface_rec.CREATED_BY := -1;
p_interface_rec.LAST_UPDATE_LOGIN := -1;
p_interface_rec.ACTION_CODE := 14;
p_interface_rec.CYCLE_COUNT_HEADER_ID := 151;
p_interface_rec.INVENTORY_ITEM_ID := 4572 ;
p_interface_rec.SUBINVENTORY := 'BULK';
p_interface_rec.LOCATOR_ID := 1181;
p_interface_rec.LOCK_FLAG := 2;
p_interface_rec.PROCESS_FLAG := 1;
p_interface_rec.PROCESS_MODE := 3;
p_interface_rec.count_uom := 'EA';
p_interface_rec.count_quantity := 150;
p_interface_rec.employee_id := 1166;
p_interface_rec.count_date := sysdate;

--Calling API to Post the count Entries.

mtl_cceoi_action_pub.process_lpn_countrequest(0.9
,FND_API.G_TRUE
,FND_API.G_TRUE
,100
,x_return_status
,x_errorcode
,x_msg_count
,x_msg_data
,p_interface_rec
,x_interface_id_list);

dbms_output.put_line('x_return_status '||x_return_status)

5. Entried got posted.
6. But LPN_ID has not populated and So Stock got unpacked.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, Quantities are getting unpacked.


.

Changes

Cause

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