Thursday, October 29, 2009

Forms customization- About Custom.pll

One can find good info from below links..

Some commands for CUSTOM.pll

For 11i,

To convert from CUSTOM.pll to CUSTOM.pld
f60gen module_type=LIBRARY module=CUSTOM script=YES userid=apps/apps

To convert back from CUSTOM.pld to CUSTOM.pll ( after having edited the text pld file )
f60gen module_type=LIBRARY module=CUSTOM parse=YES userid=apps/apps

To convert from CUSTOM.pll to CUSTOM.plx
f60gen module_type=LIBRARY module=CUSTOM userid=apps/apps

IMP: For R12 files, replace f60gen with frmcmp

Tuesday, October 27, 2009

Different Accounting Closing Period Status

Future: Payables allows invoice entry and accounting in a Future period. Payables does not allow payment entry or payment voiding in a Future period. Payables allows you to limit the number of Future periods based on the number you enter in the Future Periods field in the Financials Options window. After you change the status of a Future period to Open, you cannot change it back to Future.

Open: You can record transactions and account for them in an Open period. You cannot open a period if it is an adjusting period. You define adjusting periods using the Define Calendar window. Adjusting periods can have overlapping dates.

Closed: Payables does not allow transaction processing in a Closed period. You can reopen a Closed period if the corresponding general ledger and purchasing periods are also Open. You cannot close a period in which any of the following conditions exist:
• Outstanding payment batches.
• Future dated payments for which the Maturity Date is within the period but that still have a status of Issued.
• Unaccounted transactions.
• Accounted transactions that have not been transferred to general ledger.

Permanently Closed. Payables does not allow transaction processing in a Permanently Closed period. You cannot reopen a Permanently Closed period.

What is difference between debit memo and credit memo?

Credit Memo: Credit Memos are memos from a supplier representing a credit amount toward goods or services. Credit memos are always negative amounts.
Debit Memo: Debit Memos are invoices you enter to record a credit amount for a supplier who does not send you a credit memo. Always negative amount.

Wednesday, October 14, 2009

What is AWR( Automatic workload repository ) and How to generate the AWR report?

Automatic workload repository is a collection of persistent system performance statistics owned by SYS.
It resides in SYSAUX tablespace. By default snapshot are generated once every 60min and maintained for 7 days by default.

you can generate AWR reports by running SQL scripts:

1)The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids.

2)The awrrpti.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids on a specified database and instance.

3) The awrsqrpt.sql SQL script generates an HTML or text report that displays statistics of a particular SQL statement for a range of snapshot Ids. Run this report to inspect or debug the performance of a SQL statement.

4) The awrsqrpi.sql SQL script generates an HTML or text report that displays statistics of a particular SQL statement for a range of snapshot Ids on a specified SQL.

5) The awrddrpt.sql SQL script generates an HTML or text report that compares detailed performance attributes and configuration settings between two selected time periods.

6) The awrddrpi.sql SQL script generates an HTML or text report that compares detailed performance attributes and configuration settings between two selected time periods on a specific database and instance.

To generate an HTML or text report for a range of snapshot Ids, run the awrrpt.sql script at the SQL prompt:

Few Views which helps while generating the AWR report

retention => 43200, -- Minutes (= 30 Days). Current value retained if NULL.
interval => 30); -- Minutes. Current value retained if NULL.
Creating the Baseline:
start_snap_id => 10,
end_snap_id => 100,
baseline_name => 'AWR First baseline');
Dropping the AWR baseline:
baseline_name => 'AWR First baseline');
Dropping the AWR snaps in range:
Creating SNAPSHOT Manually:
Workload Repository Views:
The following workload repository views are available:
* V$ACTIVE_SESSION_HISTORY - Displays the active session history (ASH) sampled every second.
* V$METRIC - Displays metric information.
* V$METRICNAME - Displays the metrics associated with each metric group.
* V$METRIC_HISTORY - Displays historical metrics.
* V$METRICGROUP - Displays all metrics groups.
* DBA_HIST_ACTIVE_SESS_HISTORY - Displays the history contents of the active session history.
* DBA_HIST_BASELINE - Displays baseline information.
* DBA_HIST_DATABASE_INSTANCE - Displays database environment information.
* DBA_HIST_SNAPSHOT - Displays snapshot information.
* DBA_HIST_SQL_PLAN - Displays SQL execution plans.
* DBA_HIST_WR_CONTROL - Displays AWR settings.

Thursday, October 8, 2009

Legal Entity

The Legal Entity represents a legal company for which the user prepares tax reports. Tax identifiers and other relevant information are assigned to this entity.

Wednesday, October 7, 2009

What is the difference between gl_date,gl_posted?

Gl_date is the date the transaction took place. it can be the date when the journal entry was made or the interface was run to populate this data.
Gl_posted is the date when these entries were posted to gl (usually by running post journal entries program)

What are the journal entries in Procure to Pay Cycle?

1. On Entry of PO ________ No accounting impact
2. On Materil Receipt
Receiving Accural Dr
AP Accural Cr
3. On Completion of Inspection and goods accepted
Inventory Dr
Receiving Accural Cr
The Above mentioned entries in PO Module
4. On entering invoice in AP
AP Accural Dr
Accounts Payable Cr
5. On Payment
Accounts Payable Dr'
Cash/Bank Cr

About MRC and Multi-Org?

What Is AIM In Oracle Financials? Where we can use this AIM?What is Role of AIM while Implementation Project?

AIM is not a Module in ORA Apps like GL AP AR etc . It is an Implementation
Methodology which is recommended by Oracle for the successful Implementation of
Oracle E-Business Suite Projects.
In AIM (Application Implementation Methodology) there will be blank templates
available with the Software which will help us in proper Planning and Systematic
Implementation of the project by filling appropriate templates according to the
Modules we Implement. The concerned documents in general for

Functional: BR100(Setup Doc) TE40(Testing Doc) and MD50(Module Design)
Technical: CV100 and MD70.
You People better catch this Link
www . oracleappsblog . com /index.php/weblog/comments/download-oracle-aim-applications-implementation-methodology-software-paper/
to get AIM Software which contains all the required Doc's.

How to close AP and GL periods?

What is SWEEP Program?Explain Process Of Sweep Program?

This particular program is run in order to transfer un-accounted invioce to next opened period during period end closing of Accounts Payable.
In fact you can't close Payable Period if you have Un-Accounted Invoice in Payables.
In order to negotiate (Transfer) these invoice to next open period this program is run. So that the Payable period can be closed.

Explain if translation is necessary when using multi reporting currency?

First let us see what is Translation? Translation is a process that allows you to restate your financial functional currency into a reporting currency.
Now let us see what is MRC? MRC is a unique feature in Oracle that allows you to maintain and report in more than one functional currency.
So with MRC you can report in more than one currency than why do you have to do translation. If the report is a consoliated report than yes translation is necessary.

What is Automatic Offset ?

  • It is a Accounts Payable feature & quite similar to Intercompany function in General Ledger.
  • It is used to Create multiple Liability lines for the transactions between sister concerns (May be between sister companies).
  • For Ex: Say two companies purchasing goods from same supplier. But When invoice is created only one supplier liability line is created whereas both the companies are liable to pay.
  • Automatic Offset function helps here to create multiple liability lines to balance the journal at balancing level.

    You can set this option at Accounting area of Payable Option.
    There are three radio buttons 1. None 2. Accounts & 3. Balancing under Automatic Offset. On selecting.............

    1. None: No Automatic Offset will be done

    2. Accounts: The distribution line segments will be copied to the liability lines excepting Accounts segment which copied from the liability line itself.

    3. Balancing: Only Balancing segment from distribution line segments will be copied to the liability lines excepting Accounts segment which copied from the liability line itself.

What is the navigation for applying Cross-Validation?

Cross-Validation Rules :cross-validation rules Determain which combination of Valid segment values are invalid regrdless of the user s responsbility.

1.Enable The Cross-Validation Rules at Structure level
Nav:setup > Financials > Flefields > Key > segment.

2.Define the Cross-Validation Rules
Nav:setup > Financials > Flefields > Key > Rules

What you meant Retained Earnings? When the Entries are created and what is the entry?

It refers to the earnings or loss that the company retains at the end of the year/end of the period.
It is basically the portion of net income from end of the year which is retained by a corportation.
If the net income is positive then profits for that period are retained.
If the net income is negative then losses for that period are retained

The Retained Earnings is retained from business or the total profits generated in a financial year which is not distributed to shareholders..

What is flex field qualifier? Explain the types of flex field qualifiers

Oracle Applications require flexfield qualifiers for some of the key flex field structures.

There are total of four segment qualifiers
a) balancing segment
b) natural account segment
c) cost center segment
d) intercompany segment

Balancing segment - determines the segment level at which a balanced financial transaction occurs. Meaning total debits must equal to total credits. Typically COMPANY segment would be your balancing segment.

Natural segment - Natural segment is nothing but the account heads type. In other words natural segment determines the account type. There are five types of account types assets liabilities expenses revenue and owner's equity. Typically ACCOUNT segment would be your natural segment.

Also, Flexfield qualifiers are required for certain key flexfield segments.
For example each accounting flexfield structure requires two segments qualifiers which are balancing segment and natural account segment

What is Budget and Encumbrance ?

What is the difference between Normal calendar and special calendar?

In GL we can define 2 type of calendars. One is Calendar (normal Calendar)and another Fiscal calendar.
Normal calendar uses the year in which an accounting period begin for the system name .
Fiscal Year uses the year in which your fiscal year ends.

In case of special calendars they will defined in AP module as type Recurring invoice payment terms withholding tax key indicator.

Recurring invoice payment terms withholding tax type calendar used for respective transactions as name indicates. Key indicator type calendar used for key indicator report