Default values in BI reports

Oracle provides some functions for default values for date fields. Below are some supported functions. The below details are from Oracle support note.
Enter one of the following functions using the syntax shown to calculate the appropriate date at the scheduled runtime for the report:

{$SYSDATE()$} - current date (the system date of the server on which BI Publisher is running)

{$FIRST_DAY_OF_MONTH()$} - first day of the current month

{$LAST_DAY_OF_MONTH()$} - last day of the current month

{$FIRST_DAY_OF_YEAR)$} - first day of the current year

{$LAST_DAY_OF_YEAR)$} - last day of the current year

The date function calls in the parameter values are not evaluated until the report is executed by the Scheduler.

You can also enter expressions using the plus sign "+" and minus sign "-" to add or subtract days as follows:

{$SYSDATE()+1$}

{$SYSDATE()-7$}

For our example, to capture data from the previous week, each time the schedule runs, enter the following in the report's date parameter fields:

Date From: {$SYSDATE()-7$}

Date To: {$SYSDATE()-1$}

Last run date parameter BI Report

Having the last run date is quite useful in reports particularly if you are interested in incremental reports. There is no straightforward way for doing this Oracle Cloud BI.


Below are the steps I have done this -

1. Define list of values SQL based.
Name last_run_time_lov
Query (Only one value is returned)
SELECT MAX(processend-30) last_end_time
FROM fusion.ess_request_history erh, fusion.ess_request_property erp
WHERE 1 = 1 AND erh.product = 'BI Publisher'
AND erh.requestid = erp.requestid
AND erp.name = 'report_url'
AND erp.VALUE LIKE '/Custom/Test/AP Rejections.xdo'
AND erh.state IN (4,12)

2. Create a menu based parameter and assign the LOV
3. Uncheck Select All and now the only value is defaulted when you run the report.

UCM/Content Server/FTP/Email Bursting Sample Query

For most outbound interfaces bursting to content server and then picking the file from UCM is the best approach for large extracts.
Default URL - https://POD.oraclecloud.com/cs

Also a cool feature I noticed is that bursting works to different targets (like the same file can be sent to email & FTP at the same time)

Below is the samplequery for busting to UCM or webcenter content server.

Sample Bursting Query for UCM Bursting
This is a sample query for bursting reports to a specific folder in the content server.
select distinct
product_status as "KEY", -- Split Key from data model SQL
'BurstTemp' TEMPLATE, -- Report template name
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT, -- Output type
'WCC' DEL_CHANNEL, -- To send to content server
'FA_UCM_PROVISIONED' PARAMETER1, -- Content Server name
'FAFusionImportExport' PARAMETER2, -- Security group
'intergration_user' PARAMETER3, -- Author of the file to be shown in content server
'' PARAMETER4, -- Account (Optional)
'Test_Burst' PARAMETER5, -- Title
Product_Status|| TestFile.pdf'PARAMETER6, -- Output File name
Product_Status PARAMETER8, -- Content ID (Optional)
'false' PARAMETER9, -- Custom metadata (Optional)
'/Contribution Folders/Inbound' PARAMETER10 -- Folder path to deliver files
from products

'FA_UCM_PROVISIONED' is the default account for BI reports 'FAFusionImportExport' can be used as it setup by default.


Sample Bursting query for Email with output file name from BI Publisher-
SELECT 'Split_KEY' KEY, -- Split Key from data model SQL
'AP Rejections' TEMPLATE, --BI Report template
'en-US' LOCALE,
'xlsx' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
'from@email.com' parameter1,
'cc@email.com' parameter2, --CC
'to@email.com' parameter3,
'Bursting Email TEST' parameter4,
'Please find the reported AP Invoice Rejections during the interface load.
Please review the errors and take appropriate actions.
Regards
Interface Team ' parameter5,
'true' parameter6,
'replyto@nowhere.com' parameter7,
'Rejections Output'|| to_char(sysdate,'dd_mm_yyyy') output_name FROM dual


Sample Bursting query for FTP with output file name from BI Publisher-

SELECT SEQ KEY
, 'TEST_REPORT' TEMPLATE -- Report template name
, 'en-US' LOCALE
, 'PDF' OUTPUT_FORMAT
, 'FTP' DEL_CHANNEL
, 'FTP Name Defined in BI Pub' PARAMETER1
, 'accountname' PARAMETER2
, 'password' PARAMETER3
, 'folder' PARAMETER4
, 'TEST_FTP_'||TO_CHAR(SYSDATE, 'DDMMYYHH24MISS')||'.pdf' PARAMETER5
, 'TRUE' PARAMETER6
, null parameter7
from dual

Oracle Integration REST HTTP/1.1 500 Internal Server Error

Developing new cloud interfaces you will often get the HTTP/1.1 500 Internal Server Error. And the error details sometimes gives you the root cause for the error. Like example -

Error Creating Supplier :HTTP/1.1 500 Internal Server Error:
env:Server<Supplier WebServiceOperation="createSupplier" Supplier="New Supplier" SupplierNumber="12345" SupplierId="">
<SupplierAddresses Operation="CREATE" AddressId="" AddressName="ADD123">
<Rejection>The address is not valid. At least one of the address attributes failed validation. Review the address format and geography setup for more details.</Rejection>
</SupplierAddresses>

But in many cases it does not give you a detailed error message. In that case most likely the error is with the incorrect xml tags being used in the payload.

Example from supplier site payload -

True/sup:PayPurposeFlag>

If you notice carefully < was missing after the value(True). So check the payload carefully and ensure you are using the correct tags.

So the below tag might also cause the same error. (sup: is missing from the tags)
True/


Happy Integrating.

Oracle Cloud Integrations - Interface details

While developing Cloud integrations I could not find a single place for all details like InterfaceID or jobdefinitionname or job name etc.

Below is the list I extracted from one of the SOAP services for integration. Hope this helps.


{"InterfaceId":"1","JobDisplayName":"Import Payables Invoices","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/payables/invoices/transactions;APXIIMPT","JobDescription":"Creates Oracle Fusion Payables invoices from invoice data in the open interface tables."},
{"InterfaceId":"2","JobDisplayName":"Import AutoInvoice","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/receivables/transactions/autoInvoices;AutoInvoiceImportEss","JobDescription":"Imports invoices, credit memos, debit memos, and on-account credits from other source systems into Oracle Fusion Receivables and validates the imported data."},
{"InterfaceId":"3","JobDisplayName":"Process Receipts Through Lockbox","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/receivables/receipts/lockboxes;ProcessLockboxesMasterEss","JobDescription":"Processes receipts imported through lockbox."},
{"InterfaceId":"4","JobDisplayName":"Import Trading Community Data in Bulk","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/cdm/foundation/bulkImport;BulkImportJob","JobDescription":"Extracts, transforms, and loads business objects and associated child entities from external sources and other applications to trading community registry."},
{"InterfaceId":"5","JobDisplayName":"Process BAI2 Format Bank Statements","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/bankStatements;BAI2BankStatements","JobDescription":"Transmits, loads, and imports BAI2 bank statements."},
{"InterfaceId":"6","JobDisplayName":"Process SWIFT MT940 Format Bank Statements","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/bankStatements;SWIFT940BankStatements","JobDescription":"Transmits, loads, and imports SWIFTMT940 bank statements."},
{"InterfaceId":"7","JobDisplayName":"Process EDIFACT FINSTA Format Bank Statements","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/bankStatements;EDIFACTBankStatements","JobDescription":"Transmits, loads, and imports EDIFACT FINSTA format bank statements."},
{"InterfaceId":"8","JobDisplayName":"Process ISO200022 CAMT053 Format Bank Statements","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/bankStatements;ISO20022BankStatements","JobDescription":"Transmits, loads, and imports ISO200022 CAMT053 format bank statements."},
{"InterfaceId":"9","JobDisplayName":"Post Mass Additions","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/additions;PostMassAdditions","JobDescription":"Creates assets from mass addition lines in the Post queue and adds mass addition lines in the Cost Adjustment queue to the existing assets."},
{"InterfaceId":"10","JobDisplayName":"Post Mass Retirements","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/retirements/massRetirements;PostMassRetirements","JobDescription":"Posts mass retirement transactions with a status of Post."},
{"InterfaceId":"11","JobDisplayName":"Post Mass Transfers","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/tracking/massTransfers;PostMassTransfers","JobDescription":"Posts mass transfer transactions with a status of Post."},
{"InterfaceId":"12","JobDisplayName":"Post Mass Fixed Asset Financial Transactions","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/adjustments/workArea;PostMassFinTransactions","JobDescription":"Posts all mass financial transactions in the interface table that are in a status of Post."},
{"InterfaceId":"13","JobDisplayName":"Upload Units of Production","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/depreciation/production;UploadProduction","JobDescription":"Uploads units of production data from the FA_PRODUCTION_INTERFACE table to the FA_PERIODIC_PRODUCTION table."},
{"InterfaceId":"14","JobDisplayName":"Import Intercompany Transactions","UcmAccount":"fin/intercompany/import","ImportJobName":"/oracle/apps/ess/financials/commonModules/intercompanyTransactions;TransactionsImport","JobDescription":"Imports intercompany transactions from external source systems."},
{"InterfaceId":"15","JobDisplayName":"Import Journals","UcmAccount":"fin/generalLedger/import","ImportJobName":"/oracle/apps/ess/financials/generalLedger/programs/common;JournalImportLauncher","JobDescription":"Creates journal entries from imported information from subledgers and other source systems."},
{"InterfaceId":"16","JobDisplayName":"Import Segment Values and Hierarchies","UcmAccount":"fin/generalLedger/import","ImportJobName":"/oracle/apps/ess/financials/generalLedger/programs/masterData;LoadSegValAndHierData","JobDescription":"Imports segment values and hierarchies from external sources to Oracle Fusion General Ledger."},
{"InterfaceId":"17","JobDisplayName":"Validate and Upload Budgets","UcmAccount":"fin/budgetBalance/import","ImportJobName":"/oracle/apps/ess/financials/generalLedger/ledgers/ledgerDefinitions;ValidateAndLoadBudgets","JobDescription":"Validates budget data."},
{"InterfaceId":"18","JobDisplayName":"Import Supplier Bank Accounts","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/payments/fundsDisbursement/payments;ImportSuppBankAccounts","JobDescription":"Imports supplier bank accounts and payee information."},
{"InterfaceId":"19","JobDisplayName":"Import Tax Configuration Content","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/tax/report;LaunchTaxConfigContentUpload","JobDescription":"Loads tax content data into Oracle Fusion Trading Community Model geography and into all related Oracle Fusion Tax entities, including taxes, tax statuses, tax rates, tax jurisdictions, and accounts."},
{"InterfaceId":"20","JobDisplayName":"Import Costs","UcmAccount":"prj/projectCosting/import","ImportJobName":"/oracle/apps/ess/projects/costing/transactions/onestop;ImportProcessParallelEssJob","JobDescription":"Creates expenditure items and cost distributions for the transactions in the Oracle Fusion Project Costing open interface table using parallel processing."},
{"InterfaceId":"21","JobDisplayName":"Import Orders","UcmAccount":"prc/purchaseOrder/import","ImportJobName":"/oracle/apps/ess/prc/po/pdoi;ImportSPOJob","JobDescription":"Imports purchase orders from external systems into Oracle Fusion Purchasing."},
{"InterfaceId":"22","JobDisplayName":"Import Contract Agreements","UcmAccount":"prc/contractPurchaseAgreement/import","ImportJobName":"/oracle/apps/ess/prc/po/pdoi;ImportCPAJob","JobDescription":"Imports contract agreements from external systems into Oracle Fusion Purchasing."},
{"InterfaceId":"23","JobDisplayName":"Import Blanket Agreements","UcmAccount":"prc/blanketPurchaseAgreement/import","ImportJobName":"/oracle/apps/ess/prc/po/pdoi;ImportBPAJob","JobDescription":"Imports blanket purchase agreements from external systems into Oracle Fusion Purchasing."},
{"InterfaceId":"24","JobDisplayName":"Import Suppliers","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSuppliers","JobDescription":"Creates and updates suppliers from data in the Suppliers open interface table."},
{"InterfaceId":"25","JobDisplayName":"Import Supplier Sites","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierSites","JobDescription":"Creates and updates supplier sites from data in the Supplier Sites open interface table."},
{"InterfaceId":"26","JobDisplayName":"Import Supplier Contacts","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierContacts","JobDescription":"Creates and updates supplier contacts and contact addresses from data in the Supplier Contacts and Supplier Contact Addresses open interface tables."},
{"InterfaceId":"27","JobDisplayName":"Import Supplier Site Assignments","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierSiteAssignments","JobDescription":"Creates and updates supplier site assignments from data in the Supplier Site Assignments open interface table."},
{"InterfaceId":"28","JobDisplayName":"Import Requisitions","UcmAccount":"prc/requisition/import","ImportJobName":"/oracle/apps/ess/prc/por/createReq/reqImport;RequisitionImportJob","JobDescription":"Imports requisitions from external systems into Oracle Fusion Purchasing."},
{"InterfaceId":"29","JobDisplayName":"Item Import","UcmAccount":"scm/item/import","ImportJobName":"/oracle/apps/ess/scm/productModel/items;ItemImportJobDef","JobDescription":"Imports items in product hub."},
{"InterfaceId":"30","JobDisplayName":"Receive Shipment Request","UcmAccount":"scm/shipmentRequest/import","ImportJobName":"/oracle/apps/ess/scm/shipping/shipConfirm/deliveries;WshReceiveShipmentRequestsSRSJob","JobDescription":"Receives shipment lines into Oracle Fusion Shipping."},
{"InterfaceId":"31","JobDisplayName":"Manage Reservation Interface","UcmAccount":"scm/inventoryReservation/import","ImportJobName":"/oracle/apps/ess/scm/inventory/materialTransactions/txnManager;ReservationsMgr","JobDescription":"Manages inventory reservations from data in the reservations open interface table."},
{"InterfaceId":"32","JobDisplayName":"Manage Receiving Transactions","UcmAccount":"scm/receivingReceipt/import","ImportJobName":"/oracle/apps/ess/scm/receiving/receiptsInterface/transactions/processor;RcvTxnProcessorJob","JobDescription":"Processes pending or unprocessed receiving transactions."},
{"InterfaceId":"33","JobDisplayName":"Create Inventory Transactions","UcmAccount":"scm/inventoryTransaction/import","ImportJobName":"/oracle/apps/ess/scm/inventory/materialTransactions/txnManager;SingleTMEssJob","JobDescription":"Creates inventory transactions from transaction data in the transaction open interface table."},
{"InterfaceId":"34","JobDisplayName":"Interface Standard Costs","UcmAccount":"scm/standardCost/import","ImportJobName":"/oracle/apps/ess/scm/costing/standardCosts/stdCostInterface;cstStdCostInterfaceJob","JobDescription":"Interfaces and creates standard costs for inventory transactions."},
{"InterfaceId":"35","JobDisplayName":"Import Count Sequences","UcmAccount":"scm/cycleCount/import","ImportJobName":"/oracle/apps/ess/scm/inventory/counting/desktopCycleCountInterface;InvCcIntrfRecordsProcessJob","JobDescription":"Updates cycle count tables with records from the cycle count open interface table."},
{"InterfaceId":"36","JobDisplayName":"Import Project Enterprise Resources","UcmAccount":"prj/projectManagement/import","ImportJobName":"/oracle/apps/ess/projects/projectManagement/resources;PjtLoadEnterpriseResourceDataJobDef","JobDescription":"Creates project enterprise resources in Oracle Fusion Project Management based on data loaded into the Oracle Fusion Project open interface table."},
{"InterfaceId":"37","JobDisplayName":"Import VAT Invoices for China","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/apacLocalizations/transaction/goldenTax;VatInvoiceImportForCloud","JobDescription":"Import VAT invoice data from a flat file and map the data to the corresponding Golden Tax transactions at both the header level and the line level."},
{"InterfaceId":"38","JobDisplayName":"Import Project Tasks","UcmAccount":"prj/projectFoundation/import","ImportJobName":"/oracle/apps/ess/projects/foundation/projectDefinition;ImportTasksInterfaceDataJobDef","JobDescription":"Creates project tasks in Oracle Fusion Project Financial Management based on data loaded into the Oracle Fusion Project Tasks open interface table."},
{"InterfaceId":"39","JobDisplayName":"Import Project Budgets","UcmAccount":"prj/projectControl/import","ImportJobName":"/oracle/apps/ess/projects/control/budgetsAndForecasts;ImportBudgetsInterfaceData","JobDescription":"Creates budget versions in Oracle Fusion Project Control based on data loaded into the Oracle Fusion Project Budgets open interface table."},
{"InterfaceId":"40","JobDisplayName":"Import Project Plan","UcmAccount":"prj/projectManagement/import","ImportJobName":"/oracle/apps/ess/projects/projectManagement/projectPlan;PjtLoadProjectPlanDataJobDef","JobDescription":"Creates projects and tasks in Oracle Fusion Project Management based on data loaded into the Oracle Fusion Project Portfolio Management open interface table."},
{"InterfaceId":"41","JobDisplayName":"Import Resource Actual Hours","UcmAccount":"prj/projectResourceManagement/import","ImportJobName":"/oracle/apps/ess/projects/resourceManagement/reporting;PjrReportingLoadActualHoursDataJobDef","JobDescription":"Imports resource actual hours data from the open interface and creates time transactions."},
{"InterfaceId":"42","JobDisplayName":"Import Project Resource Requests","UcmAccount":"prj/projectResourceManagement/import","ImportJobName":"/oracle/apps/ess/projects/resourceManagement/request;PjrRequestLoadRequestDataJobDef","JobDescription":"Imports project resource request data from the open interface and creates project resource requests."},
{"InterfaceId":"43","JobDisplayName":"Party Tax Profile Import","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/tax/report;FinancialTaxPartyImport","JobDescription":"Imports the party tax profile and associated child tables for third party and third-party sites."},
{"InterfaceId":"44","JobDisplayName":"Import External Transactions to the Tax Repository","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/tax/report;FinancialTaxEntryRepo","JobDescription":"Imports transactions from an external source to the tax repository."},
{"InterfaceId":"45","JobDisplayName":"Import Project and Task Transaction Controls","UcmAccount":"prj/projectFoundation/import","ImportJobName":"/oracle/apps/ess/projects/costing/setup;ImportTransactionControlsJob","JobDescription":"Creates transaction controls for projects and tasks based on data loaded into the Oracle Fusion Project Transaction Control open interface table."},
{"InterfaceId":"46","JobDisplayName":"Import Projects","UcmAccount":"prj/projectFoundation/import","ImportJobName":"/oracle/apps/ess/projects/foundation/projectDefinition;ImportProjectJobDef","JobDescription":"Creates projects in Oracle Fusion Project Foundation based on the data that is loaded into the Oracle Fusion Projects open interface table."},
{"InterfaceId":"47","JobDisplayName":"Validate and Import Collection Documents","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/latinLocalizations/transaction/payables/bankTransfer;ValidateAndImportColDocs","JobDescription":"Validate collection document records and import the records without import errors. Records with import errors will remain in the interface table."},
{"InterfaceId":"48","JobDisplayName":"Validate and Import Bank Returns for Supplier Payments","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/latinLocalizations/transaction/payables/bankTransfer;ValidateAndImportBankReturns","JobDescription":"Validates bank return records and imports the records without import errors. Records with import errors will remain in the interface table."},
{"InterfaceId":"49","JobDisplayName":"Import Bank Returns for Customer Payments","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/latinLocalizations/transaction/receivables/bankTransfer;ImportBankReturns","JobDescription":"Imports the bank return file and validates the data. Valid records are imported and the records with errors are placed in an intermediate table until the user corrects or cancels them."},
{"InterfaceId":"50","JobDisplayName":"Import External Transactions","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/bankStatements;ImportExternalTransactions","JobDescription":"Import External Transactions from Interface table"},
{"InterfaceId":"51","JobDisplayName":"Import Budget Amounts","UcmAccount":"fin/budgetaryControl/import","ImportJobName":"/oracle/apps/ess/financials/commitmentControl/integration/budgetImport;BudgetImport","JobDescription":"Creates budgets from imported data loaded into the interface table from subledgers and outside sources."},
{"InterfaceId":"52","JobDisplayName":"Import Supplier Products and Services Categories","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierProductsandServicesCategory","JobDescription":"Creates and updates supplier products and services categories from data in the Supplier Products and Services Categories open interface table."},
{"InterfaceId":"53","JobDisplayName":"Import Supplier Business Classifications","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierBusinessClassifications","JobDescription":"Creates and updates supplier business classifications from data in the Supplier Business Classifications open interface table."},
{"InterfaceId":"54","JobDisplayName":"Import Revenue Basis Data","UcmAccount":"fin/revenueManagement/import","ImportJobName":"/oracle/apps/ess/financials/revenueManagement/shared;VRMIRBD","JobDescription":"Imports revenue data from the upstream applications to be used for compliance processing and revenue accounting."},
{"InterfaceId":"55","JobDisplayName":"Import Billing Data","UcmAccount":"fin/revenueManagement/import","ImportJobName":"/oracle/apps/ess/financials/revenueManagement/shared;VRMIBDP","JobDescription":"Import billing data into Revenue Management. Validates the billing data for accounting."},
{"InterfaceId":"56","JobDisplayName":"Import Supplier Addresses","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierAddresses","JobDescription":"Creates and updates supplier addresses from data in the Supplier Addresses open interface table."},
{"InterfaceId":"57","JobDisplayName":"Import Awards","UcmAccount":"prj/grantsManagement/import","ImportJobName":"/oracle/apps/ess/projects/grantsManagement/award;AwardMassImportJob","JobDescription":"Creates awards, award projects, award funding and other related details in Oracle Fusion Grants Management based on the data that is loaded into the Oracle Fusion Grants Management open interface tables."},
{"InterfaceId":"60","JobDisplayName":"Retrieve Funds Capture Acknowledgments","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/payments/fundsCapture/transactions;FetchSettlementACK","JobDescription":"Retrieves funds capture acknowledgments from the payment system or bank."},
{"InterfaceId":"61","JobDisplayName":"Import AutoInvoice with Fiscal Attributes","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/genericLocalizations/transaction/fiscal;AutoInvoiceImportWithFiscalAttributesEss","JobDescription":"Imports fiscal documents from other systems into Oracle Fusion Receivables and validates the imported data."},
{"InterfaceId":"63","JobDisplayName":"Import Work Orders","UcmAccount":"scm/workOrder/import","ImportJobName":"/oracle/apps/ess/scm/commonWorkExecution/massImport/workOrders;ImportWorkOrdersJob","JobDescription":"Imports work orders and associated details from the open interface tables."},
{"InterfaceId":"64","JobDisplayName":"Import Work Order Material Transactions","UcmAccount":"scm/workOrderMaterialTransaction/import","ImportJobName":"/oracle/apps/ess/scm/commonWorkExecution/massImport/materialTransactions;ImportMaterialTransactionJob","JobDescription":"Imports work order material transactions and associated details from the open interface tables."},
{"InterfaceId":"65","JobDisplayName":"Import Work Order Resource Transactions: Process Work Order Resource Transaction Open Interface","UcmAccount":"scm/workOrderResourceTransaction/import","ImportJobName":"/oracle/apps/ess/scm/commonWorkExecution/massImport/resourceTransactions;ImportResourceTransactionJob","JobDescription":"Imports work order resource transactions and associated details from the open interface tables"},
{"InterfaceId":"66","JobDisplayName":"Import Work Order Operation Transactions","UcmAccount":"scm/workOrderOperationTransaction/import","ImportJobName":"/oracle/apps/ess/scm/commonWorkExecution/massImport/operationTransactions;ImportOperationTransactionsJob","JobDescription":"Imports work order operation transactions and associated details from the open interface tables"},
{"InterfaceId":"67","JobDisplayName":"Import Project Resource Assignments","UcmAccount":"prj/projectResourceManagement/import","ImportJobName":"/oracle/apps/ess/projects/resourceManagement/assignment;PjrAssignmentLoadAssignmentDataJobDef","JobDescription":"Imports project resource assignment data from the open interface and creates project resource assignments."},
{"InterfaceId":"68","JobDisplayName":"Import Project Billing Events","UcmAccount":"prj/projectBilling/import","ImportJobName":"/oracle/apps/ess/projects/billing/transactions;ImportBillingEventJob","JobDescription":"Creates billing events in Oracle Fusion Project Billing using the Import Project Billing Events file-based data import."},
{"InterfaceId":"71","JobDisplayName":"Import and Calculate Daily Rates","UcmAccount":"fin/generalLedger/import","ImportJobName":"/oracle/apps/ess/financials/generalLedger/programs/common;DailyRatesImport","JobDescription":"Imports and validates daily conversion rates."},
{"InterfaceId":"72","JobDisplayName":"Import Sales Orders","UcmAccount":"scm/sourceSalesOrder/import","ImportJobName":"/oracle/apps/ess/scm/doo/decomposition/receiveTransform/receiveSalesOrder;ImportOrdersJob","JobDescription":"Imports orders that are loaded to interface tables"},
{"InterfaceId":"73","JobDisplayName":"Perform Shipping Transactions","UcmAccount":"scm/performShippingTransaction/import","ImportJobName":"/oracle/apps/ess/scm/shipping/shipConfirm/deliveries;WshPerformShippingTxnJob","JobDescription":"Processes pending shipping transactions received through open interfaces."},
{"InterfaceId":"74","JobDisplayName":"Import Price List","UcmAccount":"scm/priceLists/import","ImportJobName":"/oracle/apps/ess/scm/pricing/pricingAdmin/priceLists;QpPriceListsImportJob","JobDescription":"Import price list from the interface tables."},
{"InterfaceId":"75","JobDisplayName":"Process Supply Chain Orchestration Interface","UcmAccount":"scm/supplyOrder/import","ImportJobName":"/oracle/apps/ess/scm/dos/supplyRequestDecomposition/supplyRequestInterface/createSupplyOrders;ProcessSupplyOrderInterface","JobDescription":"Creates supply orders based on Supply Chain Orchestration Interface records"} {"InterfaceId":"76","JobDisplayName":"Import Reconciliation Report Data","UcmAccount":"fin/revenueManagement/import","ImportJobName":"/oracle/apps/ess/financials/revenueManagement/shared;VRMIRA","JobDescription":"Imports reconciliation data received from Oracle E-Business Suite."},
{"InterfaceId":"77","JobDisplayName":"Tax Configuration Content Upload","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/tax/report;FinancialsTaxMultiFileUpload","JobDescription":"Uploads a set of flat files to define new tax content data as related Oracle Fusion Tax entities."},
{"InterfaceId":"78","JobDisplayName":"Import Project Forecasts","UcmAccount":"prj/projectControl/import","ImportJobName":"/oracle/apps/ess/projects/control/budgetsAndForecasts;ImportForecastsInterfaceData","JobDescription":"Creates forecast versions in Oracle Fusion Project Control based on data loaded into the Oracle Fusion Project Forecasts open interface table."},
{"InterfaceId":"79","JobDisplayName":"Import Financial Project Plans","UcmAccount":"prj/projectControl/import","ImportJobName":"/oracle/apps/ess/projects/control/budgetsAndForecasts;ImportProjectPlansInterfaceData","JobDescription":"Creates project task assignments in Oracle Fusion Project Financial Management based on data loaded into the open interface table."},
{"InterfaceId":"80","JobDisplayName":"Japanese Depreciable Assets Tax Summary Report","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/shared;JapaneseDepreciableAssetsTaxSummaryReport","JobDescription":"Summarizes asset information by location as of January 1 for the selected calendar year. Calculates the evaluated and theoretical net book value for each asset type, and the decision cost, which is the larger of the two net book values."},
{"InterfaceId":"81","JobDisplayName":"Import Inbound Fiscal Document Attributes","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/genericLocalizations/transaction/fiscal;ImportInboundFiscalDocAttributesEss","JobDescription":"Imports inbound fiscal document attributes from other source systems into Oracle Fusion and validates the imported data."},
{"InterfaceId":"82","JobDisplayName":"Asset Physical Inventory Comparison","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/shared;FACOMP","JobDescription":"Compares the entered physical inventory data with the asset book, and lists the differences and possible actions to correct the differences."},
{"InterfaceId":"83","JobDisplayName":"Requirements Import Job","UcmAccount":"scm/requirement/import","ImportJobName":"/oracle/apps/ess/scm/customerNeedsManagement;AcnReqAndLineItemImportJobDef","JobDescription":"Imports Requirements from CSV file to application."},
{"InterfaceId":"84","JobDisplayName":"Ideas Import Job","UcmAccount":"scm/idea/import","ImportJobName":"/oracle/apps/ess/scm/customerNeedsManagement;AcnIdeaImportJobDef","JobDescription":"Imports Ideas from CSV file to application."},
{"InterfaceId":"86","JobDisplayName":"Proposal Import Job","UcmAccount":"scm/productProposal/import","ImportJobName":"/oracle/apps/ess/scm/productConceptDesign;AcdProposalImportJobDef","JobDescription":"Imports Proposals from CSV file to application."},
{"InterfaceId":"90","JobDisplayName":"Import Resource Pools and Memberships","UcmAccount":"prj/projectResourceManagement/import","ImportJobName":"/oracle/apps/ess/projects/resourceManagement/resources;PjrResourcesLoadResourcePoolDataJobDef","JobDescription":"Imports resource pool and pool membership data from the open interface and creates resource pools and memberships."},
{"InterfaceId":"91","JobDisplayName":"Cash Position Data Transfer","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/cashPosition/integration;CashPositionDataTransfer","JobDescription":"Transfers data from the interface tables to the cube dimensions and facts."},
{"InterfaceId":"106","JobDisplayName":"Manage Inventory Balances Process","UcmAccount":"scm/inventoryBalance/import","ImportJobName":"/oracle/apps/ess/scm/inventory/materialAvailability/onhandBalances;InvOnhandBalProcessJob","JobDescription":"Submits multiple requests to reconcile the on-hand balances in the organization with the on-hand details provided by the external system."},
{"InterfaceId":"107","JobDisplayName":"Import Assets","UcmAccount":"scm/maintenanceAsset/import","ImportJobName":"/oracle/apps/ess/scm/maintenanceManagement/assets/import;ImportMaintenanceAssetsJob","JobDescription":"Imports Assets with its details from the open interface tables."},
{"InterfaceId":"108","JobDisplayName":"Import Customer Assets","UcmAccount":"scm/customerAsset/import","ImportJobName":"/oracle/apps/ess/scm/installedBase/customerAssets/import;ImportCustomerAssetsJob","JobDescription":"Imports customer asset details from the asset import tables."},
{"InterfaceId":"109","JobDisplayName":"Import Project Rate Schedules and Overrides","UcmAccount":"prj/projectSetup/import","ImportJobName":"/oracle/apps/ess/projects/foundation/setup/rates;ImportRateSchedulesJob","JobDescription":"Creates and updates rate schedules and overrides in Project Financial Management applications based on the data imported from the open interface."},
{"InterfaceId":"110","JobDisplayName":"Import Maintenance Work Orders","UcmAccount":"scm/maintenanceWorkOrder/import","ImportJobName":"/oracle/apps/ess/scm/maintenanceManagement/workOrders/import;ImportMaintenanceWorkOrdersJob","JobDescription":"Imports maintenance work orders and associated details from the open interface tables."},
{"InterfaceId":"111","JobDisplayName":"Import Fiscal Document Approval Information","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/genericLocalizations/transaction/fiscal;ImportTaxAuthorityReturn","JobDescription":"Imports the approvals, errors, and rejected data from the fiscal authority and records this information with the associated transactions."},
{"InterfaceId":"112","JobDisplayName":"Import Asset Leases","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/tracking/leases;ImportAssetLeases","JobDescription":"Creates asset leases from the data in the lease open interface tables"},
{"InterfaceId":"113","JobDisplayName":"Import Credit Data","UcmAccount":"fin/receivables/import","ImportJobName":"/oracle/apps/ess/financials/receivables/creditManagement;ARCMICD","JobDescription":"Imports credit data for customers or customer accounts from third party sources into Oracle Fusion Receivables."},
{"InterfaceId":"114","JobDisplayName":"Post Mass Update Descriptive Details","UcmAccount":"fin/assets/import","ImportJobName":"/oracle/apps/ess/financials/assets/tracking/massTransfers;PostMassUpdateDescDetails","JobDescription":"Updates asset descriptive details from the data in the Descriptive Details open interface table."},
{"InterfaceId":"115","JobDisplayName":"Import Supplier Attachments","UcmAccount":"prc/supplier/import","ImportJobName":"/oracle/apps/ess/prc/poz/supplierImport;ImportSupplierAttachments","JobDescription":"Creates supplier profile attachments from data in the Supplier Attachments open interface table"},
{"InterfaceId":"116","JobDisplayName":"Record Partner Tax Lines","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/tax/report;PopulatePartnerLines","JobDescription":"Validates and processes the transaction tax lines calculated and returned by a third-party tax calculation engine for subsequent update of all related Oracle ERP Cloud transactions."},
{"InterfaceId":"117","JobDisplayName":"Import Bank Statements from a Spreadsheet","UcmAccount":"fin/cashManagement/import","ImportJobName":"/oracle/apps/ess/financials/cashManagement/bankStatements;ImportBankStatements","JobDescription":"Transmits, loads, and imports bank statements created in a spreadsheet."},
{"InterfaceId":"118","JobDisplayName":"Import Chart of Accounts Mapping Segment Rollup Rules","UcmAccount":"fin/generalLedger/import","ImportJobName":"/oracle/apps/ess/financials/generalLedger/programs/common;ImportCoaMappingRollupRules","JobDescription":"Imports and validates chart of accounts mapping segment rollup rules for the specified chart of accounts mapping."},
{"InterfaceId":"119","JobDisplayName":"Import Change Orders","UcmAccount":"scm/changeOrder/import","ImportJobName":"/oracle/apps/ess/scm/productCatalogManagement/changeObjects;ChangeOrderImportJobDef","JobDescription":"Imports change orders into Product Hub"},
{"InterfaceId":"120","JobDisplayName":"Import Payables Payment Requests","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/payables/invoices/transactions;APXPRIMPT","JobDescription":"Imports the payment request for One Time Payments. The process creates the party, party site, payee, payee bank account, and invoices from data in the Payment Request Interface table."},
{"InterfaceId":"121","JobDisplayName":"Import Funding Sources","UcmAccount":"prj/grantsManagement/import","ImportJobName":"/oracle/apps/ess/projects/grantsManagement/setup;ImportSponsorsJob","JobDescription":"Creates sponsors, internal funding sources, and other related details based on the data that is loaded into the Oracle Grants Management Cloud open interface tables."},
{"InterfaceId":"122","JobDisplayName":"Import Keywords","UcmAccount":"prj/grantsManagement/import","ImportJobName":"/oracle/apps/ess/projects/grantsManagement/setup;ImportKeywordsJob","JobDescription":"Creates keywords based on the data that is loaded into the Oracle Fusion Grants Management open interface tables."},
{"InterfaceId":"123","JobDisplayName":"Import Grants Personnel","UcmAccount":"prj/grantsManagement/import","ImportJobName":"/oracle/apps/ess/projects/grantsManagement/setup;ImportGrantsPersonnelJob","JobDescription":"Creates Grants personnel based on the data that is loaded into the Oracle Fusion Grants Management open interface tables."},
{"InterfaceId":"125","JobDisplayName":"Import Collaboration Order Forecasts","UcmAccount":"scm/collaborationOrderForecast/import","ImportJobName":"/oracle/apps/ess/scm/supplyCollaboration/collaboration;VcsSupplyCollaborationOrderForecastImportJob","JobDescription":"Creates collaboration order forecast data records in the Supply Chain Collaboration interface tables using a file-based data import template."},
{"InterfaceId":"126","JobDisplayName":"Import Product Genealogy","UcmAccount":"scm/productGenealogy/import","ImportJobName":"/oracle/apps/ess/scm/assetTracking/productGenealogy/import;ImportProductGenealogyJob","JobDescription":"Creates genealogy instances, structures, and transactions from the genealogy import tables."},
{"InterfaceId":"127","JobDisplayName":"Import Sales Orders in High Volume","UcmAccount":"scm/sourceSalesOrder/import","ImportJobName":"/oracle/apps/ess/scm/fom/importOrders/hvop;HighVolumeImportSalesOrdersJob","JobDescription":"Job that imports high volume of sales orders from interface tables"},
{"InterfaceId":"128","JobDisplayName":"Amendment Transaction Data for Reconciliation","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/apacLocalizations/financialReports;IndiaGSTInboundReport","JobDescription":"Uploads and reconciles the amendment transaction data provided by GSTN"},
{"InterfaceId":"129","JobDisplayName":"Import Miscellaneous Transactions for Fiscal Document Generation","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/genericLocalizations/transaction/fiscal;ImportFiscalSalesDocuments","JobDescription":"Import miscellaneous transactions and corresponding fiscal attributes for subsequent fiscal document generation."},
{"InterfaceId":"130","JobDisplayName":"Process Tax Point Date Adjustments","UcmAccount":"fin/tax/import","ImportJobName":"/oracle/apps/ess/financials/genericLocalizations/financialReports;ProcessTPDAdjustment","JobDescription":"Updates tax lines where the tax point date has been adjusted on a Payables or Receivables transaction."},
{"InterfaceId":"131","JobDisplayName":"Import Accounting Setup","UcmAccount":"fin/fusionAccountingHub/import","ImportJobName":"/oracle/apps/ess/financials/subledgerAccounting/shared;XLASETUPIMPORT","JobDescription":"Imports the file to begin the setup process for a new application source system in Subledger Accounting."},
{"InterfaceId":"133","JobDisplayName":"Import Work Definitions","UcmAccount":"scm/workDefinition/import","ImportJobName":"/oracle/apps/ess/scm/commonWorkSetup/workDefinitions/massImport;ImportWorkDefinitionJob","JobDescription":"Import work definitions and associated details from the open interface tables."},
{"InterfaceId":"134","JobDisplayName":"Import Account Combinations","UcmAccount":"fin/generalLedger/import","ImportJobName":"/oracle/apps/ess/financials/generalLedger/programs/common;GlImportBulkAccountCombination","JobDescription":"Imports the bulk account combinations from the interface table."},
{"InterfaceId":"135","JobDisplayName":"Load Planning Data from Flat Files","UcmAccount":"scm/planningDataLoader/import","ImportJobName":"/oracle/apps/ess/scm/advancedPlanning/collection/configuration;CSVController","JobDescription":"Load data from CSV file to staging tables."},
{"InterfaceId":"136","JobDisplayName":"Import Resource Breakdown Structures","UcmAccount":"prj/projectSetup/import","ImportJobName":"/oracle/apps/ess/projects/foundation/resources;ImportPrbsJob","JobDescription":"Creates and updates resource breakdown structures in Oracle Fusion Project Foundation based on the data that is loaded into the open interface table."},
{"InterfaceId":"137","JobDisplayName":"Schedule Catalog Import Job","UcmAccount":"scm/item/import","ImportJobName":"/oracle/apps/ess/scm/productModel/items;CatalogImportJobDef","JobDescription":"Schedule Catalog Import Job"},
{"InterfaceId":"138","JobDisplayName":"Create Cost Accounting Distributions","UcmAccount":"scm/cstCogs/import","ImportJobName":"/oracle/apps/ess/scm/costing/costAccounting/runControl;CstCostProcess","JobDescription":"Computes item costs and creates accounting distributions for inventory and COGS transactions."},
{"InterfaceId":"139","JobDisplayName":"Import Asset and Assignments Process","UcmAccount":"prj/projectCosting/import","ImportJobName":"/oracle/apps/ess/projects/costing/capitalization;ImportAssetProcessingJob","JobDescription":"Imports either project assets, project asset assignments, or both."},
{"InterfaceId":"140","JobDisplayName":"Import Maintenance Work Definitions","UcmAccount":"scm/maintenanceWorkDefinition/import","ImportJobName":"oracle/apps/ess/scm/maintenanceManagement/workDefinitions/import;ImportMaintenanceWorkDefinitionsJob","JobDescription":"Imports multiple work definitions through a spreadsheet."},
{"InterfaceId":"141","JobDisplayName":"Import Property Information","UcmAccount":"psc/commoncomponents/import","ImportJobName":"/oracle/apps/ess/psc/commonComponents/addressParcelOwner;ImportAddressParcelOwner","JobDescription":"Imports property information into the PSCR parcel master tables."},
{"InterfaceId":"142","JobDisplayName":"Process Responses from Order Fulfillment","UcmAccount":"scm/orderFulfillmentResponse/import","ImportJobName":"/oracle/apps/ess/scm/doo/taskLayer/common;ImportOrderFulfillmentResponseJob","JobDescription":"Process each response that the order fulfillment system sends to order management."},
{"InterfaceId":"143","JobDisplayName":"Import Netting Agreements","UcmAccount":"fin/payables/import","ImportJobName":"/oracle/apps/ess/financials/europeanLocalizations/netting;ImportNettingAgreements","JobDescription":"Imports netting agreement setup data from the netting interface table."},
{"InterfaceId":"144","JobDisplayName":"Import Agency Staff","UcmAccount":"psc/commoncomponents/import","ImportJobName":"/oracle/apps/ess/psc/commonComponents/employeeProfiles;ImportAgencyStaff","JobDescription":"Import Agency Staff and Roles"},
{"InterfaceId":"145","JobDisplayName":"Import Common Application Data","UcmAccount":"hed/admissions/import","ImportJobName":"/oracle/apps/ess/hed/admissions/shared/common/commonApp;ImportCommonApplicationData","JobDescription":"Import Common Application Data into student management interface tables"},
{"InterfaceId":"146","JobDisplayName":"Import Vendor-Managed Inventory Relationships","UcmAccount":"scm/vmiRelationship/import","ImportJobName":"/oracle/apps/ess/scm/supplyCollaboration/collaboration;VcsVMIRelationshipImportJob","JobDescription":"Creates vendor-managed inventory relationship records from the data that is in a file-based data import template."},
{"InterfaceId":"147","JobDisplayName":"Import Installed Base Assets","UcmAccount":"scm/installedBaseAsset/import","ImportJobName":"oracle/apps/ess/scm/assetTracking/assetCore/import;ImportInstalledBaseAssetsJob","JobDescription":"Imports the installed base assets details from the asset import tables."},