Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need Query to status of sales order import using FBDI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Query to status of sales order import using FBDI

Question
11
Views
0
Comments

Content

Hi All,

I am importing sales order using FBDI and i need a report which will pull import status(Imported or error),source transaction number,error message in case of error .Can anyone help me with this report.

N.B: below is my query which is used but sometimes it fetches and sometimes it not fetch any record.

 

 
SELECT  req.req_entity_id1 "SOURCE TRANSACTION ID",
        dohai.interface_status_code "STATUS",
dohai.source_transaction_system "SOURCE TRANSACTION SYSTEM",
NULL "ORDER NUMBER",
        mt.message_text "ERROR MESSAGE"
FROM    doo_message_requests req,
        doo_messages_b mb       ,
        doo_messages_tl mt      ,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!