Question { HCL, 57554 }

What are the tables associated with Invoice?

Answer

1) RA_CUSTOMER_TRX_ALL
This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables.
2) RA_CUSTOMER_TRX_LINES_ALL
This table stores information about invoice, debit memo, credit memo, and commitment lines. For example, an invoice can have one line for Product A and another line for Product B. You need one row for each line. Invoice, debit memo, credit memo, and commitment lines are distinguished by the transaction type of the corresponding RA_CUSTOMER_TRX_ALL record.
3) RA_CUST_TRX_LINE_GL_DIST_ALL
This table stores the accounting records for revenue, unearned revenue and unbilled receivables for each invoice or credit memo line. Each row includes the GL account and the amount of the accounting entry. The AMOUNT column in this table is required even though it is null allowed. You need one row for each accounting distribution. You must have at least one (but you can have multiple) accounting distributions for each invoice or credit memo line. Oracle Receivables uses this information to post the proper amounts to your general ledger. If your invoice or credit memo has a transaction type where Post to GL is set to No, Oracle Receivables assigns Null to GL_DATE. If your AutoAccounting is unable to complete your general ledger default accounts using the AutoAccounting rules you define, incomplete general ledger accounts are stored in CONCATENATED_SEGMENTS.
4) AR_PAYMENT_SCHEDULES_ALL
This table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on account credit, or receipt. Oracle Receivables groups different transactions bythe column CLASS. These classes include invoice (INV), debit memos(DM), guarantees (GUAR), credit memos (CM), deposits (DEP),chargebacks (CB), and receipts (PMT). Transaction classes determine which columns in this table Oracle Receivables updates when a transaction occurs, and whether a transaction relates to either the RA_CUSTOMER_TRX_ALL table or the AR_CASH_RECEIPTS_ALLtable. AR_PAYMENT_SCHEDULES_ALL joins to the RA_CUSTOMER_TRX_ALL table for non–payment transaction entries such as the creation of credit memos, debit memos, invoices, chargebacks, or deposits. AR_PAYMENT_SCHEDULES_ALL uses the foreign key CUSTOMER_TRX_ID to join to the RA_CUSTOMER_TRX_ALL table for these transactions. AR_PAYMENT_SCHEDULES_ALL joins to the AR_CASH_RECEIPTS_ALL table for invoice–related payment transactions using the foreign key CASH_RECEIPT_ID. When a receiptis applied,
5) AR_RECEIVABLE_APPLICATIONS_ALL
This table stores all accounting entries for your cash and credit memo applications. Each row includes the amount applied, status, and accounting flexfield information. Possible statuses of your applications include APP, UNAPP, ACC, and UNID. You use this information to determine the applications of your payments or credit memos. CONFIRMED_FLAG is a denormalization from AR_CASH_RECEIPTS_ALL.If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction it is applied against. There are two kinds of applications: CASH and CM (for credit memo applications).


Narendar Chintam
Oracle Functional consultant

Question { 5967 }

What is the use of requition template?

Answer

This feature, accessible through the Supplier Item Catalog,
lets you quickly create requisitions for commonly purchased
items. Buyers create templates that group commonly ordered
items like office supplies into one place.

Source : Oracle Library Document

Question { Wipro, 25254 }

why should we create prorate calender and what is the
difference between depreciation calender and prorate
calender in fixed assets module?

Answer

Prorate Calendar will decide ur company depreciation
policy.

For eg: Your company is purchasing an asset at any date of
a month, but it is going to calculate depreciation from end
date of the month only.

In this case ur prorate will be like this.

From 01-jan-09 to 31-jan-09 -- prorate date is 31-jan-09.

Means if u are purchasing an asset at any date of jan month
ur system starts calculating depreciation from 31-jan-09
Onwards.

Like this u can define ur prorate calendar.

Question { ABC, 29667 }

Expalin TCA architecture, why it was introduced in R12?

Answer

TCA : The summation of all entities, inclusive of partners,
suppliers, and competitors, that are related to your
customers is called a Trading Community

BEFORE TCA :
1.There are multiple customer definitions across the
enterprise.
2.It was very difficult to track current and historical
information about the customers.
3.There was a lack of support for mixed business.
4.It was quite tough to understand relationships between
customers and others (suppliers, partners, competitors)

Trading Community Architecture:
Trading Community Architecture is the implementation of
technology and applications to allow users to create and
maintain relationships among entities. It is a way to
understand who your customer interacts with inside and
outside the enterprise.

The Purpous of Interduce TCA.
1.Create a central repository for the entire E-Business
Suite to store information relating to all members of a
trading community versus separate tables for each member-
Prospects, Customers, Contacts, Employees, Partners,
Distributors, Suppliers, Banks, etc.
2.Record complex business relationships between Trading
Community entities (including 3rd party relationships).
3.Support all business models, industries, and geographies
*** By Using the TCA we can avoide the Duplicity of Trading
Partner records and its also impacted byt the MOAC and
other few concepts where we can use the Suppliers banks and
Customers acrros the Business Unit leve


*** Comments Accepted *****

Thanks ,

Narendar Chintam
Oracle Functional Consultant .

Question { Satyam, 10115 }

what is legacy system

Answer

If your Implementing Oracle Product to your Client in that
if your client using a tool or software product which is
other then Oracle, and if we are pulling the data from that
software to Oracle product we can call it as LEGACY Sytem.

Ex: If Client Currently Using TALLY , and Upgarading his
function with Oracle Product we can call TALLY as Legacy
Product or LEGACY System .

Narendar Chintam

Question { 6399 }

Is it necessary to enable the SECURITY RULE check box along
with CROSS VALIDATION SEGMENT RULE in flex field structure
while setting up the CROSS VALIDATION RULE.
plz clarify my dt

Answer

Security rules for restricted segment values that user can enter during data entry. The list of values will only display that are not restricted by security rules assigned to the responsibility whenever your user logged on as. Security rules can be applied to KFF and DFF.
Cross-Validations Rules are used to define valid flexfield combination. CRV ruled define whether segment values of particular segment can be combined with other segment values of other segment of same key flexfield. CRV can be applied to KFF only. exceptions Inventory flexfields. CRV is required after enabling dynamic insertation

So its not mandatory to enable security rule check along with cross validation segment rule in flexfield structure while setting up CVR rule

Thanks
Narendar Chintam
Oracle Functional Consultant

Question { 5673 }

Re: How to see the structure of organization?ie which LE connected to which ledger and which OU connected to which LE?

Answer

1)Go to Organization and Select your OU Name in LOV,
2)Select your OU name in Organization Classification Window
and Select Others
3) Select Operating Unit Information and click Ok.
4) Hit Tab and Verify the primary Ledger , Legal Context
and Operating Unit Code.