My Oracle Support Banner

FA: Supply Planning: Planning Planner FBDI Uploaded But The "Employee Number" Column Is Missing. (Doc ID 2580814.1)

Last updated on SEPTEMBER 21, 2019

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.04.0 version, Supply Plan

ACTUAL BEHAVIOR
---------------

From back end we found that employee number in planning uploaded is different with what have mentioned in FBDI.

EXPECTED BEHAVIOR
-----------------------
What ever employee number mentioned in FBDI same need to be upload in Planning.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.FBDI employee import in planning template filled with required details with Employee number as mentioned as 123456 for ABC planner.
2.Uploaded this Template in UCM server.
3.Navigate to plan inputs.
4.click on task and click load planning data from flat files.
5.FBDI template is uploaded successfully.
6.The employee number is not visible in UI hence from back end from below query.
  select PLANNER_CODE,SR_INSTANCE_ID,PLANNER_ID,EMPLOYEE_NUMBER,EMPLOYEE_NAME
  from msc_planners order by last_update_Date desc
7.Observed different employee number which is generated by system.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, its misleading.

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.