Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error while importing a PO( OraclePOI 850) - Order number not created.

Status
Not open for further replies.

ImEDIabhishek

Programmer
Jun 17, 2011
5
0
0
US
I tried importing a PO into Oracle Database through e-commerce gateway (Inbound:purchase Orders(850)). It imported all the data except order number.

Parameters i gave are

File Path=Good(Check)
File Name=Good(Check)
Debug_Mode=0
Run Import=NO
Order Import Instances=4
Map_Code=ECI_POI_FF
Data_File_Character_Set=UTF8

So i guess its failed. Here's the error message, Don't mind the hideous pasting job over here.


+---------------------------------------------------------------------------+

Current system time is 17-JUN-2011 01:49:41

+---------------------------------------------------------------------------+

**Starts**17-JUN-2011 01:49:41
**Ends**17-JUN-2011 01:49:45
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Start inbound transaction for POI.
Staging for transaction POI.
End of staging for transaction POI.
Starting generic inbound for transaction POI.
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for CUSTOMER_RELATIONSHIPS_FLAG
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
org_id has changed so delete the cache and reset the globals
PARAMETER VALUE from the DB when org_id has changed :
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for CUSTOMER_RELATIONSHIPS_FLAG
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter Value from the cache :
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for CUSTOMER_RELATIONSHIPS_FLAG
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter Value from the cache :
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for CUSTOMER_RELATIONSHIPS_FLAG
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter Value from the cache :
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for CUSTOMER_RELATIONSHIPS_FLAG
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter Value from the cache :
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for CUSTOMER_RELATIONSHIPS_FLAG
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter Value from the cache :
2 Document(s) processed.
End of generic inbound for transaction POI.
End of inbound transaction POI.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


 
I Checked with our DBA Guys, This is because that file doesn't adequate privileges in Database.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top