Interfacing Costs and Revenue to Oracle General Ledger
You use processes to collect all eligible costs and revenue in Oracle Projects and interface them to Oracle General Ledger. When you interface costs and revenue to Oracle General Ledger, Oracle Projects collects all eligible distribution lines, and if enabled, the employee summarization tables, with the cost and revenue amounts.
Oracle Projects summarizes detail lines into summary interface lines and places the summarized information into an Oracle General Ledger interface table. Oracle Projects summarizes detail lines by Code Combination ID (CCID), GL Period, and Journal Entry Source.
Note: Items must be costed and revenue distributed before you can interface them to Oracle General Ledger.
GL Date
The GL Date of the cost or revenue determines the accounting period in which a transaction is posted to a general ledger account. In Oracle Projects, for cost and revenue, the GL Date is the end date of the earliest open or future GL Period on or after the PA Date of a cost distribution line or a draft revenue.
Oracle Projects determines the accounting period by comparing the PA Date to the ranges of dates you have defined for your accounting periods in Oracle General Ledger.
See: Date Processing in Oracle Projects
Accounting Transactions
When you interface revenue to Oracle General Ledger, Oracle Projects uses AutoAccounting to determine the accounts for unbilled receivables and unearned revenue. Oracle Projects also uses AutoAccounting to determine the liability account for each type of cost you interface (such as labor or usage). The accounting transactions that the process creates are interfaced to Oracle General Ledger interface tables.
See: Accounting Transactions
Output Reports
Each time you interface costs and revenue to Oracle General Ledger, Oracle Projects prints output reports which allow you to track your successfully interfaced costs and revenue, as well as those distribution lines which fail to interface. You should correct any exceptions and resubmit the process to successfully import rejected items.
