Financial Reporting Service for Coexistence with E-Business Suite
Oracle internal use only.
Life Cycle Status: Active
QName: {http://xmlns.oracle.com/apps/financials/generalLedger/inquiry/coexistence/publicService/}CoexistenceService
Service WSDL URL: https://servername/fscmService/CoexistenceService?WSDL
Operations
registerEBSInstance
Registers the E-Business Suite instance on Oracle Fusion Accounting Hub Reporting Cloud Service instance.
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
systemId |
long |
The E-Business Suite system identification number. |
name |
string |
The E-Business Suite system identification name. |
drilldownURL |
string |
The E-Business Suite URL for drill down from the Oracle Fusion Accounting Hub Reporting Cloud Service instance. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
string |
Returns the status of the registration. |
transfer
Transfers balances from Oracle E-Business Suite to the Oracle Fusion Accounting Hub Reporting Cloud Service instance.
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
transferId |
long |
The internal identification number of the balance transfer. |
systemId |
long |
The E-Business Suite system identification number. |
transferTypeCode |
string |
The code for the transfer type. Valid values are LEDGER_CONFIG and TRANSFER_BALANCES. |
totalNumberOfFiles |
long |
The total number of data files to be transferred to Oracle Fusion for this particular balance transfer. |
currentChunkNumber |
long |
The sequence number of the data file that is currently being transferred by this service operation. |
configFile |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
The setup data file. |
periodStatusFile |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
The period status data file. |
balanceFile |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
The balances data file. |
ledgerId |
long |
The unique identifier for the ledger. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
string |
Returns the submission status of the balance transfer. |
reverseTransfer
Reverses a previous balance transfer request from Oracle E-Business Suite to Oracle Fusion Accounting Hub Reporting Cloud Service.
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
transferId |
long |
The internal identification number of the balance transfer to be reversed. |
systemId |
long |
The E-Business Suite system identification number. |
ledgerId |
long |
The unique identifier for the ledger. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
string |
Retrieves the submission status of the balance transfer reversal. |
reverseBalances
Reverses balances previously transferred from Oracle E-Business Suite to Oracle Fusion Accounting Hub Reporting Cloud Service.
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
transferId |
long |
The internal identification number of the balance transfer to be reversed. |
systemId |
long |
The E-Business Suite system identification number. |
ledgerId |
long |
The unique identifier for the ledger. |
fromPeriod |
string |
The fiscal period that begins a range of time for reversing balances. |
toPeriod |
string |
The fiscal period that ends a range of time for reversing balances. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
string |
Submission results for the balance reversal process. |
getStatus
Returns the completion status of the balance transfer from E-Business Suite to Oracle Fusion Accounting Hub Reporting Cloud Service
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
transferId |
long |
The internal identification number of the balance transfer. |
systemId |
long |
The E-Business Suite system identification number. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
string |
Retrieves the completion status of the balance transfer. |
getLedgerId
Retrieves the unique identifier for the ledger.
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
systemId |
long |
The E-Business Suite system identification number. |
ledgerName |
string |
The name of the ledger. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
long |
Retrieves the unique identifier for the ledger. |
createReports
Creates financial reports on the Oracle Fusion Accounting Hub Reporting Cloud Service instance.
Life Cycle Status: Active
Request Payload
Element Name | Type | Description |
---|---|---|
ledgerId |
long |
The unique identifier for the ledger. |
topRevenueAccount |
string |
The top revenue account that all revenue accounts roll up to. |
topCostOfSalesAccount |
string |
The top cost of sales account that all sales accounts roll up to. |
topExpenseAccount |
string |
The top operating expenses account that all expense accounts roll up to. |
Response Payload
Element Name | Type | Description |
---|---|---|
result |
string |
Retrieves the submission status of the create financial reports process. |
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_TRANSFER_E_BUSINESS_SUITE_BALANCES_TO_FINANCIAL_REPORTING_CLOUD_SERVICE_PRIV |
Transfer E-Business Suite Balances to Financial Reporting Cloud Service |
Allows balance transfer from E-Business Suite General Ledger to Oracle Fusion General Ledger to support the co-existence solution with E-Business Suite for Oracle Fusion Cloud reporting. |
Privileges to Duty Roles Mapping
Privilege Code | Granted to Duty Role Code | Granted to Duty Role Name | Granted To Duty Role Description |
---|---|---|---|
GL_TRANSFER_E_BUSINESS_SUITE_BALANCES_TO_FINANCIAL_REPORTING_CLOUD_SERVICE_PRIV |
ORA_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY |
General Accounting Functional Administration |
Administers setup objects related to General Ledger journals and other accounting setup components such as intercompany setups and historical translation rates. |
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_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY |
ORA_XLA_ACCOUNTING_HUB_ADMINISTRATION_DUTY |
Accounting Hub Administration |
Configures the accounting hub for a source system. |
ORA_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY |
ORA_FUN_CUSTOMER_ACCOUNT_INQUIRY_DUTY |
Customer Account Inquiry |
View customer account details. |
ORA_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY |
ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY |
FSCM Load Interface Administration |
Manages load interface file for import |
ORA_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY |
ORA_GL_MANAGE_GENERAL_LEDGER_ACCOUNTING_PERIOD_STATUS_AGGR |
Manage General Ledger Accounting Period Status |
Manages Oracle Fusion General Ledger period status. |