Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to generate Custom File .EDI Gateway 810

3531344May 23 2018

Hi,

I am new to B2B,I have to get the data from r12 and generate EDI 810 invoice Custom file format and send it to trading partner.

Please help me on this

Comments

alwu-Oracle
Hi,

I loaded the data you mentioned in another thread and run the query using Jena API. I got one answer for the query without seeing any problem.
I also checked the output you uploaded. It is unclear why the original query failed. There was no exception printed out.

Could you please run the query using Jena API (instead of Joseki) and then send the stack trace?

Thanks,

Zhe Wu
784525
Zhe,
This query is returning, the problem is that it takes a remarkably long time. It's taking nearly 4.5 seconds when most finish in tens or hundreds of milliseconds. When I looked into the logs to investigate the possible problems, I discovered that this query is responsible for over 8000 SELECT statements being sent to the database.

Making this query via the Jena API causes the same behavior.

The code I'm using to submit the query along with the output that is printed to standard out are bundled here
alwu-Oracle
In my test, I only see one query. Please email me your contact information so that I can give you a call.

Thanks,

Zhe Wu
784525
Awesome, your offline help fixed it. Turns out I had the wrong sdordf.jar. The rest of the patch was applied properly, but I had missed that step apparently. This query is executing very quickly now, no flood of SELECTS. Thank you.

Edited by: nyoung on Aug 19, 2010 2:29 PM
alwu-Oracle
Cool. Is the other problem still there?

1115984

Zhe
784525
yes. still truncating results.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 20 2018
Added on May 23 2018
0 comments
124 views