EBS General Discussion
Want to configure Oracle EDI Gateway for Inbound Invoice Interface
Hello, Newbie to Oracle Apps and want to configure Oracle EDI Gateway for Inbound Invoice Interface. We are having Oracle EBS R12 installed on OEL 5.6 Do i need to install EDI Gateway or it comes with APPS R12 installation ? if i have to install it explicitly then which EDI version i have to install ? what are steps should i follow to achieve desired results. One more query, we are having old version of Oracle APPS 6i too, is it possible to configure Oracle EDI Gateway on it ?? You help will be highly appreciated.
Hi; Pelase see below: How to set up EDI Gateway Invoice Inbound 810 Process [ID 90719.1] EDI Gateway Frequently Asked Questions [ID 110514.1] EDI / eCommerce Gateway - Product Documentation [ID 67114.1] Regard Helios
Hi Helios, Thanks for your promt reply, I have gone through those docs and got all steps need to be performed. Now just wanted to ask you that can i use same set of steps to configure EDI gateway for inbound invoice for Oracle Apps version 6i using Database version 18.104.22.168.0. Please guide.
Hi; You need to check prereq. If its mention higer apps version and also db version its mean you need to start to thing&plan upgrade process for your EBS Regard Helios
ok.. As EDI Gateway come with Database, version of Database and EDI Gateway is same, i mean if i am using database version 22.214.171.124 then my EDI Gateways version is also 126.96.36.199 or else? hw can i find version of EDI Gateway ??
Hi Priyanka; You can check this: Oracle EDI Gateway User's Guide and Oracle Payables User's Guide http://download.oracle.com/docs/cd/A60725_05/pdf/ecug.pdf http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/ec/ectop.htm Also see: http://enrichit.com/Upload/Documents/Oracle%20Apps%20Integration%20White%20Paper.pdf Regard Helios
Hi Helios, I have gone through all those documents and got line of action/steps to be performed. Can you guide me regarding how to create the Flat file/Data file to import invoice (810 process)? what fields should it include ? if you would be able to provide any sample Flat file/Data file format then it would be great help.. Regards, Priyanka.
I did all the configurations above. When I run the Import program. I get the following error: The record number P_LO at line 1 is invalid for this transaction. Program level EC_INBOUND_STAGE.MATCH_RECORD_NUM: Please check the log file, correct the problem, and try again. SQL error message ORA-01403: no data found. However, If I add extra 92 charates to each record as bellow: '123<COMPANY_NAME>EDI 123458 ' The Inbound program completes fine. Where is the setup to remove that 92 characters required? Thanks, Pradeep
I did all the configurations above. When I run the Import program. I get the following error: The record number P_LO at line 1 is invalid for this transaction. Program level EC_INBOUND_STAGE.MATCH_RECORD_NUM: Please check the log file, correct the problem, and try again. SQL error message ORA-01403: no data found. Please see (IN: Invoice (810/INVOIC) Fails with Ora-01403: No Data Found [ID 835180.1]). Thanks, Hussein