My Portfolio

The GL reconciliation report works on the following principles  a. Payments which have been credited into the GL Cash Account but not  Reconciled against a Bank Statement Line in the current period - these  payments are deducted from the Bank Statement Closing Balance.  b. Payments which have not been credited into the GL Cash Account but are  Reconciled against a Bank Statement Line in the current period - these  payments are added to the Bank Statement Closing Balance.  c. Payments which have not been credited into the GL Cash Account and are  not Reconciled against a Bank Statement Line but appear on a Bank Statement  in the current period - these payments are added to the Bank Statement  Closing Balance.  Please note that transactions available for reconciliation is very different  from GL report on the principles listed above.  The accounting is only done for the payment creation, ie, accounting line  only for AE...

Project and Subledger Links In this Article we will look at how to link the data between Oracle Projects with the SLA module. After Generate Accounting Events is run the acct_event_id in the pa_cost_distribution_lines_all table will be populated with the accounting event id in the SLA. So using this acct_event_id column we can easily get to the XLA Tables. For the Cost Distribution lines, we can link the acct_event_id directly to the Xla_events table. Example: Lets say my expenditure item id is 123456. Query to Find the XLA Events for the above expenditure item: 1 2 3 4 5 SELECT * FROM xla_events WHERE event_id in ( SELECT DISTINCT acct_event_id FROM pa_cost_distribution_lines_all WHERE expenditure_item_id = 123456); To select cost distribution line data where the process status on the associated accounting event is ‘I’ (Invalid). Other process statuses that might be of interest: E=Error, U=Unprocessed, R=Related Event in Error: To select cost distribution line data where t...