My Oracle Support Banner

Using Open Interface Mtl_cc_entries_interface System Not Populate Field Transaction Reason (Doc ID 1521324.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Cycle coun

ACTUAL BEHAVIOR
---------------
Using open interface mtl_cc_entries_interface, system not populate field transaction reason.

EXPECTED BEHAVIOR
-----------------------
Using open interface mtl_cc_entries_interface, system should rightly populate field transaction reason.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Insert data to mtl_cc_entries_interface and put information about transaction reason (transaction_reason_id). For example using below template script:

INSERT INTO mtl_cc_entries_interface
 (cc_entry_interface_id,
  organization_id,
  last_update_date,
  last_updated_by,
  creation_date,
  created_by,
  action_code,
  cycle_count_header_id,
  item_segment1,
  revision,
  subinventory,
  locator_id,
  count_date,
  employee_id,
  lock_flag,
  process_flag,
  process_mode,
  valid_flag,
  delete_flag,
  status_flag,
  transaction_reason_ID,
  reference,
  count_uom,
  SYSTEM_QUANTITY,
  COUNT_QUANTITY)
VALUES
 (MTL_CC_ENTRIES_INTERFACE_S1.nextval,
  138,
  SYSDATE,
  1489,
  SYSDATE,
  1489,
  14,
  12002,
  'M1FT00120',
  '0',
  'M1-SU-PREL',
  5370,
  SYSDATE,
  7363,
  2,
  1,
  3,
  1,
  2,
  4,
  805,
  'test adnotacji',
  'SZT',
  100,
  97)

2. Run inventory report: Import cycle count entries from open interface


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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.