Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

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 8.1.7.4.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 11.1.7.0 then my EDI Gateways version is also 11.1.7.0 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


Related Links

Question regarding workflow
mtl_serial_numbers &#38; mtl_serial_numbers_temp
Import Discoverer Content for E-Business Suite Release 12 using adupdeul.sh
xml report for excel output
frm-40502: oracle error: unable to read list of values
ORA-04031:
Apps 11i clone RAC to Non RAC
Runaway Processes in our EBS 11i Server
Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.1)
How to cancel all alert email in WF_NOTIFICATIONS_OUT Queue.
Drive only ouput of a single Concurrent Request to a specific Location .
Questions regarding CM
Data flow in oracle Financials
Password Required to Download the Patch
Oracle Security Alert for CVE-2010-4476
Oracle Applications R12.1.1 Forms not opening in Linux