Enterprise Command Center

This chapter provides details on the G-Invoicing dashboard available in the Projects Command Center.

This chapter covers the following topics:

Setting Up RBAC for Enterprise Command Center Dashboard

Projects Command Center Configuration

Setting Up Projects Command Center

The Projects Command Center product configuration setup must be completed after the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, 12.2.

Setup and Configuration Steps

To complete setup of the Oracle Projects Command Center, you must perform the following:

  1. Setting Profile Options

  2. Configuring Descriptive Flexfields for Search

  3. Loading Projects Command Center data

Projects Profile Options

You must set the following profile option for loading data up to twelve (12) months:

Profile Option Name Description
PA: ECC Data Load Month The PA:ECC Data Load Month profile option provides the flexibility of loading data for up to twelve (12) periods for Costing, Capital, Billing, and Financial Flow dashboards. This site level profile option is relevant only for Full load and is not considered for Incremental load. Any modifications to the value of this profile option requires a Full load to be run to display the appropriate data in the dashboards. Behavior of the data load based on this profile option includes:
  • If the profile option is not set, then the application derives the current year based on the calendar setup for the specific Set of Books relevant to the Operating Unit of the Project.

  • If the profile option is set to a period prior to the current period (based on the system date), then the profile option value is considered as the starting period and data for the next 12 months (including start period) will be processed.

  • If the profile option is set to a period after the current period (based on the system date), then the profile option value is considered as the starting period in the previous year and data for 12 months (including the start period) will be processed.

Configuring Descriptive Flexfields for Search

Enterprise command centers support Descriptive Flexfields (DFFs) that enable you to search on DFF attributes. After you configure DFFs, you must run the full data load process, which ensures that the DFF attributes are available in the command center.

For additional information on configuring and customizing flexfields, see the Oracle E-Business Suite Flexfields Guide and My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2.

The following table describes the DFFs available in the Projects dashboards:

Dashboard Data Set DFF Title DFF Name DFF Attribute Group Name
Budgetary Control Dashboard pa-ds-cost-bcbalances Tasks PA_TASKS_DESC_FLEX Task Additional Details
Capital Dashboard pa-ds-cost-eicdl Expenditure Items Tasks PA_EXPENDITURE_ITEMS_DESC_FLEX Expenditure Items Additional Details
Task Additional Details
Costing Dashboard pa-ds-cost-eicdl Expenditure Items Tasks PA_EXPENDITURE_ITEMS_DESC_FLEX Expenditure Items Additional Details
Task Additional Details
Billing Dashboard pa-ds-cost-eicdl Expenditure Items PA_EXPENDITURE_ITEMS_DESC_FLEX Expenditure Item Additional Details
Billing Dashboard pa-ds-cost-eicdl Events PA_EVENTS_DESC_FLEX Events Additional Details
Billing Dashboard pa-ds-bill-revenueinvoice Draft Invoices PA_DRAFT_INVOICES_DESC_FLEX Event or Expenditure Details

Loading Projects Command Center Data

Run the Projects Costing Budgetary Control ECC Data Load, Projects Costing and Billing ECC Data Load, Projects Financial Flow ECC Data Load, and Projects G-Invoicing ECC Data Load concurrent programs to load data for the Projects dashboards. You can navigate to these concurrent programs from the Requests page in Oracle Projects.

Before you load data from Oracle E-Business Suite into the Oracle Projects Command Center, ensure that your EBS data is accurate and current by running any concurrent programs that impact attributes used in the command center.

The Costing dashboard has been designed so that a minimum of one Expenditure Item (EI) is required to display multiple metrics, chart sections, and summary level result tables. For any task level information or project level information to display on the dashboard, you must select a minimum of one EI against the task or project. This also applies to the refinement, as the dashboard is EI based. The refinements on the dashboard or the association of different tables on the dashboard depends on the data in the Overview table.

Run the concurrent program from the Search and Select page.

To load Projects Costing and Billing data

  1. From the Projects menu, navigate to the Search and Select page:

    (N) Projects > Requests > Schedule

  2. Click the New Request button and perform a search for Projects Costing Budgetary Control ECC Data Load, Projects Costing and Billing ECC Data Load, Projects Financial Flow ECC Data Load, and Projects G-Invoicing ECC Data Load. The Search and Select page appears.

  3. Select the button for your specific data load run and then click the Select button. The Schedule Request: Define page appears.

    the picture is described in the document text

  4. Click the Parameters tab.

  5. Select the appropriate Load Type:

    • Full Load: Loads all relevant Projects Command Center data specific to the concurrent program and is required for the first data load. If you select and run full load for subsequent requests, then this program clears all Projects Command Center data specific to the current program from ECC and loads fresh data.

    • Incremental Load: Loads the data modified and updated from the previous load only. Incremental load should be scheduled to run as often as required to keep the ECC dashboard current.

      Note: Any of the following changes are not considered and included for incremental load:

      • PA/GL Period related changes (including period status)

      • Accounting statuses (any progress or rejection in the accounting program for a given transaction)

      • Any modification to an asset in Fixed Assets (Retirement of Asset)

      • Project related changes

      • Task related changes

      • New Task to existing Projects

      • New Budget lines to existing Project/Tasks

    • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must run the program first with the Metadata Load option and then the Full Load option so that the DFF changes are displayed in the command center.

    • Click Select.

    the picture is described in the document text

  6. Enter one or more language codes in the Languages field for the output. For multiple language codes, use the format AA,BB,NN. For example, enter US,AR,KO. If the field is blank, then the data will be loaded for the base language only (usually US).

  7. Select the Log Level that you want the program to report. The default value is Error.

  8. Select True to enable SQL trace. Otherwise, select False.

  9. For the Projects Costing and Billing ECC Data Load program, you can enter an optional Operating Unit or a set of operating units for sequential data loading. This enables you to submit the program and process data for a specific operating unit, or for a set of operating units.

  10. Select an optional value for Reset Dataset. You can extend the existing data set, or reset the entire data set.

  11. Click Continue.

    the picture is described in the document text

  12. From the Schedule Request: Review page, click Submit. The request ID information displays.

  13. Click OK to exit and close the page. The Requests page appears and displays all of your requests. You can click the Details icon to view your request details.

Business Rules and Validation

The Costing dashboard uses the following business rules and validations:

Subject Rule / Validation
Cost consideration for Capital Projects based on project setup to calculate CIP based on Raw cost or Burdened Cost Based on the project setup for Capital projects to calculate CIP on raw cost and burdened cost, the dashboard displays the values accordingly for Metrics, Charts, and other components.
For example, if the CIP Cost Type is 'Raw' for a project, then the ECC dashboard will use raw cost defined on the expenditure budget and vice versa.
Criteria in order for Projects or Tasks to be visible on the dashboard All metrics and data consider only those transactions within three GL quarters. For a project or task to appear on the Costing dashboard, there should exist a minimum of one transaction against that project or task which is either created or updated within three GL quarters.
Recalculation / Adjustment on Transactions When a transaction that is costed and accounted is marked for recalculation, the raw cost and burden cost on the transaction level is nullified, but the accounted information in GL is not nullified.
For such cases, the dashboard represents metrics as described in the following table:
Date Action Uncosted Transactions Total Expenditures Unaccounted Expenditures Value Accounted Expenditures (Projects) Accounted Expenditures (SLA) Accounted Expenditures (GL)
20-Oct n/a 3 20000 4000 16000 16000 16000
21-Oct EI XXX marked for Recalculation (Cost: 2000) 4 2000 4000 16000 16000 16000
22-Oct EI XXX cost Distributed (Cost: 2500) 3 20500 4500 16000 16000 16000
23-Oct EI XXX Accounting Events Generated 3 20500 4000 16500 16000 16000
24-Oct Accounting Complete 3 20500 4000 16500 16500 16000
25-Oct Post to GL 3 20500 4000 16500 16500 16500

The overview results table (accounting related columns) retains old values unless the respective process is run. For example, the cost distribution process may change the PA or GL period, the debit account based on the run date of the concurrent program and the generate costing event program may change the credit account.

G-Invoicing Dashboard

The G-Invoicing dashboard displays G-Invoicing data for all orders. The dashboard provides information to the servicing agency and key members for managing orders and displays G-Invoicing elements that include General Terms and Conditions (GT&Cs), overviews, order details, orders work queue, order deliveries, and EZ invoices metrics across all orders and projects. From the dashboard, you can navigate to individual projects, tasks, and resource assignment levels. Metrics on the dashboard are grouped into the following tabs on the dashboard:

Based on your Role Based Access Control (RBAC) setup, navigate to the Projects Command Center.

As an example, from the Projects SU, US Federal responsibility: Projects Command Center > G-Invoicing (tab)

The following table describes the G-Invoicing dashboard components.

G-Invoicing Dashboard

the picture is described in the document text

Component Description
Summary (tab layout)
GT&C (tab)
The GT&C summary bar displays the following metrics:
  • Currency

    This metric displays the servicing agency currency.

  • Active

    This metric displays the number of GT&Cs with the active status code Open for Orders. Click this metric to further refine the dashboard data.

  • Ordered Value

    This metric displays ordered value calculated as (total estimated amount less total remaining amount). Click this metric to further refine the dashboard data.

  • Remaining Value

    This metric displays the remaining value. Click this metric to further refine the dashboard data.

  • Latest Validity

    This metric displays the most recent dates for valid GT&Cs.

Summary (tab layout)
Overview (tab)
The Overviews summary bar displays the following metrics:
  • Open Order Amount

    This metric displays the total amount of all open orders that are in an open status.

  • Open GT&C

    This metric displays the total number of all opened GT&Cs (GT&Cs in open status).

  • Settled Amount

    This metric displays the total settled amount. This metric does not include advance settled amount.

  • Delivered Amount

    This metric displays the total amount of all delivery performances submitted in G-Invoicing.

  • Trading Partners

    This metric displays the total number of requesting agency accounts.

  • G-Invoicing Communication Issues

    This metric displays push failures to G-Invoicing and are not considered an exception.

Summary (tab layout)
Orders (tab)
The Orders summary bar displays the following metrics:
  • Open Orders

    This metric displays the total number of open orders that are approved from both agencies and have completed the confirmation funds check action. Orders are in an open status. Click this metric to further refine the dashboard data.

  • Pending Approval Orders

    This metric displays total number of orders under review and in progress as follows:

    • Orders pending agreement association (BIOs only)

    • Orders pending project association

    • Orders pending task association

    • Orders pending funds consumption (funds confirmation)

    • Orders pending requesting agency approval

    Click this metric to further refine the dashboard data.

  • Draft Orders

    This metric displays the total number of orders that have been created by the servicing agency (SFO) that are in draft mode and not associated to an agreement. Click this metric to further refine the dashboard data.

  • Closed Orders

    This metric displays the total number of closed orders. Click this metric to further refine the dashboard data.

    Note: This metric also includes pending closed status orders.

  • Pending Approval Modifications

    This metric displays the total number of orders that are in progress with modifications and are not submitted for modification approval. Click this metric to further refine the dashboard data.

  • Draft Modifications

    This metric displays the total number of orders that have been modified by the servicing agency (SFO only). Click this metric to further refine the dashboard data.

  • Rejected by Servicing Agency

    This metric displays the total number of orders rejected by the Servicing Agency. Click this metric to further refine the dashboard data.

  • Rejected by Requesting Agency

    This metric displays the total number of orders rejected by the Requesting Agency. Click this metric to further refine the dashboard data.

  • Orders with Final Performance

    This metric displays the total number of orders in which final performances are submitted for order line schedules within those orders. Click this metric to further refine the dashboard data.

Summary (tab layout)
Orders Work Queue (tab)
The Orders Work Queue summary bar displays the following metrics:
  • Orders in Approval Preparation

    This metric displays total number of orders under review and in progress and includes:

    • Order Pending Agreement Association

    • Order Pending Task Association

    • Order Pending Project Association

    • Order Pending Approval Submission

  • Orders in Approval Queue

    This metric displays the total number of orders for which the task association has been completed and submitted for approval.

  • Orders in Funding Confirmation

    This metric displays the total number of orders that are approved from both agencies and are pending fund confirmation. Click this metric to further refine the dashboard data.

  • Orders in Requesting Agency Approval

    This metric displays the total number of orders pending requesting agency approval (SFO only). Click this metric to further refine the dashboard data.

  • Modification in Approval Preparation

    This metric displays the total number of orders with modifications, but not submitted for approval. Click this metric to further refine the dashboard data.

  • Modification in Approval Queue

    This metric displays the total number of orders with modifications that have been submitted for approval and are pending approval. Click this metric to further refine the dashboard data.

  • Modification in Funding Confirmation

    This metric displays the total number of orders with modifications that been approved and are pending fund confirmation. Click this metric to further refine the dashboard data.

  • Modification in Requesting Agency Approval

    This metric displays the total number of orders with modifications pending requesting agency approval (SFO only). Click this metric to further refine the dashboard data.

Summary (tab layout)
Order Progress (tab)
The Order Progress summary bar displays the following metrics:
  • Open Order Amount

    This metric displays the total value of open orders.

  • Revenue Budget

    This metric displays the total value of budgeted (baseline) revenue for all open orders.

  • Actual Revenue

    This metric displays the total value of revenue incurred from transactions.

  • GL Accounted Revenue

    This metric displays the total value of revenue transferred to GL with successfull final accounting.

  • Unearned Revenue

    This metric displays the total value of invoice transactions that are released and accounted, but with revenue that is not yet generated. This metric applies only at the project level. If the project contains CA/CL accounting, then those values are not included in this metric.

  • Actual Cost

    This metric displays the total value of all costed and distributed transactions (expenditures).

  • Deferred Performance

    This metric displays the total value of outstanding invoices (total invoice amount less total revenue.)

Summary (tab layout)
Delivery (tab)
The Delivery summary bar displays the following metrics:
  • Revenue Budget

    This metric displays the total value of baseline revenue budgets. Click this metric to further refine the dashboard data.

  • Draft Invoice

    This metric displays the total value of released draft invoices. Click this metric to further refine the dashboard data.

  • Receivables Invoice

    This metric displays the total value of receivables invoices once tieback is complete and receivables invoices are created. Click this metric to further refine the dashboard data.

  • Credit Memo

    This metric displays the total value of credit memos for transactions rejected by the requesting agency.

    Note: Total value of credit memos are released from the servicing agency.

  • Delivered

    This metric displays the total value of all deliveries that are submitted in G-Invoicing (summary of pushed-delivered performance). Click this metric to further refine the dashboard data.

  • UnBilled Receivables

    This metric displays the total value of revenue without invoices. Click on this metric to further refine the dashboard data.

Summary (tab layout)
Settlement (tab)
The Settlement summary bar displays the following metrics:
  • Delivered

    This metric displays the total value of all delivery performances that are submitted to G-Invoicing (summary of pushed-delivered performance). The net delivery performance is the sum of all positive and negative delivery performances.

  • Settled

    This metric displays the total value of delivered and settled orders for FOB source, plus the total value of accepted orders for FOB destination.

  • Accepted

    This metric displays the sum of accepted performance value for both FOB source and destination. If the acceptance is not created for FOB source, then it is not considered in this metric.

  • Receipts

    This metric displays the total value of receipts that are created for delivery performance of FOB source, plus acceptance of FOB destination.

  • Receipts Applied on Invoice

    This metric displays the total value of receipts that are applied to the invoices. This metric does not consider prepayment values.

  • Refunds

    This metric displays the total value of all the delivery and acceptance adjustments that are settled, and with adjusted receipts. (Delivery adjustments for FOB source and acceptance adjustment for FOB destination.)

  • Acceptance Adjustments

    This metric displays the total value of all adjustments to the accepted performance.

  • Delivery Adjustments

    This metric displays the total value of all negative delivery performance that is generated from credit memos and standalone invoices.

  • Quality Performance Percent

    This metric displays the percentage of orders that meet acceptable deliverables, and is calculated as (Net Accepted at Schedule level / Net Delivered at Schedule level) * 100

  • Delivery Performance with Pending Adjustments

    This metric displays the total of all delivery performances that require adjustments corresponding to respective acceptance adjustments.

Summary (tab layout)
Advances (tab)
The Advances summary bar displays the following metrics:
  • Advance Order Amount

    This metric displays the total open order value for all advance-enabled orders.

  • Advance Received

    This metric displays the net total advance value requested by servicing agencies that are settled. This metric includes the sum of both positive and negative performances.

  • Advance Receipt Amount

    This metric displays the total receipt value for all settled advance performance. This metric excludes any receipt failure.

  • Advance Delivered

    This metric displays the total net delivery performance value against advance orders.

  • Advance Pending Delivery

    This metric displays the net total value of advance received revenue that has not been delivered.

  • Advance Refunded

    This metric displays the total value of adjusted advance performance against advance-enabled orders.

  • Advance Receipt Refunds

    This metric displays the total receipt value that reflects the adjustment advance performance.

Summary
EZ Invoice (tab)
The EZ Invoice summary bar displays the following metrics:
  • Draft

    This metric displays the total number of EZ Invoices that are in a draft status.

  • Pending

    This metric displays the total number of EZ Invoices that are submitted to G-Invoicing and not settled.

  • Settled

    This metric displays the total number of EZ Invoices with completed settlement and have a receipt associated with it in Oracle. The life cycle is complete from initiation to settlement.

  • In Progress

    This metric displays the total number of EZ Invoices in progress and pending an agreed amount in which delivery has not occurred.

Customer Status (tab layout)
GT&C (tab)
The GT&C Status by Start Date chart displays buying agency details for total ordered amount and total estimated amount based on the active GT&C start date between the servicing agency and the buying agencies. Click on a requesting agency GT&C number in the chart to view the individual GT&C of the selected buying agency and its associated GT&C's with the servicing agency. Click on a Requesting Agency Location Code in the chart to refine the data and display all GT&C numbers that belong to the requesting agency.
The GT&C Status by End Date chart displays buying agency details for total ordered amount and total remaining amount based on the GT&C end date between the servicing agency and the buying agencies. Click on a requesting agency GT&C number in the chart to view the individual GT&C of the selected buying agency and its associated GT&C's with the servicing agency. Click on a Requesting Agency Location Code in the chart to refine the data and display all GT&C numbers that belong to the requesting agency.
Customer Status (tab layout)
Overview (tab)
The Overall Status chart displays the order amounts based on the order completion date and status.
The Activities in the Last 3 Periods chart displays orders for the prior three periods and includes:
  • Total Order Amount

  • Total Advance Amount

  • Total Delivered Amount

  • Total Settled Amount


Click on an order in the chart to refine the dashboard data.
Customer Status (tab layout)
Orders (tab)
The Open Orders by Agency chart displays the total value of orders for each order status against each buying agency with which the servicing agency is conducting business. You can click on an agency order number in the chart or the order value bar to view individual order details between the servicing agency and the buying agency. Click on a Requesting Agency in the chart to refine the data and display all Order Numbers that belong to that requesting agency.
The Order by Status chart displays amounts based on the order start date and approval status. You can click on the Options (ellipses) icon and select dimension values to display order amounts by:
  • Orders by Creation Date

  • Orders by Modification Initiated Date

  • Requesting Agency

  • Order Number


Click on a value in the chart to refine the dashboard data.
Customer Status (tab layout)
Order Work Queue (tab)
The Orders chart displays the internal status of orders and the total order amounts. You can click on the Options (ellipses) icon and select Group Dimension values to display order amounts by:
  • Orders by Creation Date

  • Requesting Agency

  • Order Number


Click on a Work Queue Status value in the chart to refine the dashboard data.
The Modifications chart displays the order modification flow with total order amount based on the Work Queue Status. You can click on the Options (ellipses) icon and select Group Dimension values to display order amounts by:
  • Orders by Modification Initiated Date

  • Requesting Agency

  • Order Number


Click on a Work Queue Status value in the chart to refine the dashboard data.
Customer Status (tab layout)
Delivery (tab)
The Delivery Readiness chart displays orders and total order amounts based on order status. You can click on the Options (ellipses) icon and select Group Dimension values to display order amounts by:
  • Orders by Completion Date

  • Requesting Agency

  • Order Number


The Delivery Status chart displays orders and total order amounts by completion dates.
Customer Status (tab layout)
EZ Invoice (tab)
The EZ Invoice chart displays the total amounts of EZ Invoices grouped by:
  • Approved Amount (Sum) The total value of agreements created for the corresponding GT&C, and the requesting ALCs combination.

  • Draft (Sum) Total value of the EZ Invoices in Draft status.

  • Pending (Sum) Total value of the EZ Invoices in Pending status.

  • Settled (Sum) Total value of the EZ Invoices in Settled status.

  • To Complete (Sum) Total value of the agreements that are associated with the corresponding GT&Cs that have not been delivered.


You can select dimensions to display total amounts for the following:
  • Agreement Number

  • GT&C Number

  • Project Number

  • Requesting Agency Location Code

Customer Status (tab layout)
Advances (tab)
The Advances chart displays displays the total open order amounts for advance-enabled orders, and displays amounts by the following Advance Status values:
  • Advance to be Requested

  • Advance Pending Delivery

  • Advance Delivered

Customer Status (tab layout)
Settlement (tab)
The Settlement Adjustments chart displays the total value of Accepted Adjustments to the order performance by the requesting agency, and the total value of Delivery Adjustments by the servicing agency.
The Settlement Status chart displays total Delivered Amount, Accepted Amount, and Settled Amount for each GL Period based on order performance.
Header (tab layout)
GT&C (tab)
The GT&C results table displays data grouped by GT&C attribute groups. You can view data grouped by:
  • GT&C Information

  • Agreement Amount Information

  • Additional Information

  • Agency Information

  • Preparer Information

  • Requesting Approval Information

  • Servicing Approval Information


You can click the Record Details icon within a selected row to open and view the General Terms & Conditions details window.
You can also click on values in the GT&C Number, Title, Agreement Type, Status, Termination Days, Requesting Group Name, and Servicing Group Name columns to filter and refine dashboard data for the selected values.
Click on the ellipses () icon in the row to open the following action items:
  • Create Order- click to open the Create Seller Faciliated Order UI. This action item is enabled only for those GTCs with the Order Originating Indicator as Servicing Agency.

  • Attachments- click to view GT&C attachments.

  • Create EZ Agreement- click to open the Create Agreement form. This action item is only enabled when the Bizapp attribute is EZ invoice.

Header (tab layout)
Orders (tab)
The Orders results table displays data grouped by Order attribute groups. You can view data grouped by:
  • Order Details

  • Advance

  • Billing and Delivery Information

  • Funding Details

  • Partner Information

  • Performance


You can click the Record Details icon within a selected row to open and view the Order details window.
You can click on values in the columns to filter and refine dashboard data for the selected values.

Note: This results table includes the following action-enabled attributes:

  • Update Agreement - Click on this action to navigate to the Update Agreement page where you can update and create agreements.

  • Create Project - Click on this action to navigate to the Create Project page to create a new project.

  • Associate Project - Click on this action to navigate to the Associate Project window where you can search for and associate projects.

  • View Performance Obligation - Click on this action icon to navigate to the Performance Obligations page to view performance obligation details.

  • View SFO - Click on this action icon to navigate to the SFO page to view the Seller Facilitated Orders (SFO).

  • Admin Modification - Click on this action to navigate to Agreement Additional Attributes for the SFO order. You can edit some attributes in Admin mode depending on the order stage.

  • Push Admin Modification - Click on this action to transfer changes to the G-Invoicing portal. Click on this action to push the admin modification changes to the G-Invoicing portal.

  • Manage Revenue Budget - Click on this action to navigate to the Budgets form.

  • Manage Cost Budget - Click on this action to navigate to the Budgets form.

  • Copy SFO - Click on this action to navigate to the Seller Facilitated Order window.

  • Delete SFO - Click on this action to delete the Seller Facilitated Order. A confirmation window appears where you can delete or cancel this action.

  • View Costing Details - Click on this action to navigate to the View Costing Details window.

  • View Billing Details - Click on this action to navigate to the View Billing Details window.

  • View Budget Details - Click on this action to navigate to the View Budget Details window.


You can also click on the Options link in the table header to perform the following actions:
  • Create Agreement - This action allows you to create agreements manually for those orders that failed to create agreements automatically.

  • Order Modification Uptake - Enables order modifications.

  • Resynchronize Orders - Allows you to push approved orders that previously failed push to G-Invoicing.

  • Close Order - Closes the selected order(s) that are in Pending Close status.

Header (tab layout)
Agreements (tab)
The Agreements results tables displays all of the agreements related to GT&Cs which are EZ enabled.
You can click the Record Details icon within a selected row to open and view the Agreement details window.
You can also click on the Update Agreement action link within a selected row to open the Update Agreement window where you can view and update agreement details.
Header (tab layout)
Exceptions (tab)
The Exceptions results table displays all of the exceptions related to GT&Cs and orders that could not be pulled. It is not specific to EZ enabled GT&Cs.
You can click the Record Details icon within a selected row to open and view the Exception details window.
You can also click on a row level ellipses () icon and choose to Reject or Resync a selected exception.
Details (tab layout)
Order Lines (tab)
The Order Lines results table displays data grouped by Order Line attribute groups.
From the drop-down list, you can select views to display details by:
  • Order Line Details

  • Performance


Click on values in the columns to filter and refine dashboard data for the selected values.
You can also click the Record Details icon within a selected row to open and view the Order Line details window.
Details (tab layout)
Order Line Schedules (tab)
The Order Line Schedules results table displays data grouped by Order Line Schedules attribute groups.
From the drop-down list, you can select views to display details by:
  • Schedule Details

  • Servicing Agency

  • Requesting Agency

  • Performance


You can click on values in the columns to filter and refine dashboard data for the selected values.
Click on the Options ellipses icon link in the table header to perform the following actions:
  • Request Full Advance

  • Submit Deferred Performance

  • Submit Delivery Performance

  • Request Partial Advance

  • Adjust Advance


You can also click on a row level ellipses () icon to:
  • Create Requisition

  • View Costing Details

  • View Billing Details

  • View Budget Details


You can also click the Record Details icon within a selected row to open and view the Order Line Schedule details window.
Details (tab layout)
Performance Details (tab)
The Performance Details results table displays data grouped by performance attribute groups.
From the drop-down list, you can select views to display details by:
  • Performance Details

  • Preparer

  • Receipt


Click on the row level View action link to navigate to the View Performance History page to view performance detail. The page displays by Order Number, Order Line Number, Schedule Line Number, Performance Type, and Accounting Period.
You can click on values within the columns to filter and refine dashboard data for the selected values.
You can also click the Record Details icon within a selected row to open and view the Performance details window.
Details (tab layout)
EZ Invoice (tab)
The EZ Invoice results table displays EZ Invoice data. From the drop-down list, you can select views to display details by:
  • EZ Invoice Detail

  • Requesting Agency and Other Details

  • Servicing Agency Detail


Click on the Update Additional Attributes action link to open the EZ Invoice Additional Attributes form for the selected EZ Invoice (row level). You can update many attributes for the EZ Invoice in this page.
Click on the ellipses () icon in the table header for the following actions:
  • Compare - you can compare selected EZ invoice records.

  • Submit- you can send an EZ invoice to the G-Invoicing application. Only those records that are in Draft status are eligible for this action.

  • Delete - you can delete an EZ invoice only when the EZ invoice status is in Draft or Pending mode.

  • Reverse - you can reverse an EZ invoice after the the settlement. A reversal is only possible for a settled invoice.

  • Reprocess Receipt - you can reprocess a receipt when there is an error on the receipt processing for an invoice or credit memo. This is eligible when the receipt status is in Error, and the receipt number is not updated on the invoice line after processing the receipts.


You can also click the Record Details icon within a selected row to open and view the EZ Invoice details window.

Loading Projects Command Center Data

Before you can use G-Invoicing with EBS, you must retrieve and load the Projects G-Invoicing Enterprise Command Center (ECC) data. Perform the following steps:

  1. From the Home page, select the Projects Super User responsibility.

  2. Select Projects, then Requests, and then Run or Schedule.

    The Submit Request window appears.

  3. Query the concurrent , Projects G-Invoicing ECC Data Load.

    The Parameters window appears.

  4. Enter a value in the System Name field.

  5. From the Load Type list, select either Full Load or Incremental Load.

    • Use a full load to load all existing data into Oracle Projects Enterprise Command Center.

    • Use an incremental load to load only data that has been modified since the previous run. To keep your ECC G-Invoicing dashboard current, you can schedule incremental loads to run as often as required.

  6. Enter a value for the Language code field.

  7. Select a value for the Log Level you want the program to report.

  8. Select a value to set the SQL Trace On.

  9. Click OK.

  10. Click Submit to run the concurrent program.