My Oracle Support Banner

Import In Customer Hierarchy Member Object Is Unsuccessful (Doc ID 2003129.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Fusion Trading Community Model Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Trading Community Model - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

Situation

Customer is running customer hierarchy import and get some functional
errors

But last import status is Unsuccessful and Not Complted with Errors

As far i know Unsuccessfull status relate to system error and not
functional errros

1)
we got some functional error and

100000060975198 100000060973804 300000052190576
HZ_IMP_TREE_STRUCT_VALID_ERROR ATTRIBUTE1
HZ_PARTY_HIERARCHY/HZ_CUSTOMER_HIERARCHY HZ_IMP_HIERARCHY_NODES
2015-03-30 14:15:12.0 Secure 2015-03-30 14:15:12.0 Secure
127EB092DD887606E0536514C10A56A1 ERROR
100000060974789 100000060973804 300000052190576
HZ_HIER_IMPORT_NON_CUSTOMER HZ_IMP_HIERARCHY_NODES 2015-03-30 14:15:18.0
Secure 2015-03-30 14:15:18.0 Secure 127EB092DD887606E0536514C10A56A1 ERROR
100000060974868 100000060973804 300000052190576 FND_CMN_REQ_SRCH
HZ_IMP_HIERARCHY_NODES 2015-03-30 14:15:20.0 Secure 2015-03-30
14:15:20.0 Secure 127EB092DD887606E0536514C10A56A1 ERROR
100000060974778 100000060973805 300000052190576
HZ_IMP_INVAL_VALUE_COMPARE ATTRIBUTE1 TREE_CODE ATTRIBUTE2 TREE_CODE
ATTRIBUTE3 FND_TREE_VERSION/HZ_IMP_HIERARCHIES_T HZ_IMP_HIERARCHY_NODES
2015-03-30 14:15:16.0 Secure 2015-03-30 14:15:16.0 Secure
127EB092DD887606E0536514C10A56A1 ERROR
100000060974779 100000060973806 300000052190576
HZ_IMP_INVAL_VALUE_COMPARE ATTRIBUTE1 TREE_CODE ATTRIBUTE2 TREE_CODE
ATTRIBUTE3 FND_TREE_VERSION/HZ_IMP_HIERARCHIES_T HZ_IMP_HIERARCHY_NODES
2015-03-30 14:15:16.0 Secure 2015-03-30 14:15:16.0 Secure
127EB092DD887606E0536514C10A56A1 ERROR
100000060975174 100000060973807 300000052190576
HZ_HIER_IMPORT_MULTI_ERROR HZ_IMP_HIERARCHY_NODES 2015-03-30 14:15:12.0
Secure 2015-03-30 14:15:12.0 Secure 127EB092DD887606E0536514C10A56A1 ERROR
100000060974870 100000060973807 300000052190576 HZ_HIER_IMPORT_INACTIVE
HZ_IMP_HIERARCHY_NODES 2015-03-30 14:15:20.0 Secure 2015-03-30
14:15:20.0 Secure 127EB092DD887606E0536514C10A56A1 ERROR
100000060975132 100000060973808 300000052190576
HZ_IMP_TREE_STRUCT_VALID_ERROR ATTRIBUTE1
HZ_PARTY_HIERARCHY/HZ_CUSTOMER_HIERARCHY HZ_IMP_HIERARCHY_NODES
2015-03-30 14:15:12.0 Secure 2015-03-30 14:15:12.0 Secure
127EB092DD887606E0536514C10A56A1 ERROR
100000060974816 100000060973808 300000052190576
HZ_HIER_IMPORT_NON_CUSTOMER HZ_IMP_HIERARCHY_NODES 2015-03-30 14:15:18.0
Secure 2015-03-30 14:15:18.0 Secure 127EB092DD887606E0536514C10A56A1 ERROR
100000060974860 100000060973808 300000052190576 FND_CMN_REQ_SRCH
HZ_IMP_HIERARCHY_NODES 2015-03-30 14:15:20.0 Secure 2015-03-30
14:15:20.0 Secure 127EB092DD887606E0536514C10A56A1 ERROR
100000060975135 100000060973809 300000052190576
HZ_IMP_TREE_STRUCT_VALID_ERROR ATTRIBUTE1
HZ_PARTY_HIERARCHY/HZ_CUSTOMER_HIERARCHY


and also below ones

2)

ERROR_ID INTERFACE_TABLE_NAME BATCH_ID INTERFACE_ROW_ID MESSAGE_NAME
TOKEN1_NAME TOKEN1_VALUE
100000070319040 HZ_IMP_HIERARCHY_NODES 300000055070141 300000055070148
HZ-HZ_IMP_TREE_NODE_EXCEPTION ERROR_MESS ORA-01403: no data found

Question

Do you have some justifications about this ?
Is the ORA-01403: no data found a system error ?

 

by runnng

 

select * from mkt_imp_errors where Batch_Id In (300000048475880 )
order by error_id asc;
and uploadf output file

  

Solution

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
Goal
Solution


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