Oracle Apps Notes

A collection of my random notes, primarily on Oracle Apps

Monthly Archives: September 2011

Airtel ADSL Modem(Beetel) with Linksys Wireless Router

I have an Airtel broadband connection(provided through a Beetel ADSL modem) and two laptops which need to access the connection simultaneously. Instead of asking Airtel to provide me with a solution and overcharge for it, I decided that buying a wireless router(Linksys) and connecting the ADSL modem with it would be more cost-effective.

After spending a frustrating hour trying to get it work and searching the Internet for clues, I finally managed to get it to work. Vikram Sridharan’s post Airtel Beetel Modem + Netgear WGR614 Wifi Router provided the best solution. In his post he used a Netgear router as an example, here are the same steps for a Linksys wireless router:

1. Connect the ADSL modem to your computer and log on to the modem using its IP address(generally it is

2. From the ‘Device Info’ page, note down the Primary and Secondary DNS addresses.

3. Connect the wireless router to your computer and log on using its IP address,

4. In the ‘Network Setup’ section of the ‘Setup’ page, change the Local IP address of the wireless router to and save the settings.

5. Connect to the wireless router again this time using the new IP address(

6.  In the ‘Internet Setup’ section of the ‘Setup’ page, the entries are to be made as shown below.

Internet IP address: Enter an IP of the same series as the ADSL modem, ie, 192.168.1.x. Ensure that x is greater than the number of computers which need to access the connection.

Subnet Mask: Default

Default Gateway: The IP address of the ADSL modem, ie,

DNS1 and DNS2: The values that you noted down in setp#2 from the ADSL modem’s configuration page.

7. Disable the ‘DHCP Server’ option.


Handy Notes-I

Read-only responsibilities in HRMS:

This can be done by setting the Profile Option ‘Profile: HR:Query Only Mode’ to ‘Yes’. This will make forms/functions read-only. This works only for HRMS applications though.

Mail, fax, FTP or print Concurrent Program output in Release 12.1.3:

When submitting concurrent requests, users can now choose to have the request output delivered using Oracle XML Publisher’s Delivery Manager. The output can be automatically emailed, faxed, sent to an IPP printer, or delivered using FTP or SFTP. The ‘Delivery Opts’ button in the SRS window allows the user to specify the details. A very useful feature indeed. For further details, check Brent Lowe’s post.

Sample codes for Customer Interface(RACUST) and TCA API

Customer Interface(RACUST) is a concurrent program that is responsible for the import and update of basic AR-related customer information from open interface tables to AR Customer tables. An import program can be used to format and load date from feeder systems to the open interface tables.

The TCA API is an integrated set of code designed in a highly modular fashion which can be used to insert and update entities in the TCA model with data obtained from various systems. Because of their modular design, TCA APIs offer more easier and specific access to the TCA entities compared to the Customer Interface.

The choice of which one to use ultimately depends on the user and their specific requirements. The following documents might help in making the choice:
Metalink Note#201242.1: TCA Customer Interface & API White Paper
Metalink Note#269121.1: Technical Uses of Customer Interface and TCA-API
Metalink Note#201243.1: Using TCA API’s Including Examples
Oracle Receivables User Guide(for documentation on Customer Interface)
Oracle Trading Community Architecture API User Notes

Sample codes from Metalink for using both Customer Interface(RACUST) and TCA APIs under various scenarios are attached here.

Examples of Customer Interface

Examples of TCA APIs