FSG is a powerful and flexible tool you can use to build your own custom reports without programming. FSG is only available with GL.

shahed mohiuddin

• Mar 5th, 2007

Oracle Apps std reports does not support for reports such as Income Stmt and Final A/c.So we need to go for FSG to prepare Reports Such as P&loss stmt and balance sheet.FSG is Powerful tool for Reporting.Reporting with FSG is Mix and Modify Reuse and Recylce Activity.

chittid

 Profile Answers by chittid Questions by chittid

• Mar 28th, 2006

Financial Statment Generation (FSG), we can create different financial statement and we will get finacial reports. RegardsD.Chitti babu

Answer Question  Select Best Answer

Abhinav

• May 22nd, 2007

These are the tables which come into picture after 11.5.9 because of the TCA. HZ stands for Human Zone(HZ_). Anytihing which is related to the human like Customer profiles, their accounts, locations, relationships are stored in these tables only.

Sandeep S

• Aug 9th, 2005

All tables that starts with HZ_ are related to the Trading Community Architechture (TCA). In these table we can find all the information about the Customers, Organization, Person's.  From releas...

Answer Question  Select Best Answer

what is the difference between Negative and positive adjustments?

sudha

• May 30th, 2017

Invoice is for = 1000 and Customer paid Receipt = 800 here Negative Adjustment
Invoice is for = 800 and Customer paid Receipt = 1000 Here Positive Adjustment

Sanjay Khandelwal

• Jul 14th, 2015

Negative Adjustments are the adjustments where we have to apply any adjustment on the Credit Memo. However the positive adjustment is for the application on Invoices.

Answer Question  Select Best Answer

How do you adjust encumbrance with a standard invoice?

viren56

 Profile Answers by viren56 Questions by viren56

• Oct 20th, 2011

Disagree wirh RVS123,
Encumbrance fund can never be reserved for planned expenditure.

RVS123

 Profile Answers by RVS123 Questions by RVS123

• Jun 22nd, 2009

In Oracle Applications, encumbrances are used with only AP-PO-GL modules and not AR. Budgets are created in GL. Typically, encumberances are used to reserve funds for a purchase you are going to make ...

Answer Question  Select Best Answer

Asif

• Sep 15th, 2011

_ALL : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating un...

Jampani

• Sep 10th, 2007

_ALL : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating un...

Answer Question  Select Best Answer

Aparna

• Jun 4th, 2007

Conversions and Interfaces are both transferring the data into oracle Base tables. But the only difference is that Conversion is one time activity whereas in Interfaces, we update the oracle Base tables on regular basis.

Ram

• Jan 9th, 2007

Conversition is on time process this is before instlation, and interface every time process we can run any time.

Answer Question  Select Best Answer

To import receits from a bank file using lockboxes.

viren56

 Profile Answers by viren56 Questions by viren56

• Mar 12th, 2010

Auto Lockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. ARLPLB (auto lockbox program) imports, Validates and loads the payment receipt recor...

HARI KUMAR . K

• May 5th, 2007

Lock box is enabled to import the receipts from bank filethere are three steps in process1. Import: in this step it reads and formats the data transferring to interface tables2. Validations: here it w...

Answer Question  Select Best Answer

sudha

• May 30th, 2017

AR Setup Responsibility-> Setup->Financial->Flexifields

Arun

• May 1st, 2015

Customer Territory KFF is owned by receivables. Receivables provides a default structure for this KFF.You can define up to twenty segments for this structure in the Key Flexfield Segments window 1) ...

Answer Question  Select Best Answer

Ameen

• Aug 22nd, 2011

1.first check the Transactions for the period being closed. 2.Reconcile transaction activity for the period. 3.Reconcile customer outstanding balances 4.Review unapplied receipts register 5.Run Receip...

esayyed

 Profile Answers by esayyed Questions by esayyed

• Jun 23rd, 2010

Process to close the Period in AR.1) Complete the transactions2) Apply receipts against the transactions3) Run the Create Accounting program to transfer the subledger data to XLA and to GL4) Run the U...

Answer Question  Select Best Answer

What is the use of auto-invoice, accounting rules? why these are define in oracle receivables ?

lathasekhar

 Profile Answers by lathasekhar Questions by lathasekhar

• Mar 22nd, 2012

Hi Alfred, Auto-invoice is a program that can be used to import and validate transaction data from other financial systems from which one can create invoices, debit memos, credit memos, and on-accou...

aksharma.excise

 Profile Answers by aksharma.excise Questions by aksharma.excise

• Feb 17th, 2012

Dear Mr. Alfred, I little bit disagree with your answer that account value is defined that which value is to credited or debited. But sorry to say in my opinion As per Accounting Rules, Account Head ...

Answer Question  Select Best Answer

What is the difference between auto invoice and auto lock box

sudha

• May 30th, 2017

Auto Invoice : Invoices we are creating Automatically by running Auto invoice master program and Auto invoice import program. Auto lock box setups we are doing for creating and applying receipts where ever it is matching (Like Sales order number and Customer name and Amount etc)

Biswajit Datta

• Apr 24th, 2014

AutoLockbox is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.
AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank

Answer Question  Select Best Answer

The Multi Reporting Currency Feature allows you to report and maintain records at the transaction level in more than one functional currency. You can do by defining one or more set of books in addition to primary set of books.

sudha

• May 30th, 2017

Multi Reporting currency ledger is for converting Foreign currency transactions into functional currency.

ajith kumar s

 Profile Answers by ajith kumar s Questions by ajith kumar s

• Nov 9th, 2012

MRC is nothing but multiple currency by using the MRC can record and maintain the transaction more than one functional currency its works at transaction level in 11i upto 8 currencies we can use in R1...

Answer Question  Select Best Answer

sudha

• May 30th, 2017

11i we use to call like set of book 8 currencies we can assign

Rafi

• Dec 17th, 2015

In R12, we can attach n number of reporting ledgers....

Answer Question  Select Best Answer

Govardhan

• Aug 8th, 2017

Party might be a Organization or Individual person. Every party will become a customer who can place an order.

vadivel

• Jun 16th, 2017

Customer is who purchased goods from our company. Party is who seeks information about products.

Answer Question  Select Best Answer

AMEEN

• Aug 22nd, 2011

Auto invoice is a facility provided by Oracle Receivables, that the transactions in Legacy system can be taken in to Receivables through interface.. To setup auto invoice you need to ensure the syste...

viren56

 Profile Answers by viren56 Questions by viren56

• Mar 12th, 2010

Considering the volume of transactions involved, it is not always feasible to create all the invoices manually. To overcome this Oracle AR provides a standard program called RAXMTR (Auto invoice Maste...

Answer Question  Select Best Answer

Answer posted by Goli on 2005-05-19 20:20:27: Value sets are the defined as list of possible values for a specific purpose. These are assigned to flexfields. These are the only possible values to be choosen from. This eliminates the data entry errors. Ex: COSTCENTER segment in accounting flexfield can have a values set of 1 to 10. You define a valueset as cc_valSet, per say, and assign it to the...

balaji

• Nov 16th, 2011

valuset is nothing but list of values wth validations.it wil restrict the user to enter valid values

There are 8 types of valueset

1.None
2.Dependent
3.Independent
4.special
5.pair
6.Table
7.Translate Independent
8.Translate Dependent

kals_kals90

 Profile Answers by kals_kals90 Questions by kals_kals90

• Nov 3rd, 2009

Value set is nothing but set of rules or conditions or properties or attributes which are going to enforce or attach to the segments upon attaching value set to the segment your segment behave according to the value set.

Answer Question  Select Best Answer

sudha

• May 30th, 2017

Sales tax location key flexifields and Territory key flexifields two Types

ajith kumar s

 Profile Answers by ajith kumar s Questions by ajith kumar s

• Nov 9th, 2012

In R12 we have 2 key flexifields and those 2 are optionals

1) Sales tax location key flexield: this flexfiled is used to calculate tax based on the location wise
2) Territory key flexfiled: By using this key flexfield we can find out the the sales information based on the location wise

Answer Question  Select Best Answer

ramu

• Jul 28th, 2017

If i select as Site in auto accounting for revenue, where to define the GL account string in Customer Site screen?
Please email me the navigation

Ramu

• Jul 28th, 2017

To derive Revenue Accounting, I have setup as Site customer Bill-To site. But I am not finding where to define the accounting string at customer site to fetch by auto-accounting for revenue

Answer Question  Select Best Answer

sudha

• May 30th, 2017

7 types of invoices we can see in AR module. Like Standard Invoice, Debit Memo and Credit Memo, Deposit Invoice, Guarantee, Charge Back Invoice and Accounts Receivables.

sruthi

• Mar 16th, 2015

By using auto invoice automatically generate accounting entries for receivables
By using auto lock box we can create receipts creation automatically

Answer Question  Select Best Answer