Answer / sunil kardam

There are three Tables getting impacting while you entering the Invoice in System for R11.

1. AP_invoices_all
2. AP_invoice_distributions_all
3. AP_payment_schedules_all

In R12 there are four tables:-
1. AP_invoices_all
2. AP_invoice_lines_all
3. AP_invoice_distributions_all
4. AP_payment_schedules_all

Answer / bharat

ap_invoices_all
ap_distributions_all
ap_holds_all
ap_interface_rejections

Answer / 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

Answer / altaf a shaikh

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

T means Tested
A means Approved.

When You check 'Approve' check box then in backend Invoice
is match with PO if there is any discrepency then Invoice
goes to HOLD state.

How can we create FSG in another currency other than the currency which is associated with ledger?

1 Answers   Cap Gemini,

---

Define Requition?

3 Answers  

---

Can anybody tell me.i have 3years of experience in a/c's field. but now i am looking for another company(IT field).I have completed pg M.com. In the post 3years of experience in a/c's side. (outof 3 years experience).... first 1years & 3 month of experience in one company and remaining 1.10 years of experience in another company)) I have covered my full details of experience & study. regarding above this particulars. How do I introduce my selfdetails in front of interview time

2 Answers  

---

how to set the interset for the supplier?

3 Answers  

---

Supplier send Material to company as on year end I.e. 31 st march. Company recd the material at store . but invoice not came with material as on 31 st march can company add martial in stock ? what is the entry in stoke and what is the liability to supplier in oracle apps

2 Answers   Yash Technologies,

---

one employee went on site , we given to him 1000 through prepayment . but i final spends amount is 800, then what about remaining 200 , how can we refund to organisation. through debit memo or credit memo, or , prepayment or if any, please give me best solution , if any one know this question answer reply me this mail, nmallioracle@gmail.com

1 Answers   Polaris,

---

what is general ledger in oracle laguege and what are the step for define the journal entry?

3 Answers   Tecumseh,

---

Why shud we run Expense report import programme in AP..where are we importing from??

1 Answers  

---

What is the significance of asset books in FA? Types?

1 Answers  

---

What is use of AP Accounting Periods?

4 Answers   HCL, IBM, TCS,

---

For what kind of necessary information we Interact with Vendors with regard to AP

1 Answers   Genpact, Wipro,

---

Plz some one tell me what does it mean the code SBI, comeing accros while defining the Inventory informations in Purhasing, and what its role

1 Answers  

---