Oracle Database Discussions

Seems you are trying to implement inbound flow -

Partner -> Oracle B2B --> Oracle SOA ----> DB

For B2B to poll and pick EDI file, please create a listening channel -

http://docs.oracle.com/cd/E23943_01/user.1111/e10229/bb_listen_chan.htm#BAJJICJJ

Regards,
Anuj

Thank you Anuj for the Replay.

I have Configured the Listening channel in my B2B console as

i selected the partner channel.
Protocol : Gneric File-1.0

Folder Name :c:\users\desktop\B2b. and under channel attributes i checked the 'Enable Channel' button. but after this also no instance is created for my bpel process.
i have a question, the .dat file needs to be placed in my folder rt ?(i mean, the folder from which B2B receives the file ).
I Just want to receive the invoice data from this file. but it is not happening. please give me any link which contains how to receive EDI X12 810 file data using B2B adapter. Thank you in advance.

Anuj, i have one more doubt , if i import xml file( we can only import xml file rt , correct me if am wrong) directly from B2B console ? what will be the advantage ? can we access this file from our B2B into soa suite. ?

Regards,
Kotresh

Edited by: 979032 on Feb 14, 2013 3:04 AM

Kotresh,

Let's take it one by one.
Did B2B pick the file at least? Do you see any report in Business Message Report? If yes, then what is it's status - MSG_COMPLETE or MSG_ERROR? If it is MSG_ERROR then please post the error here.

How it works - B2B picks the file from file location and tries to process it as per the configuration. If processing completes then file is delivered to the middleware (BPEL in your case) otherwise message is not delivered to the middleware. So until and unless B2B is not able to process the file correctly, you will not see any instance at SOA layer.
Yes, for B2B to pick the file, you need to place it in the folder configured in listening channel.
You may refer to the EDI X12 sample available at below link -

http://java.net/projects/oraclesoasuite11g/pages/B2B

Regards,
Anuj

Till now I was trying with the files placed on my local drive. Now I'm trying to place them on the server where exactly the SOA is being installed. Let you know once when I do that process. Thanks for guiding me. If any error pops up I will be posting it for sure.


Thanks Anuj.

Hi Anuj ,
I placed the folder in the correct directory and given the path. now B2B picking the file as file is deleting after some time . and Here is the MSG_ERROR am receiving.
-------------------------------------------------------------------------------
Id 7F00000113CF2A02BDF0000017D7E271
Message Id 7F00000113CF2A01CE80000017D7E26D
Refer To Message Refer To Message
Sender Type Name
Sender Value OutputEDI
Receiver Type Name
Receiver Value MyCompany
Sender OutputEDI
Receiver MyCompany
Agreement Id
Agreement
Document Type
Document Protocol
Document Version
Message Type REQ
Direction INBOUND
State MSG_ERROR
Acknowledgement Mode NONE
Response Mode ASYNC
Send Time Stamp 02/19/2013 05:24:04 AM
Receive Time Stamp 02/19/2013 05:24:04 AM
Document Retry Interval(Channel) 0
Document Remaining Retry(Channel) 0
Document Retry Interval(Agreement)
Document Remaining Retry(Agreement)
Native Message Size 25022
Translated Message Size
Business Action Name
Business Transaction Name
Xpath Name1
Xpath Value1
Xpath Expression1
Xpath Name2
Xpath Value2
Xpath Expression2
Xpath Name3
Xpath Value3
Xpath Expression3
Correlation From XPath Name
Correlation From XPath Value
Correlation From XPath Expression
Correlation To XPath Name
Correlation To XPath Value
Correlation To XPath Expression
Wire Message Wire Message
Application Message Application Message
Payload Storage Payload Storage
Attachment Attachment
Label
Collaboration Id
Collabration Name
Collabration Version
Business Action Name
Exchange Protocol Name Generic File
Exchange Protocol Version 1.0
Interchange Control Number
Group Control Number
Transaction Set Control Number
Error Code B2B-50083
Error Description Machine Info: (soabpm-vm) Description: Document protocol identification error.
Error Level ERROR_LEVEL_COLLABORATION
Error Severity ERROR
Error Text Document protocol identification error.
------------------------------------------------------------------------------------------------------------------------------------------------
Please suggest us now. Thank you for the help you done for us .
Regards,
Kotresh

Hi Anuj ,
I placed .dat file now. The file Picked by B2B adapter. But i was getting the Error. The error i found in Business Message as

"Error Code B2B-50547
Error Description Machine Info: (soabpm-vm) Description: Agreement not found for trading partners: FromTP null, ToTP MyCompany with document type 810-3070-INBOUND.
Error Level ERROR_LEVEL_COLLABORATION
Error Severity ERROR
Error Text Agreement not found for trading partners: FromTP null, ToTP MyCompany with document type 810-3070-INBOUND. "

But i created agreement for the partner and my document type name is "NewDocumentType" and in the wire message a am getting as shown below

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Id 7F00000113CFC36785C0000017D7E2B0
Message Id 7F00000113CFC36785C0000017D7E2B0
Business Message 7F00000113CFC367A450000017D7E2B7
Packed Message Packed Message
Payload Payload
Protocol Message Id EDIX12810.dat@7F00000113CFC36799B0000017D7E2B4
Refer To Protocol Message Id
Protocol Collaboration Id
Protocol Transport Binding filename=EDIX12810.dat filesize=2289 ChannelName=MyCompany_ListeningChannel file_ext=dat fullpath=/home/oracle/Desktop/B2BFiles/EDIX12810.dat timestamp=2013-02-21T01:58:21.000-08:00 MSG_RECEIVED_TIME=Thu Feb 21 02:04:53 PST 2013
Message Digest Message Digest
Digest Algorithm
Transport Protocol File
Transport Protocol Version 1.0
Url file://localhost//home/oracle/Desktop/B2BFiles/
security
Transport Headers filename=EDIX12810.dat filesize=2289 ChannelName=MyCompany_ListeningChannel file_ext=dat fullpath=/home/oracle/Desktop/B2BFiles/EDIX12810.dat timestamp=2013-02-21T01:58:21.000-08:00 MSG_RECEIVED_TIME=Thu Feb 21 02:04:53 PST 2013
certificates certificates
State ERROR
Reattempt Count
Error Code
Error Description
Error Text
exchangeRetryInterval
exchangeRemainingRetry
Message Size 2289


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I also has one more doubt, now i created ecs,xsd and .dat by selecting sample EDI file in Document editor. suppose i want create the same ecs ,.xsd and .dat for my gentran file which is of EDI x12 810 standard but i have it in PDF format , then how can i access that to in Document editor ( in the import option, i found Gentran DDF and Gentran Unix IG and i was getting the following error while importing my PDF file
ErrorCode : 0xC00CE508
File Position : 10
Line Number : 2
LineByte Position :2
Reason: An invalid character was found in text content error) so that i can create .dat file and i can place the same in my folder in order to pick the file.

Please help us . Thank you .
Regards,
Kotresh

Edited by: 979032 on Feb 21, 2013 2:17 AM

Hi Kotresh,

This seems to be an inbound scenario case. FromTP is not getting identified by the B2B.

There are many options available to identify the fromTP. You can refer to b2b guide to know more on that.

A simple step, you can try by giving proper filename format in listening channel:
%TO_PARTY%_%FROM_PARTY%_%DOCTYPE_NAME%_%DOCTYPE_REVISION%.dat

and provide the filename based on this naming convention. like
TP_MyCompany_810_3070.dat

http://docs.oracle.com/cd/E23943_01/user.1111/e10229/bb_listen_chan.htm#BAJJICJJ

Hi Kotresh,
That's one problem. For EDI, doc type name must be EDI X12 doc. For example, for EDI 810 transaction, doc type name must be 810 and it should be created under version 3070 (the verion of EDI)
In case of EDI, you may skip file naming convention but make sure that you have added EDI Interchange ID and EDI Group ID in the trading partner profiles as identifiers. The value in payload and in TP configuration must be same.

Instead of PDF, use the native Gentran mapper file and it should work.

Regards,
Anuj