Journal

Service to load journals for import into Oracle Fusion General Ledger. A journal records the accounting transactions for a ledger, including details about the accounts and amounts. Journal entries are usually recorded in chronological order using the double-entry method of bookkeeping. For example, sales revenues are recorded in a journal entry that increases sales dollars and increases accounts receivable. Cash receipts from customers result in a journal entry that increases the cash balance and reduces accounts receivable.

Life Cycle Status: Active

QName: {http://xmlns.oracle.com/apps/financials/generalLedger/journals/desktopEntry/journalImportService/}JournalImportService

Service WSDL URL: https://(FinancialDomain,Ledger)/finGlDesktopEntry/JournalImportService?WSDL

Relationships

The following table describes how this business object service is related to service data objects or other business object services.

Relationship Type Object or Service

Handles

Journal Header SDO

Handles

Journal SDO

Handles

Account SDO

Operations

importJournals

Creates the journal for import.

Life Cycle Status: Active

Request Payload

Element Name Type Description

interfaceRows

Journal Interface Header

Journals that need to be imported.

Response Payload

Element Name Type Description

result

long

Returns the interface run identifier, which is used to identify journals in the journal interface table.

getDfltObjAttrHints

An operation to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, invoke the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

Life Cycle Status: Active

Request Payload

Element Name Type Description

viewName

string

The service view usage name, an internal name for the service data object. Specify the value of the element from the getEntityList operation response payload.

localeName

string

The locale to use when evaluating locale-based user interface hints. The localeName is in ISO 639-1 format.

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

The label and user interface hints for the specified service data object and its attributes in a name-value pair format.

getServiceLastUpdateTime

An operation that returns the date and time when the schema files referenced in the service definition last changed.

Life Cycle Status: Active

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the service definition last changed in ISO 8601 format.

getEntityList

An operation to get the list of service data objects defined on this service.

Life Cycle Status: Active

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

A list of service data objects defined on this service. For each service data object, the result includes the QName, internal name, and Boolean values indicating whether create, update, merge, and delete operations can be performed on the object.

Security

The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

Service Operations to Privileges Mapping

Operation Name Privilege Code Privilege Name Privilege Description

All Operations

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

Run Import Journals By Program Call

Allows submission of the journal import program by a program call.

All Operations

GL_RUN_IMPORT_JOURNALS_PROGRAM_PRIV

Run Import Journals Program

Allows submission of the journal import program using the Oracle Fusion Enterprise Scheduler Services.

Privileges to Duty Roles Mapping

Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

GL_RUN_IMPORT_JOURNALS_PROGRAM_PRIV

ORA_GL_JOURNAL_ENTRY_DUTY

Journal Management

Creates journal entries and allocations.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_XLA_ACCOUNTING_HUB_INTEGRATION_DUTY

Accounting Hub Integration

Duty role to secure additional privileges associated with FAH on Cloud.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_CST_COST_ACCOUNTANT_JOB

Cost Accountant

Performs cost and management accounting functions.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_GL_JOURNAL_ENTRY_DUTY

Journal Management

Creates journal entries and allocations.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_GL_PERIOD_CLOSE_MANAGEMENT_DUTY

Period Close Management

Performs financial close process including opening and closing periods.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_PJB_PROJECT_CONTRACT_INVOICE_MANAGEMENT_DUTY

Project Contract Invoice Management

Perform tasks related to managing project contract invoices, billing events and billing transaction exceptions.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_XLA_SUBLEDGER_ACCOUNTING_MANAGER_DUTY

Subledger Accounting Manager

Creates accounting for transactions, reviews journal entries, and runs account analysis, journal entries, and period close exceptions reports.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_XLA_SUBLEDGER_ACCOUNTING_SPECIALIST_DUTY

Subledger Accounting Specialist

Creates accounting for a given transaction and reviews journal entries.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_ZX_TAX_ACCOUNTANT_JOB

Tax Accountant

Prepares and files tax returns and reports for an enterprise, including country, federal, state, and local corporate, payroll, and transaction taxes.

GL_RUN_IMPORT_JOURNALS_VIA_PROGRAM_CALL_PRIV

ORA_ZX_TAX_MANAGER_JOB

Tax Manager

Defines the tax policies and most efficient tax configuration. Sets up relatively stable entities that seldom require updates, such as tax regimes and taxes.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

ORA_CST_COST_ACCOUNTANT_JOB

ORA_CST_COST_MANAGEMENT_ADMINISTRATION_DUTY

Cost Management Administration

Performs cost management application setups and administration.

ORA_CST_COST_ACCOUNTANT_JOB

ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

FSCM Load Interface Administration

Manages load interface file for import

ORA_CST_COST_ACCOUNTANT_JOB

ORA_EGP_ITEM_INQUIRY_DUTY

Item Inquiry

Queries and views items in the enterprise.

ORA_CST_COST_ACCOUNTANT_JOB

ORA_XLA_SUBLEDGER_ACCOUNTING_REPORTING_DUTY

Subledger Accounting Reporting

Runs all subledger accounting reports, and reviews journal entries.

ORA_CST_COST_ACCOUNTANT_JOB

ORA_XCC_TRANSACTIONAL_DUTY

Transaction Entry with Budgetary Control

Manages the budgetary control tasks by job roles who perform transactions that are subject to budgetary control, such as accounts payable manager.

ORA_GL_JOURNAL_ENTRY_DUTY

ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

FSCM Load Interface Administration

Manages load interface file for import

ORA_GL_JOURNAL_ENTRY_DUTY

ORA_GL_GENERAL_ACCOUNTING_SETUP_REVIEW_DUTY

General Accounting Setup Review

Views set up for accounting and transaction calendars, Oracle Fusion General Ledger accounting period status, conversion rates and chart of accounts mapping rules.

ORA_GL_JOURNAL_ENTRY_DUTY

ORA_GL_GENERAL_LEDGER_REPORTING_DUTY

General Ledger Reporting

Provides access to all balances and transaction inquiry and reporting privileges for General Ledger.

ORA_GL_PERIOD_CLOSE_MANAGEMENT_DUTY

ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

Customer Account Inquiry

View customer account details.

ORA_GL_PERIOD_CLOSE_MANAGEMENT_DUTY

ORA_GL_GENERAL_ACCOUNTING_SETUP_REVIEW_DUTY

General Accounting Setup Review

Views set up for accounting and transaction calendars, Oracle Fusion General Ledger accounting period status, conversion rates and chart of accounts mapping rules.

ORA_GL_PERIOD_CLOSE_MANAGEMENT_DUTY

ORA_GL_JOURNAL_ENTRY_DUTY

Journal Management

Creates journal entries and allocations.

ORA_GL_PERIOD_CLOSE_MANAGEMENT_DUTY

ORA_GL_MANAGE_GENERAL_LEDGER_ACCOUNTING_PERIOD_STATUS_AGGR

Manage General Ledger Accounting Period Status

Manages Oracle Fusion General Ledger period status.

ORA_GL_PERIOD_CLOSE_MANAGEMENT_DUTY

ORA_XLA_SUBLEDGER_ACCOUNTING_REPORTING_DUTY

Subledger Accounting Reporting

Runs all subledger accounting reports, and reviews journal entries.

ORA_PJB_PROJECT_CONTRACT_INVOICE_MANAGEMENT_DUTY

ORA_XLA_SUBLEDGER_ACCOUNTING_SPECIALIST_DUTY

Subledger Accounting Specialist

Creates accounting for a given transaction and reviews journal entries.

ORA_XLA_SUBLEDGER_ACCOUNTING_MANAGER_DUTY

ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

Customer Account Inquiry

View customer account details.

ORA_XLA_SUBLEDGER_ACCOUNTING_SPECIALIST_DUTY

ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

Customer Account Inquiry

View customer account details.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

Customer Account Inquiry

View customer account details.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_GBL_INTRASTAT_PROCESSING_DUTY

Intrastat Processing

Manages intrastat transactions including collecting, validating, exporting, printing, and purging intrastat transactions. Defines intrastat country characteristics, parameters, and rules.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_EGP_ITEM_INQUIRY_DUTY

Item Inquiry

Queries and views items in the enterprise.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_ZX_REGISTRATION_PII_DUTY

Party Taxpayer Identifier PII

View personally identifiable information for tax registration number of type taxpayer ID.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_POZ_SUPPLIER_PROFILE_INQUIRY_DUTY

Supplier Profile Inquiry

View supplier profile information.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_ZX_TAX_CONFIGURATION_INQUIRY_DUTY

Tax Configuration Inquiry

Views main tax entities, such as tax regimes and taxes.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_ZX_TAX_EXTERNAL_TRANSACTION_DUTY

Tax External Taxable Transaction Processing

Duty Role to manage import of transactions from external sources.

ORA_ZX_TAX_ACCOUNTANT_JOB

ORA_ZX_TAX_REPORTING_DUTY

Tax Reporting

Sets up tax reporting types and creates tax reports.

ORA_ZX_TAX_MANAGER_JOB

ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY

Customer Account Inquiry

View customer account details.

ORA_ZX_TAX_MANAGER_JOB

ORA_GBL_INTRASTAT_PROCESSING_DUTY

Intrastat Processing

Manages intrastat transactions including collecting, validating, exporting, printing, and purging intrastat transactions. Defines intrastat country characteristics, parameters, and rules.

ORA_ZX_TAX_MANAGER_JOB

ORA_EGP_ITEM_INQUIRY_DUTY

Item Inquiry

Queries and views items in the enterprise.

ORA_ZX_TAX_MANAGER_JOB

ORA_XLE_LEGAL_ENTITIES_ADMIN_DUTY

Legal Entities Administration

Manages legal entities, legal reporting units and registrations.

ORA_ZX_TAX_MANAGER_JOB

ORA_ZX_REGISTRATION_PII_DUTY

Party Taxpayer Identifier PII

View personally identifiable information for tax registration number of type taxpayer ID.

ORA_ZX_TAX_MANAGER_JOB

ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY

Payables Invoice Inquiry

Views Oracle Fusion Payables invoices.

ORA_ZX_TAX_MANAGER_JOB

ORA_AP_PAYABLES_INVOICE_PROCESSING_DUTY

Payables Invoice Processing

Views invoices and related documents and takes action, such as approving and resolving holds.

ORA_ZX_TAX_MANAGER_JOB

ORA_ZX_TAX_ADMINISTRATION_DUTY

Tax Administration

Sets up transaction tax content including regime to rate configuration, rules, tax determinants, configuration options and party tax profiles.

ORA_ZX_TAX_MANAGER_JOB

ORA_AR_TAX_BILLING_DUTY

Tax Billing

Provide access to billing information for tax users.

ORA_ZX_TAX_MANAGER_JOB

ORA_ZX_TAX_EXTERNAL_TRANSACTION_DUTY

Tax External Taxable Transaction Processing

Duty Role to manage import of transactions from external sources.

ORA_ZX_TAX_MANAGER_JOB

ORA_ZX_TAX_REPORTING_DUTY

Tax Reporting

Sets up tax reporting types and creates tax reports.

ORA_ZX_TAX_MANAGER_JOB

ORA_ZX_WHT_ADMINISTRATION_DUTY

Withholding Tax Administration

Sets up withholding tax content including regime to rate configuration, rules, tax determinants, configuration options and party tax profiles.