Monday, June 30, 2014

XML Gateway : Populate the ECX_INBOUND queue from backend

›
Please refer to http://oracleappstoday.blogspot.in/2014/06/create-custom-queue-in-oracle-and-use.html  to learn to use JMS queue as a XML p...
1 comment:

Oracle XML Gateway Tables : The Backend View

›
--Setup Transaction Type - Back-end Tables select * from ecx_transactions; select * from ecx_transactions_vl; select * from ecx_transact...
Friday, June 27, 2014

Create Custom Queue in Oracle and use as pre-queue to other queue

›
In our scenario we setup a JMS queue which will be used a pre-queue to ECX_INBOUND queue. Below are the steps to achieve the same. Queue...
Thursday, June 26, 2014

Common Mistakes : Oracle XML Gateway Map Development

›
TroubleShooting is a very tiresome task in XML Gateway. You can reduce much of the effort by being careful about the below most common mis...
Sunday, June 15, 2014

Query to find the orig system reference for a Customer/Party and other TCA entities

›
If the data was imported into the EBS system from ABC system and ABC's party id was used as the cross system , the below query can be u...
1 comment:

Code for Generic SQL Loader program in Oracle Apps

›
Save the below code as .prog Make sure to create a symbolic link from your script to $FND_TOP/bin/fndcpesr Ex: ln -s $FND_TOP/bin/fndcpes...

XML Gateway ECX Transaction Logs

›
Pre 11.5.10: the logs are directed to a directory present in UTL_FILE_DIRECTORY Post 11.5.10: the logs are maintained using FND_LOGS ...

XML Gateway Inbound and Outbound Process

›
The XML Gateway can be used for Inbound and Outbound Interfacing Inbound flow 1) OTA sends the message to ECX_INBOUND queue. ECX_INB...

Important TCA lookups

›
Lookup for Customer Class code select lookup_type,lookup_code,meaning from ar_lookups where lookup_type in (select class_category from HZ...
Wednesday, May 28, 2014

Customer Conversion/Interface Techniques in Oracle EBS R12

›
These 3 methods can all be used to create customer records. Following are some considerations to help you decide which method to use: Cu...