Lockbox in AR

AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. A lockbox operation can process millions of transactions a month. AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to the bank.  AutoLockbox is a three step process:  1. Submit Import: During this step, Lockbox reads and formats the data from your bank file into AutoLockbox tables using an SQL *Loader script. 2. Submit Validation: The validation program checks data in the AutoLockbox tables for compatibility...

Read more »

Oracle Autoinvoice Interface Tables

AR Invoice Interface Tables RA_INTERFACE_LINES_ALL - This table stores transaction header and line information. - AutoInvoice uses Transaction Flexfields to uniquely identify each transaction that we import  into Receivables. - AutoInvoice always uses the Line Transaction Flexfield structure for both the Link-to and Reference information when importing invoices RA_INTERFACE_DISTRIBUTIONS_ALL -  If we do not use AutoAccounting, we must enter accounting distributions for the transactions. - If the accounting distributions are for transactions that use accounting rules, we must enter the percentages, but not the amounts. - If the accounting distributions are for transactions that do not use accounting rules, we can enter either the percentages or amounts, depending...

Read more »

Sequence Of Firing Triggers In Oracle Forms

Navigational events occur at different levels of the Form Builder object hierarchy (Form, Block, Record, Item). Navigational triggers fire in response to some navigational events in the below order: - Logon Triggers are fired first in below sequence: 1.PRE-LOGON2.ON-LOGON3.POST-LOGON - After that, Pre Triggers are fired 1. PRE-FORM 2. PRE-BLOCK 3. PRE-TEXT-ITEM - After that, WHEN-NEW Triggers are fired 1. WHEN-NEW-FORM-INSTANCE 2. WHEN-NEW-BLOCK-INSTANCE 3. WHEN-NEW-RECORD-INSTANCE 4. WHEN-NEW-ITEM-INSTANCE - After this focus is on the first item of the Block. If we type some data and press the tab key following trigger will fire in sequence 1.KEY-NEXT-ITEM (This trigger is present on the item level). 2.POST-CHANGE (This trigger is present on the item level). 3.WHEN-VALIDATE-ITEM...

Read more »

Applying for an L2 EAD(Employment Authorization Document) on your own

Form I-765 I was talking to a friend recently and she is also working in US with L2 EAD. She had applied for EAD for the first time with the help of the lawyers at her husband's company. Well, it was sponsored by the company itself at that time. She got an EAD in FEB, 2015 for 2 years and she had to apply for renewal a few months back. During the conversation, it came up that she had to pay a $1000 for the renewal. I was surprised because I remember to pay around $400 for the same and then we realized that she had paid the rest for the lawyers' fees. That's why I thought of writing my experience of getting an EAD without paying anything...

Read more »

Kill Session in Oracle

Retrieve session identifiers and session serial number (which uniquely identifies a session's objects): select sid, serial# from v$session where username = 'USER' kill the session: alter system kill session 'sid,serial#' Disconnect the session: alter system disconnect session 'sid,serial#' post_transaction; alter system disconnect session 'sid,serial#' immediate...

Read more »

Collection and Record In Oracle

A collection is an ordered group of elements, all of the same type.  In a collection, the internal components are always of the same data type, and are called elements. We can access each element by its unique subscript. e.g. Lists and arrays. A record is a group of elements, which can be of different types.  In a record, the internal components can be of different data types, and are called fields. We can access each field by its name. A record variable can hold a table row, or some columns from a table row. Each record field corresponds to a table column. PL/SQL has 3 collection types as below: Index-by tables, also known as associative arrays,  are sets of key-value pairs, where each key is unique and is used to locate...

Read more »