Oracle Application Technical Questions/snippets, Basic Terminology!

Posted by Jiltin     Tags: , , 16 March, 2009    874 views    (0) Comment

What is the interface? Interface Table is a table which is used as medium for transfer of data between two systems. What is INBOUND and OUT BOUND? (Different types of interfaces) Inbound Interface: For inbound interfaces, where these products are the destination, interface tables as well as supporting validation, processing, and maintenance programs are provided. Outbound Interface: For outbound interfaces, where these products are the source, database views are provided and the destination Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags : , ,

How to Search Apps Documents in Google – oracle applications

Posted by Jiltin     Tags: , 16 March, 2009    4,394 views    (3) Comment

1) The following Article shows how to download oracle apps related PPT or PDF documents in Google. open google site in Search box type following string “oracle applications framework” filetype:ppt (shows only PPT files) “oracle applications framework” filetype:pdf (show only pdf files) “oracle applications framework” filetype:doc (shows only doc files) you can found the site contains ppt ,pdf and doc file. 2) Type in searh box “sparsh site: Read Full Article (Click here)...

Categories : Oracle Applications Tags : ,

Installing Oracle database in various Linux operating systems – a step by step approach

Posted by Jiltin     Tags: , , , , 29 December, 2008    1,416 views    (0) Comment

Werner Puschitz is maintaining a web site http://www.puschitz.com/ that provides step by step approach to install oracle database in Linux operating systems. This is very useful for starters who wants to learn the tricks to install oracle in Linux. If you do not have a metalink account , this is the best site to refer. He is up to date on Linux OS. Though the articles are mainly discussing about oracle database on Linux, most of them are common for oracle applications installation. During my Read Full Article (Click here)...

Categories : Reviews Tags : , , , ,

What is auto lockbox in oracle applications?

Posted by Jiltin     Tags: , , , , 18 November, 2008    7,128 views    (1) Comment

Lockbox is a service provided by banks by which your company gets the customers payments directly to a lockbox interface tables and creates receipt for the payments deposited into your account. If you have an Auto Lockbox, the bank records the information that you request such as check number, check amount, numbers and amount for the invoices to be paid. Oracle provides you with the tools to: * Oracle interface tables for the data received from the bank * Validate the data to see if it is Read Full Article (Click here)...

Categories : Receivables Tags : , , , ,

List Reponsibilities for an user

Posted by Jiltin     Tags: , , 12 March, 2008    1,515 views    (4) Comment

I often get this issue to find out list of responsibilities assigned to an user, mainly to review the SOX controls or to enable new responsibilities. Lazy enough to go to System Administrator screen to query it. I always keep the TOAD open session and it is easy to grab the details using this sql. ————————————————————————- —     Author : Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL Tags : , ,