Question { 2270 }

Can it be set that the GL date is the Sale Order date or
Ship to Date?

Answer

Yes. In Transaction source, there is a field called "Derive Date". If we select this value as YES and if there is no GL date value in interface table (GL date will be blank for ORDER ENTRY source), then auto invoice program uses Ship to date and then Sale Order date. If both these dates are in closed period, then GL date mentioned in Auto invoice parameter will be used.

Note: If "Derive date" field is set to NO and if GL date is null in interface table, then GL date given in Auto Invoice parameter will be used.

Question { 6169 }

Can multiple Sales Orders be invoiced under one Invoice?

Answer

This comes under invoice grouping rules. There are some mandatory grouping attributes like customer, currency and there are some optional grouping attributes like Sales Order.
If Sales order is not added in the grouping rule, then multiple sales orders would be combined (if available for a customer) to create a single invoice. Please note that if Sales orders belong to different customers, then different invoices would be created as customer is a mandatory grouping field.

Question { 3825 }

Grouping Rules and Line Ordering Rules

Answer

Line Ordering Rules
=================
1. Line ordering rules are used only by auto accounting program (obvious - why do we need this rule for manual?)
2. Line ordering rules are needed if there are more than 1 line in the invoice.
3. The ORDER of the lines in the invoice is decided by line ordering Rule (if there are more than one line).
Ex: 1. Based on Sale order number (ascending/decending), then by sales order line number (ascending/decending)
2. Based on line amount (ascending/decending)

Grouping Rule
============
Grouping rule is used to group the interface lines to create invoices. There are some mandatory grouping attributes like customer (ofcourse we can't have same invoice for two customers), currency, etc. If we need to group based on any other field value (other than mandatory ones), then we can define in the grouping rule. In the grouping rule, we need to attach the line ordering rule

The default hierarchy for grouping rule is Transaction source, then Customer profile class and then system options. If not found in all the above, then the seeded value "DEFAULT" is used.

Question { Oracle, 5189 }

What is Tax Structure in US, we set-up in E-business Tax of R-
12 or 11i?

Answer

United States uses SALES and USE Tax. Taxes are applicable at Federal, state level, county level and city level. In EBusiness Tax, We need to create Regime to Rate setup.
1. Create a Regime - In this case, we can create one regime for US
2. Create Taxes. We can create different taxes for Federal, State, County and City. In this setup, control defaults are defined.
3. Create Jurisdictions for each Tax. For state tax, all the states in US will be jurisdictions.
4. Create Tax status and Tax rates.
5. Create Rules. Here we create the on what conditions, the rates are applicable. Ex. Based on bill to customer, balancing segment, etc
Note: In Oracle Fusion, there is a functionality called "Simulation" which can be used to test the tax setup. Once satisfied, we can enable the tax setup for actual transactions.

Question { 2722 }

As a functional consultant how much knowledge i should have
about tools used in oracle apps r12.

Answer

It is better to know the important tables and fields and write simple SQL queries. Also we should know to configure simple form personalization.

Question { 2607 }

In Oracle GL how to review the accounts associated with the
financial statements?

Answer

You can use oracle standard reports like Account Analysis report and Trial Balance report. You can use FSG also.

Question { 3006 }

where does COGS account hit?

Answer

COGS account (Cost of Goods Sold) is entered in the item master for inventory items. When the item (usually Finished Goods) is sold (Sales Order --> Pick Release --> Ship Confirm), COGS account is debited and Inventory account is credited.

Question { Systems Plus, 2526 }

what are the setup from scrap in R12.?

Answer

You want us to explain 1000+ page documents....I could not see any attachment facility in this forum...Please go through oracle documents and also setup documents available in many blogs....If you have any specific issue, then you may post it here....

Question { 5536 }

what are flexfields in Asset?

Answer

Few additional Info...
1. Category FF - This is one of the important flexfield is Assets as category-Asset book combination is used to define the accounting information.
2. Location FF - Location flexfield is used to capture the physical location of the assets
3. Asset Key FF - Asset Key flexfield is used to store the general information. As it is a mandatory FF, we need to define one segment with a default value, if it is not used by the deploying company.

Question { 4385 }

what is steps include after mapping in consolidation process?

Answer

Consolidation is a process of transferring accounting details (in detail or summary) from two or more ledgers to a consolidation ledger. The process is as follows.
1. Create a mapping - Choose the subsidiary ledger and parent ledger and define mapping. Here we can use either segment mapping or account mapping or both. In segment mapping, we need to do mapping for each parent segment. The available options are
a) CONSTANT VALUE (usually done when there is no corresponding segment in
subsidiary ledger)
b) COPY VALUE FROM - directly copy values from subsidiary to parent
c) Roll up Rules - Here we can combine certain range of subsidiary values to one
parent value.
2. Create a consolidation set and and add all the mappings so that we can perform consolidation at one go.
3. Create Elimination set for eliminating intercompany transactions.
4. Run Consolidation
5. Import from GL Interface (Optional - Not necessary if import to GL is set as YES in mapping definition)
6. Post the journals in Parent ledger (Optional - Not necessary Post in GL is set as YES in mapping definition)
7. Run Reports in Parent Ledger

Question { Arihant, 2637 }

2. what is receipt method.

Answer

Receipt methods gives the details on how customer makes payment like through check or electronic, etc. For a receipt class (receipt class decides the "Routing" of the receipt. i.e manual/auto, remit/no remit, clearing/no clearing), we can define one or more receipt methods. For each receipt class and receipt method combination, we can define one more bank accounts and accounting information.

Question { Arihant, 5176 }

6. TDS accounting entry

Answer

When vendor invoice is created,
Accrual A/C - Dr
Liability A/C - Cr
TDS payable A/C - Cr

When vendor invoice is paid,
Liability A/C - Dr
Bank/Cash A/C - Cr

When vendor invoice is validated, system will also create TDS invoice for TDS Authority.
For TDS Invoice,
TDS Payable A/C - Dr
TDS Liability A/C - Cr

When TDS Invoice is paid,
TDS Liability A/C - Dr
Bank/Cash A/C - Cr

Question { 2102 }

in payable module mandatory setup.

Answer

Perform the following steps
1. Complete the organization structure till inventory org. Also complete the COA valeset values
2. Complete the profile option setup (Ledger, OU/Security profile) for the responsibilities
3. For each OU, complete Payable options, Financial options, Payable
4. Create Suppliers and Sites
5. Create Bank, Branch, Bank account and Payment Documents
6. Create Payment Process Profile setup
7. Open Payables Period for the current period

Note: There are other setups which are not mandatory like Tax setup, approval setup, etc. If taxes are applicable, then we need to perform tax setup. Also we can use payment terms seeded values. We can add, if required.

Question { 1981 }

payable new features

Answer

High level changes Between R11 and R12....(my memory is poor w.r.t R11)
1. Major revamp in Payment batch processing (Funds disbursement activities)
2. Centralised Bank Model - Owner of Bank creation is now Cash Management and Role based access to create Banks
3. Tax module is centralized.
4. Oracle Subledger Accounting module takes care of the accounting for all the subledgers
5. Multiple Organization Access Control feature (applicable to other modules as well)
6. New trial balance report and few other XML based reports

Between R12 and Fusion
====================
1. Role based access - Responsibilties and menus are removed and access is given based on the role. There are few seeded roles and we can also create custom roles (Applicable to all modules. In Fusion, the name module is changed to "Offering"...It is now called as Payables Cloud, Receivables Cloud, Expense Cloud, etc)
2. Invoice Image processing - Invoices can be scanned and the scanned file is sent to a mail id (provided by Oracle). As soon as the file is received in the mail id, Oracle reads the data in the file and invoice is created (I have not used this feature, yet to see how it works in reality)
3. Cross-currency payments - Invoice currency and Payment currency can be different. i.e payment can be done in a different currency other than invoice currency
4. Cross BU Payment (Operating Unit is termed as Business Unit) - Invoice BU and Payment BU can be different (Both OUs should be under one ledger).
5. Complex withholding tax configuration using Tax Cloud. (Withholding configuration can be done either in payables cloud (for simpler ones) or in Tax cloud (for complex requirements)
6. All expense reports should be entered in Expense cloud and then imported into Payables Cloud. We can NOT enter expense reports directly in payables cloud.
7. Rapid Implementation feature - Important setups can be extracted easily from one environment as excel file and then imported into another environment (There are few restrictions also)
8. There is a change in approval setup.

Question { 1931 }

in payable module journal entries

Answer

Journal entries for P2P process is explained in many blogs...Just google it...