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

Last updated on MARCH 08, 2017

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 reson (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

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