Oracle Public Sector Financials (International) User Guide

Products

International Implications

Oracle Public Sector Financials (International) Features

Budgeting Extensions

Commitment Budgetary Control

Construction Industry Scheme

Contract Commitment

Dossier

Exchange Protocol

Generic Interface

Hierarchical Drill-Down Inquiry

Inflation Accounting for Assets

Installment Terms

Internal Trading

Secondary Invoice Approval

Single Third Party

Standing Charges

Subledger Security

Oracle Public Sector Financials (International) Features Removed

Create Budget Journal Procedures

Overview

Prerequisites

Create Balanced Budget Procedures

Create Balanced Budget Batch

Enter Balanced Budget Batch Journal Lines

View Balanced Budget Period Amounts

Complete the Batch

Balanced Budget Journals Window Description

Journals Window Description for Balanced Budget

Periods Window Description for Balanced Budget

Create Unbalanced Budget Procedures

Create Unbalanced Budget Batch

Enter Unbalanced Budget Batch Journal Lines

Enter Unbalanced Period Amounts

Complete the Batch

Unbalanced Budget Journals Window Description

Journals Window Description for Unbalanced Budget

Periods Window Description for Unbalanced Budget

Maintaining Budget Procedures

Overview

Prerequisites

Reprofiling a Budget Procedure

Submit Budget Reprofile Window Description

Applying Budget Indexation Procedure

Submit Budget Indexation Window Description

Creating a Next Year Budget Procedure

Submit Budget Next Year Create Window Description

Budget Impact Inquiry Procedure

Budget Process Impact Inquiry Window Description

Impact Details Window Description

Budgeting Extensions Process

Definition

Overview

Budgeting Extensions Process Flow Diagram

Setting Up Budgeting Extensions

Enable Budgeting Extensions in the Application Object Library

Define Profile Codes

Define Reason Codes

Define Accounting Combination Budget Control Settings

Define Budget Extension Profile Options

Define Budget Range Codes

Entering Budget Journals

Maintaining Budgets

Next Year Budgeting

Budget History Inquiry Procedures

Overview

Budget History Inquiries

Public Sector Variance Inquiries

Prerequisites

Budget History Inquiry Procedures

Performing an Inquiry Using the Budget History Inquiry Window

Performing a Variance Inquiry Using the Extended Account Inquiry Window

Budget History Inquiry Window Description

History Entries Window Description

History Periods Window Description

Extended Account Inquiry Window Description

Variance Window Description

Import Budget Spreadsheet Procedures

Overview

Prerequisites

Feeder Files

Sheet Headers

Sheet Lines

Feeder File Format Description

Importing Budget Spreadsheet Procedure

Create a Data File

Load a Data File

Extract Data from File

Submit Budget Spreadsheet Extract Window Description

Budget Reports

Overview

Generating Budgeting Extensions: Balanced Budget Journal Input Proforma

Generating Budgeting Extensions: Balanced Budget Journal Input Proforma Report Description

Generating Budgeting Extensions: Balanced Budget Journal Report

Generating Budgeting Extensions: Unbalanced Budget Journal Report

Generating Budgeting Extensions: Process Impact Review and Budgeting Extensions: Process Impact Review Summary Reports

Generating Budgeting Extensions: Profile Code Listing Report

Generating Budgeting Extensions: Range Code Listing Report

Generating Budgeting Extensions: Reason Code Listing Report

Generating Budgeting Extensions: Maintain Code Combination Budget Control Flag Report

Generating Budgeting Extensions: Balanced Budget History Report

Generating Budgeting Extensions: Unbalanced Budget History Report

Commitment Budgetary Control Process

Overview

Commitment Budgetary Control Process Description

Commitment Budgetary Control Procedures

Overview

Funds Available

Account Inquiry

Journal Inquiry

Review Results of Contract Commitment and Budgetary Transactions

Querying Funds Available Procedure

Commitment Budgetary Control Funds Available Inquiry Window Description

Querying Accounts Procedure

Commitment Budget Account Inquiry Window Description

Summary Balances Window Description

Detail Balances Window Description

Journals Window Description

Journals Window, Full Window Description

Querying Journal Entry Procedure

Commitment Budget Journal Inquiry Window Description

Commitment Budget Journal Lines Window Description

Commitment Budgetary Control Integration with Oracle Purchasing

Definition

Overview

Accounting Date

Single Year Validation

Funds Checking and Reservation

Journal Creation

Year End Process

Prerequisites

Purchasing Window Modifications

Approve Document

Approve Document Window Description

Purchasing Menu Modifications

Purchasing Process Modifications

MassCancel

Year End Process

Construction Industry Scheme Process

Definition

Process Flow Diagram

Process Description

Construction Industry Scheme Procedures

Definition

Overview

Legislation

Documentation

Certificate Type Requirements

Payments and Voucher Requirements

Features

Prerequisites

Subcontractor Verification

Subcontractors Payments

Monthly Returns

Submitting Monthly Returns Online

Submitting Monthly Returns Manually

Resubmitting the Monthly CIS Return

Construction Industry Scheme Report Procedures

Overview

Construction Industry Scheme: Monthly Returns Report

Construction Industry Scheme: Registered Supplier Listing Report

Construction Industry Scheme: Subcontractor Verification Status Report

Construction Industry Scheme: Subcontractor Statement of Payment and Deductions Report

Contract Commitment Process

Overview

Set Up Contract Commitment

Create and Maintain Contract Commitment

Execute Document Control

Reporting Currency

Summarize Contract Commitment

Internal Contract Commitment Matching

Processes

Reporting

Matching Invoices to Internal Release Contract Commitments Process Flow Diagram

Matching Contract Commitments to Invoices Process

Enter, Encumber, and Approve Cover Contract Commitments for Internal Purpose

Enter Invoice Header Information into the Oracle Payables Invoice Workbench

Create Internal Release Contract Commitments

Match Invoices to Internal Release Contract Commitments

Complete the Internal Contract Commitment Releases

Contract Commitment Account Generator Process

Definition

Overview

Account Generator Features

Customizing the Account Generator in Contract Commitment

Generate Default Account Process

Subprocesses

Contract Commitment Account Generator Workflow Item Type Attributes

Generate Default Account Workflow Diagram

Generate Default Account Workflow Process

Start Generating Code Combination (Node 1)

Is Charge Account CCID Null? (Node 2)

Generate Default Charge Account (Node 3)

Abort Generating Code Combination (Failure) (Node 4)

Is Encumbrance On? (Node 5)

Generate Default Budget Account (Node 6)

Abort Generating Code Combination (Failure) (Node 7)

End Generating Code Combination (Success) (Node 8)

Generate Default Charge Account Workflow Diagram

Generate Default Charge Account Workflow Subprocess

Start Generating Code Combination (Node 1)

Is Project Contract Related? (Node 2)

Generate Project Account (Node 3)

Abort Generating Code Combination (Failure) (Node 4)

End Generating Code Combination (Success) (Node 5)

Abort Generating Code Combination (Node 6)

Generate Default Budget Account or Project Account Workflow Diagram

Generate Default Budget Account or Project Account Workflow Subprocess

Start Generating Code Combination (Node 1)

Dummy Default Account Generator (Node 2)

Abort Generating Code Combination (Node 3)

Validate Code Combination (Node 4)

End Generating Code Combination (Node 5)

Contract Commitment Approval Workflow Process

Overview

Contract Commitment Workflow Item Type Attributes

Contract Commitment Approval Process Workflow Diagram

Contract Commitment Approval Workflow Process

Start (Node 1)

Select Approver (Node 2)

Notify Approver (Node 3)

Check Approver Authority (Node 4)

Funds Reservation Required (Node 5)

Approve Contract (Node 6)

Notify Preparer About Approval (Node 7)

Reject Contract (Node 8)

Notify Preparer About Rejection (Node 9)

Execute BC (Node 10)

BC Failed (Node 11)

Notify Preparer BC Failed (Node 12)

Failed Process (Node 13)

Notify Preparer About Error (Node 14)

End (Node 15)

Customizing Contract Commitment Approval Workflow

Required Modifications

Optional Customizations

Creating a New Custom Process

Maintain Contract Commitment Procedures

Overview

Contract Commitment Information

Execute Budgetary Control

Guarantee Commitments

Contract Commitment Approval

Adjust Contract Commitment

Version Control

Contract Commitment Actions

Action History

Security

Creating a New Contract Commitment from a Template

Summarize Contract Commitment

Entering General Information Procedure

Contract Commitments Window Description, General Tab

Entering Accounting Information Procedure

Contract Commitments Window Description, Accounting Tab

Entering and Viewing Payment Forecast Information Procedure

Contract Commitments Window Description

Execute Budgetary Control Procedure

Encumbrance Window Description

View Results Window Description

Approving a Contract Commitment Procedure

Approval Window Description

Approving Contract Commitment Workflow Procedure

Transitioning a Contract Commitment Procedure

Transition Window Description

Changing a Contract Commitment's Control Status Procedure

Control Window Description

Creating a Contract Commitment from a Template

Find Contract Commitment Window Description

Copy Contract Commitment Window Description

Summarizing and Modifying a Contract Commitment Procedure

Contract Commitment Summary Window Description

Viewing Contract Commitments History Summary Information Procedure

Internal Release Contract Commitment Procedures

Definition

Overview

Cover Contract Commitments

Internal Release Contract Commitments

Creating an Internal Contract Commitment Release

Internal Contract Commitment Releases Window Description

Contract Commitment Report Procedures

Definition

Overview

Internal Release Contract Commitments

Revaluing Contract Commitments

Year-End Process

Mass Payment Forecast Shift Process

Prerequisites

Running the Contract Commitment Complete Cover Commitment Program

Running the Contract Commitment Revalue Process Procedure

Running the Correct Revaluation Variances Process Procedure

Generating the Contract Commitment Revaluation Fix Exception Report Procedure

Running the Year-End Process Procedure

Generating the Contract Commitment Mass Payment Forecast Shift Process Procedure

Dossier Process

Definition

Overview

Dossier Process Flow Diagram

Dossier Processes

Set Up Approval Hierarchy

Set Up General Ledger Budget

Set Up Dossier Numbering

Set Up Dossier Types

Maintain Dossiers

Dossier Relationships

Dossier Procedures

Definition

Overview

Transferring Funds in Dossiers

Dossier Approval Process

Recommendations

Prerequisites

Checking and Reserving Funds

Dossier Window

Accepting or Rejecting Dossiers

Reassigning Dossiers

Viewing Dossier History

Dossier History Window

Viewing Dossier Transaction Hierarchies

Dossier Hierarchy Inquiry Window

Exchange Protocol Process

Definition

Overview

Exchange Protocol Process Flow Diagram

Exchange Protocol Processes

Define Hierarchies

Define Profiles for Exchange Protocol

Define Dialog Unit Types

Define Transmission Unit Types

Define Exchange Protocol Numbering

Exchange Protocol Approval Process

Year End Process

Exchange Protocol Procedures

Definition

Overview

Dialog Units

Transmission Units

Approval Profiles and Workflow

Working with Dialog and Transmission Units

Numbering Dialog and Transmission Units

Exchange Protocol Processes

Prerequisites

Creating Dialog Units

Find Dialog Units Window Description

New Dialog Unit Window Description

Find Transactions Window Description

Include In Dialog Unit Window Description

Reviewing Dialog Units

Dialog Units Window Description

Generating Transmission Units From Dialog Units

Creating Transmission Units

Find Transmission Units Window Description

New Transmission Unit Window Description

Find Dialog Units for Transmission Unit Window Description

Dialog Units Available Window Description

Reviewing Transmission Units

Transmission Units Window Description

Transmitting Transmission Units

Dialog Unit Validation Procedure for Authorizing Users

Generic Interface Process

Definition

Overview

File Headers

Journal Headers

Transaction Lines

File Footers

Feeder System Data File Layout

Prerequisites

Setting Up Generic Interface

Define New Journal Source

Define Period Mappings

Define Ledger Mappings

Define Feeder System Descriptors

Define Generic Interface Profile Options

Loading Interface Files

Reloading Interface Files

Feeder Transaction Inquiry

File Header Record Specification

Journal Header Record Specification

Journal Lines Record Specification

File Footer Record Specification

Generic Interface Procedures

Definition

Overview

Prerequisites

Loading, Validating, and Extracting Feeder File Transactions Procedure

Load and Validate Feeder File

Extract Feeder File Transactions

Import and Post Feeder File Transactions

Viewing Feeder System Detail Inquiry Procedure

From the Account Inquiry Window

From the Feeder System Detail Inquiry Window

Reloading Feeder File Procedure

Archiving, Purging, or Restoring Feeder System Transactions Procedure

Hierarchical Drill-Down Inquiry Process

Overview

Prerequisites

Hierarchical Drill-Down Inquiry Process Flow Diagram

Hierarchical Drill-Down Inquiry Process

Determine Drill-Down Structure

Set Up Drill-Down Structure

Interrogate Drill-Down Structure

Maintain Drill-Down Structure

Hierarchical Drill-Down Inquiry Business Rules

Drill-Down Mapping Business Rules

Drill-Down Inquiry Business Rules

Hierarchical Drill-Down Inquiry Example

Set Up Drill-Down

Hierarchical Drill-Down Inquiry Procedure

Definition

Overview

To Date Drill-Down

Full Year Drill-Down

Projections Drill-Down

Prerequisites

Hierarchical Drill-Down Inquiry Procedure

Drill-Down Inquiry Window Description

Journals Window Description

Inflation Accounting for Assets Process

Definition

Overview

Prerequisites

Inflation Accounting for Assets Processing

Occasional Revaluation Process

Formulae Used in Occasional Revaluation Process

Periodic Depreciation Revaluation Process

Formulae Used in Periodic Depreciation Revaluation Process

Revaluation Catch-up Process

Access to Inflation Accounting for Assets Information

Limitations

Inflation Accounting for Assets Setup

Price Indexes

Inflation Accounting Options

Security

Inflation Accounting for Assets Implementation

Continuous MHCA Use to Date of Implementation

Gap in Use or No Previous Use of MHCA

Reporting

Mass Upload of Asset Valuations

Upload of Professional Valuations

Validation of Professional Valuations

Download of Validation Results

Transfer to Revaluation Process

Inflation Accounting for Assets Procedures

Definition

Inflation Accounting for Assets Mass Upload of Asset Valuations Procedures

Overview

Uploading Assets

Web ADI

Revaluation Upload Process Diagram

Revaluation Upload Process Description

Prerequisites

Defining Layouts and Mapping

Uploading and Downloading Files

Inflation Accounting: New File Integrator

Inflation Accounting: Exception Errors Integrator

Inflation Accounting: Tolerance Errors Integrator

Inflation Accounting: Valid Assets Integrator

Inflation Accounting: Transferred File Integrator

Running the Inflation Accounting: Transfer Revaluation Upload Data Process

Inflation Accounting for Assets Report Procedures

Definition

Installment Terms Process

Definition

Overview

Prerequisites

Installment Terms Process Flow Diagram

Installment Terms Setup

Installment Terms Reports

Installment Terms Procedure

Definition

Overview

Prerequisites

Modifying and Creating Payment Terms Procedure

Modify Installment Transactions Summary Window

Find Modify Installment Customers Window

Account Details Window

Audit Terms Window

Modify Installment Terms Window

Installment Terms Report Procedure

Overview

Generating Installment Terms: Installment Audit Report Procedure

Internal Trading Process

Definition

Internal Trading Process Flow Diagram

Workflow Process Flow Diagram

Encumbrance and Budgetary Control Process Flow Diagram

Internal Trading Process Description

Setting Up Internal Trading

Setup Options

Charge Centers

Internal Trading Procedures

Cross Charge Entry

Cross Charge Approval or Rejection

Cross Charge Resubmission or Cancellation

Journal Creation

Journal Entries Accounting Example

Without Funds Reservation

With Funds Reservation

Cross Charge Status Values

Raise Cross Charge with Three Service Lines

Reserve Funds

Submit Cross Charge

Approve First Service Line

Creation Approval for First Service Line

Reject Second and Third Service Lines

Second and Third Service Lines Rejected in Creation

Resubmit Second Service Line

Approve Second Service Line

Creation Approval for Second Service Line

Receiver Approval for First and Second Service Lines

Cancel Third Service Line

Automatic Posting to General Ledger

References

Internal Trading Procedures

Overview

Prerequisites

Creating Internal Charge Entries

Creating an Internal Charge Header

Creating Service Lines

Submitting Service Lines

Enter Charges Window Description

Actions Window Description

Approving Service Lines

Cross Charge Receiver Authorization Window Description

Viewing a Cross Charge Summary

Resubmitting Service Lines Procedure

Canceling Service Lines

Tools Menu

Find Cross Charges Window Description

Cross Charges Summary Window Description

Services Window Description

Internal Trading Report Procedures

Definition

Overview

Internal Trading: Internal Charge Status Report

Internal Trading: Automatic Approval of Service Lines

Internal Trading: Create Actual Journals Report

Generating Internal Trading: Internal Charge Status Report Procedure

Generating Internal Trading: Automatic Approval of Service Lines Procedure

Generating Internal Trading: Create Actual Journals Procedure

Secondary Invoice Approval Process

Definition

Setting Up Secondary Invoice Approval

Secondary Invoice Approval Process Diagram

Using Oracle Payables with Secondary Invoice Approval

Using Secondary Approval Example

References

Secondary Invoice Approval Procedures

Definition

Overview

Approval Groups

Secondary Approval Holds

Viewing and Authorizing Secondary Approvals

View and Authorize Secondary Approvals Window

Viewing and Authorizing Payment Holds

Prerequisites

Viewing and Authorizing Secondary Approvals

Viewing and Authorizing Payment Holds

View and Authorize Secondary Approvals Window Description

Secondary Invoice Approval Report Procedures

Definition

Overview

Secondary Invoice Approval: Flexfield Assignments Report

Secondary Invoice Approval: Secondary Approval of Invoices Report

Generating Secondary Invoice Approval: Secondary Approval of Invoices Report

Generating Secondary Invoice Approval: Flexfield Assignments Report

Single Third Party Process

Definition

Single Third Party Process Flow Diagram

Setting Up Single Third Party

Enable Netting Transaction Types

Set Profile Options for Single Third Party

Creating Single Third Parties

Viewing Single Third Party Netting Balances

Creating Netting Transactions

Adjust Receivables Balance Example

Adjust Payables Balance Example

Objection to Payment Example

Assignment Example

Payment Excess Example

Supplier Reimbursement Example

Single Third Party Procedures

Definition

Overview

Netting Process

Netting Transaction Types

Netting Packages and Netting Batches

Prerequisites

Creating a Single Third Party

Entering Customer Details

Entering Supplier Details

Single Third Party - Address Details Window Description

Viewing Single Third Party Details and Outstanding Balance

Single Third Party Netting Balance Window Description

Creating Netting Transactions

Netting Transactions Window Description

Create Netting Packages Window Description

Submitting Netting Batches

Submit Netting Batches Window Description

Standing Charges Process

Definition

Standing Charges Process Flow Diagram

Setting Up Standing Charges

Set Extended System Options for Standing Charges

Set Up Billing and Charging Periods

Entering Standing Charges and Creating Periodic Invoices

Enter Charge Items

Enter Standing Charges

Run Standing Charges: Preliminary Invoice Register Report

Run Standing Charges: Generate Interface Data Program

Run AutoInvoice

Run Standing Charges: Synchronize Standing Charges Program

Price Update Considerations

Standing Charges Item Price Update

Price Update using Standing Charge Details Window

Price Update using Global Price Update Window

Standing Charges Procedures

Definition

Overview

Prerequisites

Defining Standing Charge Items

Standing Charge Items Window Description

Viewing Charge Item Price History

Item Price History Window Description

Viewing Standing Charges

Standing Charges Window Description

Creating a Standing Charge Agreement

Standing Charge Window Description

Setting Up Charge Lines

Charge Details Window Description

Reviewing Invoice History

Invoice History Window Description

Viewing Price Update History

Price History Window Description

Updating Global Price

Global Price Update Window Description

Run ID Window Description

Standing Charges Report Procedures

Standing Charges Reports

Subledger Security Process

Definition

Overview

Features

Supported Products

Prerequisites

Subledger Security Setup

Determine Security Policy

Set Up Security

Apply Security

Maintain Security

Subledger Security Process Flow Diagram

Subledger Security Process

Set Application Level Profile Options

Set Site Level Profile Options

Define Security Groups

Define Responsibilities

Set Responsibility Level Profile Options

Define Users

Define Secure Tables

Define Process Groups

Allocate Secure Tables and Process Groups

Apply Security

Security Group Consolidation

Secure Existing Data

Subledger Security Examples

Basic Subledger Security Principles

Secure Update Access

Application Context

Security Group Consolidation

Application Level Control

Subledger Security Report Procedures

Definition

Overview

Subledger Security: Allocation Status Report

Subledger Security: Group Status Report

Subledger Security: Grouped Secure Tables Report

Subledger Security: Object Status Report

Subledger Security: Secure Tables Status Report

Subledger Security: Security Group Consolidations Report

Subledger Security: User Allocation Status Report

Subledger Security: Allocation Status Report

Subledger Security: Group Status Report

Subledger Security: Grouped Secure Tables Report

Subledger Security: Object Status Report

Subledger Security: Secure Tables Status Report

Subledger Security: Security Group Consolidations Report

Subledger Security: User Allocation Status Report

Oracle Public Sector Financials (International) Navigation Paths

Standard Budgetary Control

Commitment Budgetary Control

Dual Budgetary Control

Contract Commitment Feature

Contract Commitment Module without Commitment Budgetary Control

Contract Commitment Module with Commitment Budgetary Control

Reporting Currency Transactions to General Ledger and Commitment Budgetary Control Process

Definition

Overview

Creating Commitment Budgetary Control Journal Entry Lines in Reporting Currency

Contract Commitment Legacy Conversion Procedures

Definition

Overview

Legacy Conversion Process Flow Diagram

Legacy Conversion to Contract Commitment Tables

Legacy Conversion to Commitment Budgetary Control Tables

Legacy Conversion to Standard Budgetary Control (SBC), General Ledger

CC Headers Interface Table

CC Account Lines Interface Table

CC Detail Payment Forecast Interface Table

CBC Open Interface Table

Running the Contract Commitment Legacy Open Interface Program Procedure

Running the Contract Commitment Budgetary Control Legacy Open Interface Program Procedure

Contract Commitment Open API

Definition

Overview

Set API

Create API

Update API

Select API

Link API

SET API Parameters

Create API Parameters

Update API Parameters

Select API Parameters

Link API Parameters

Contract Commitment and Oracle Payables Integration

Contract Commitment Invoice Matching

Integrated Supplier and Contract Commitment Information

Matching Purchase Order Tables

PO Default and QuickMatch Invoices

PO Default Invoice Type

QuickMatch Invoice Type

Using Encumbrance Accounting with Contract Commitment

Glossary

Index

Oracle Public Sector Financials (International) User Guide

Contents