Answer Posted / altaf a shaikh

When a Invoice is created basically following tables are
populated :-

1. AP_INVOICES_ALL -- Invoice Header Information
2. AP_INVOICE_DISTRUBUTIONS_ALL -- Line details
3. AP_PAYMENT_SCHEDULES_ALL -- When term is assigned
while creating invoice then automatically Payment schedule
is create based on term (e.g 30 Net)
4. AP_TERMS_ALL
5. AP_DISTRIBUTION_SETS_ALL -- If You select distribution
set to create Invoice Lines Automatically for You.

---------------------------------------------------------
When You Approve the Invoice then MATCH_STATUS_FLAG of
AP_INVOICE_DISTRIBUTION_LINES is updated to T.

when You Account Invoice then Following Tables are
popullated :-
These below mentioned tables store data for Invoice as well
as payments so please check source of the transaction
created in these tables.

There are two columns in lines table whcih can be used to
track these transactions in GL Module. That are
gl_sl_link_id and gl_transfer_flag = Y

6. AP_ACCOUNTING_EVENTS_ALL
7. AP_AE_HEADERS_ALL
8. AP_AE_LINES_ALL

Once "Paybles Transfer to Gl concurrent" program is
executed then, all the accounted enteries with
gl_transfer_flag <> Y will be populated in GL_INTERFACE
table.

If Journal Import with Source = Payables is executed then
data is populated in
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES

Then Posting populates this data into
GL_BALANCES

[If there are 25 lines in a GL_JE_LINES for a particular
CCID in a month DEC-09.
Then only one line is created in GL_BALANCES table for that
particular CCID in DEC-09. This lines has sum of amount of
all the 25 lines of GL_JE_LINES)

When You Make a Payment for a Invoice then following tables
are populated :-

9. AP_CHECKS_ALL
10. AP_INVOICE_PAYMENTS_ALL

When You do accounting of payment then again accounting
tables are populated as specified above i.e.


6. AP_ACCOUNTING_EVENTS_ALL
7. AP_AE_HEADERS_ALL
8. AP_AE_LINES_ALL


Remaining process is same as discussed above.
In this case Journal Source = Payment

While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.

2852

---

How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12

7383

---

Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.

2286

---

How to do the analysis of discounts lost and fixing the root cause?

1158

---

explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.

2580

---

SLA usage ans how to define setups?

2708

---

difference between tds and income tax (India)

1909

---

can we define 2 different currency revaluation at a time??

2336

---

what is the meaning of purchase default and what are the types

2230

---

I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.

5310

---

please explain with examples the below mentioned "Creating the end to end business scenarios and executing the scenarios to perform the regression testing".

2243

---

Explain about Localization (IND & US ) in Oracle Apps ?

3150

---

What is the meaning holding tax?

1099

---

What is gap analysis, what are the pre-requisities?

1243

---

What is the Use of Grouping Rule in Receivables ? is it mandatory field ?

1541

---