Hi everyone my name is jonathan
i tried to send the budget from Planning to ERP financials budget but i have this error when i tried to export the info to ERP
2019-03-04 21:26:18,184 INFO [AIF]: FDMEE Process: 468, Log Level: 4
2019-03-04 21:26:18,184 INFO [AIF]: Location : Loc_BR (Partitionkey:31)
2019-03-04 21:26:18,184 INFO [AIF]: Period Name : December 2019 (Period Key:12/31/19 12:00 AM)
2019-03-04 21:26:18,184 INFO [AIF]: Category Name: Commitment (Category key:2)
2019-03-04 21:26:18,184 INFO [AIF]: Rule Name : R_EPM_PLN (Rule ID:17)
2019-03-04 21:26:21,633 INFO [AIF]: FDM Version: 11.1.2.4.230
2019-03-04 21:26:21,634 INFO [AIF]: Log File Encoding: UTF-8
2019-03-04 21:26:22,812 INFO [AIF]: -------START IMPORT STEP-------
2019-03-04 21:26:23,365 INFO [AIF]: EssbaseService.extractData - START
2019-03-04 21:26:23,527 INFO [AIF]: cloudServiceType: Planning, Resolved user: epm_default_cloud_admin, planningUserName
2019-03-04 21:26:23,843 INFO [AIF]: Extract Script (Calc): SET DataExportOptions
{
DATAEXPORTCOLFORMAT ON;
DATAEXPORTDIMHEADER ON;
DATAEXPORTDRYRUN OFF;
DataExportRelationalFile OFF;
DataExportNonExistingBlocks OFF;
DataExportLevel ALL;
DATAEXPORTCOLHEADER "Period";
DATAEXPORTOVERWRITEFILE ON;
DataExportDynamicCalc OFF;
};
FIX (@Relative("Account",0),@Relative("Entity",0),@Relative("Prod",0),@Relative("Metrics",0),"FY19",@Relative("Perfil",0),@Relative("Version",0),@Relative("Segmento",0),"Dec",@Relative("Region",0),@Relative("Curr_M",0),@Relative("Scenario",0))
DATAEXPORT "File" "," "/u03/inbox/data/Banreg_3_Plan1_468.txt" "#";
ENDFIX
2019-03-04 21:26:23,873 INFO [AIF]: List of exported files to be merged from dir /u03/inbox/data for file name Banreg_3_Plan1_468*
2019-03-04 21:26:23,875 INFO [AIF]: Number of files to be merged: 1
2019-03-04 21:26:23,892 INFO [AIF]: EssbaseService.extractData - END (true)
2019-03-04 21:26:24,211 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::468;31:2:17:MXN:/u03/inbox/data:EPM_EPM
2019-03-04 21:26:24,225 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2019-03-04 21:26:24,225 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2019-03-04 21:26:24,311 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2019-03-04 21:26:24,311 INFO [AIF]: EPMFDM-140274:Message - File Name Banreg_3_468.dat
periodKey2019-12-31
2019-03-04 21:26:24,311 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL
2019-03-04 21:26:24,395 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 468
PARTITIONKEY: 31
IMPORT GROUP: IF_EPM_PLN
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: Banreg_3_468.dat
PROCESSING CODES:
-----------------------------------------------------------------------------------
BLANK............. Line is blank or empty.
NN................ Non-Numeric, Amount field contains non numeric characters.
TC................ Type Conversion, Amount field could not be converted to a number.
ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.
SKIP FIELD.............. SKIP field value was found
NULL ACCOUNT VALUE.............. Account Field is null
SKIP FROM SCRIPT.............. Skipped through Script
HEADER ROW.............. Header Row
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.
Rows Loaded: 28
Rows Rejected: 0
2019-03-04 21:26:24,402 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2019-03-04 21:26:24,403 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2019-03-04 21:26:24,405 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 46820191231.dat
2019-03-04 21:26:24,406 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: Banreg_3_468.dat
2019-03-04 21:26:24,406 INFO [AIF]: EPMFDM-140274:Message - File not deleted: /u03/inbox/data/Banreg_3_468.dat
2019-03-04 21:26:24,422 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2019-03-04 21:26:24,422 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 197
2019-03-04 21:26:24,608 INFO [AIF]:
Import Data from Source for Period 'December 2019'
2019-03-04 21:26:24,759 INFO [AIF]: Executing delete statement:
2019-03-04 21:26:24,764 INFO [AIF]: Successfully executed delete statement
2019-03-04 21:26:24,789 INFO [AIF]:
Map Data for Period 'December 2019'
2019-03-04 21:26:24,797 INFO [AIF]:
Processing Mappings for Column 'ACCOUNT'
2019-03-04 21:26:24,803 INFO [AIF]: Data Rows Updated by Location Mapping 'ALL' (LIKE): 28
2019-03-04 21:26:24,809 INFO [AIF]: Data Rows Updated by Location Mapping 'ALL' (LIKE): 0
2019-03-04 21:26:24,812 INFO [AIF]:
Processing Mappings for Column 'ENTITY'
2019-03-04 21:26:24,814 INFO [AIF]: Data Rows Updated by Rule Mapping 'TGT_03' (LIKE): 28
2019-03-04 21:26:24,818 INFO [AIF]:
Processing Mappings for Column 'UD1'
2019-03-04 21:26:24,821 INFO [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 28
2019-03-04 21:26:24,824 INFO [AIF]:
Processing Mappings for Column 'UD10'
2019-03-04 21:26:24,830 INFO [AIF]: Data Rows Updated by Location Mapping 'Alll' (LIKE): 28
2019-03-04 21:26:24,833 INFO [AIF]:
Processing Mappings for Column 'UD11'
2019-03-04 21:26:24,838 INFO [AIF]: Data Rows Updated by Location Mapping 'TG_alll' (LIKE): 28
2019-03-04 21:26:24,841 INFO [AIF]:
Processing Mappings for Column 'UD13'
2019-03-04 21:26:24,848 INFO [AIF]: Data Rows Updated by Location Mapping 'All' (LIKE): 28
2019-03-04 21:26:24,851 INFO [AIF]:
Processing Mappings for Column 'UD3'
2019-03-04 21:26:24,854 INFO [AIF]: Data Rows Updated by Location Mapping 'RN_ALl' (LIKE): 28
2019-03-04 21:26:24,858 INFO [AIF]:
Processing Mappings for Column 'UD4'
2019-03-04 21:26:24,865 INFO [AIF]: Data Rows Updated by Location Mapping 'RN_N_00000000' (LIKE): 28
2019-03-04 21:26:24,868 INFO [AIF]:
Processing Mappings for Column 'UD5'
2019-03-04 21:26:24,873 INFO [AIF]: Data Rows Updated by Location Mapping 'TG_0000000000' (LIKE): 28
2019-03-04 21:26:24,877 INFO [AIF]:
Processing Mappings for Column 'UD6'
2019-03-04 21:26:24,884 INFO [AIF]: Data Rows Updated by Location Mapping 'TG_03' (LIKE): 28
2019-03-04 21:26:24,887 INFO [AIF]:
Processing Mappings for Column 'UD7'
2019-03-04 21:26:24,891 INFO [AIF]: Data Rows Updated by Location Mapping 'TG_00000000' (LIKE): 28
2019-03-04 21:26:24,894 INFO [AIF]:
Processing Mappings for Column 'UD8'
2019-03-04 21:26:24,897 INFO [AIF]: Data Rows Updated by Location Mapping 'TG_00000000' (LIKE): 28
2019-03-04 21:26:24,911 INFO [AIF]:
Stage Data for Period 'December 2019'
2019-03-04 21:26:24,914 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 13
2019-03-04 21:26:24,918 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 13
2019-03-04 21:26:24,923 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 13
2019-03-04 21:26:24,929 INFO [AIF]: Executing delete statement:
2019-03-04 21:26:24,939 INFO [AIF]: Successfully executed delete statement
2019-03-04 21:26:24,939 INFO [AIF]: Number of Rows deleted from TDATASEG: 28
2019-03-04 21:26:24,944 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0
2019-03-04 21:26:24,947 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0
2019-03-04 21:26:24,951 INFO [AIF]: Executing insert statement:
2019-03-04 21:26:24,962 INFO [AIF]: Successfully executed insert statement
2019-03-04 21:26:24,962 INFO [AIF]: Number of Rows inserted into TDATASEG: 28
2019-03-04 21:26:24,967 INFO [AIF]: Executing delete statement:
2019-03-04 21:26:24,976 INFO [AIF]: Successfully executed delete statement
2019-03-04 21:26:24,976 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 28
2019-03-04 21:26:25,040 INFO [AIF]: -------END IMPORT STEP-------
2019-03-04 21:26:25,093 INFO [AIF]: -------START VALIDATE STEP-------
2019-03-04 21:26:25,152 INFO [AIF]:
Validate Data Mappings for Period 'December 2019'
2019-03-04 21:26:25,174 INFO [AIF]: Total Data Rows available for Export to Target: 28
2019-03-04 21:26:25,177 INFO [AIF]:
Validate Data Members for Period 'December 2019'
2019-03-04 21:26:25,179 INFO [AIF]: Total Data Rows available for Export to Target: 28
2019-03-04 21:26:25,231 INFO [AIF]: -------END VALIDATE STEP-------
2019-03-04 21:26:25,391 INFO [AIF]: -------START EXPORT STEP-------
2019-03-04 21:26:25,478 INFO [AIF]: Name of the output data file: /u03/inbox/outbox/GlBudgetInterface_BR_468.dat
2019-03-04 21:26:25,517 INFO [AIF]: Total number of data records exported: 1
2019-03-04 21:26:25,518 INFO [AIF]: Executing the following script: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py
2019-03-04 21:26:25,533 INFO [AIF]: FusionCloudAdapter.exportDataToFusion - START
2019-03-04 21:26:25,533 INFO [AIF]: FusionCloudAdapter.fusionCloudHelper - START
2019-03-04 21:27:47,687 INFO [AIF]: Standard Output: INFO: Starting script FusionCloudAdapter...
PBCS Production Deployment setup proxy
Starting FusionAdapter main program...
prod mode: exportDataToFusion, pid: 468
Initializing FusionAdapter in prod mode...
fusionIntegrationType: V2
fusionGlWebServiceWsdl: https://-test.fa.us6.oraclecloud.com/fscmService/ErpIntegrationService?WSDL
fusionGlWebServiceUser: EPM.ERP
batchTimeoutInMinutes: 30
processFlow: WB
targetSourceSystemCCFlag: N
fusionProductType: GL
FusionAdapter initialized fine.
Getting data file produced by the data load process...
From getBalRuleLoadOutputFile() - outputFileFullName: /u03/inbox/outbox/GlBudgetInterface_BR_468.dat
Uploading data file GlBudgetInterface_BR_468.dat to UCM...
Uploaded data file GlBudgetInterface_BR_468.dat to UCM, documentId: 277103
Loading data file from UCM to interface table...
Loading data file from UCM to interface table, Ess request: 213231
Current polled request status is: WAIT
Current polled request status is: SUCCEEDED
Ess request has completed fine.
Loading data from interface table to cube...
Loading data from interface table to cube, Ess request: 213234
Current polled request status is: WAIT
Current polled request status is: READY
Current polled request status is: ERROR
Merging Ess request log with the process log, Ess request: 213234
Document Name: 213234.zip
Downloading file: /u02/user_projects/instance0/tmp/213234.log
downloadedLogFileFullName: /u02/user_projects/instance0/tmp/213234.log
-------------------------------------------------------- BEGIN: Process Log From the Ess Job --------------------------------------------------------
Request for cubeCreation running with request ID: 213234
Parameters for this request are:
Parameter Name: numberOfArgs Parameter value: 15
Parameter Name: jobDefinitionName Parameter value: ValidateAndLoadBudgets
Parameter Name: SYS_preProcess Parameter value: oracle.apps.fnd.applcp.request.exec.CPPreProcessHandler
Parameter Name: jobPackageName Parameter value: /oracle/apps/ess/financials/generalLedger/ledgers/ledgerDefinitions
Parameter Name: currentSubRequestId Parameter value: 0
Parameter Name: cpAsynchJobWrapper Parameter value: oracle.apps.fnd.applcp.request.exec.AsyncExecutableWrapper
Parameter Name: shadowClassName Parameter value: oracle.apps.financials.generalLedger.ledgers.ledgerDefinitions.ess.program.ValidateAndLoadBudgets
Parameter Name: SYS_className Parameter value: oracle.apps.fnd.applcp.request.exec.ExecutableWrapper
Parameter Name: SYS_workDirectoryRoot Parameter value: /u01/APPLTOP/instance/ess/rfd/213234
Parameter Name: parametersVO Parameter value: oracle.apps.financials.generalLedger.ledgers.ledgerDefinitions.publicEssModel.view.ValidateAndLoadBudgetsParamsVO
Parameter Name: SYS_request_timeout Parameter value: 0
Parameter Name: SYS_groupName Parameter value: ESS_DefaultIsolationGroup
Parameter Name: SYS_inputWorkDirectory Parameter value: /u01/APPLTOP/instance/ess/rfd/213234/input
Parameter Name: SYS_submittingApplication Parameter value: FscmEss
Parameter Name: parentRequest Parameter value: 0
Parameter Name: SYS_product Parameter value: GL
Parameter Name: SYS_extensionListener Parameter value: oracle.apps.fnd.applcp.request.postprocess.CPEventListener
Parameter Name: SYS_redirectedOutputFile Parameter value: /u01/APPLTOP/instance/ess/rfd/213234/log/213234.log
Parameter Name: logLevel Parameter value: 1
Parameter Name: oracle.apps.fnd.applcp.invokeIncrementProcIfPresent Parameter value: true
Parameter Name: SYS_application Parameter value: FscmEss
Parameter Name: SYS_logWorkDirectory Parameter value: /u01/APPLTOP/instance/ess/rfd/213234/log
Parameter Name: jobExecutesVirusScanOnLogFiles Parameter value: false
Parameter Name: srsFlag Parameter value: Y
For request parameter name: completionText, Value was null
Parameter Name: completionText Parameter value:
Parameter Name: SYS_executePast Parameter value: true
Parameter Name: SYS_priority Parameter value: 4
Parameter Name: SYS_postProcess Parameter value: oracle.apps.fnd.applcp.request.exec.CPPostProcessHandler
Parameter Name: SYS_effectiveApplication Parameter value: FscmEss
Parameter Name: cpSqlFileFlag Parameter value: F
Parameter Name: EXT_PortletContainerWebModule Parameter value: ORA_FSCM_UI
Parameter Name: SYS_userName Parameter value: EPM.ERP
Parameter Name: jobDefinitionApplication Parameter value: GL
Parameter Name: SYS_retries Parameter value: 0
Parameter Name: SYS_outputWorkDirectory Parameter value: /u01/APPLTOP/instance/ess/rfd/213234/out
Parameter Name: filePersistenceMode Parameter value: file
Parameter Name: submit.argument1 Parameter value: FDM-468
Parameter Name: jobExecutesVirusScanOnOutputFiles Parameter value: false
Parameter Name: SYS_requestExpiration Parameter value: 0
Parameter Name: aflogLevel Parameter value: N
Parameter Name: SYS_userFileDir Parameter value: /u01/APPLTOP/instance/ess/rfd
Parameter Name: SYS_reprocessDelay Parameter value: 5
For request parameter name: requestStepPath, Value was null
Parameter Name: requestStepPath Parameter value:
Parameter Name: cpJavaJobWrapper Parameter value: oracle.apps.fnd.applcp.request.exec.ExecutableWrapper
------------------------------------------
creating am with: Name: oracle.apps.financials.generalLedger.ledgers.essbase.publicModel.applicationModule.LedgerEssbaseAM Config: LedgerEssbaseAMLocal
Created Application module instance
ValidateAndLoadBudgets:....
getParameterValue: Start
Trying to retrieve param key submit.argument1
Retrieved value for param submit.argument1 as: FDM-468
getParameterValue: End
ValidateAndLoadBudgets: Run Name passed: FDM-468
ValidateAndLoadBudgets: Sequence passed : 41009
ValidateAndLoadBudgets: Calling procedure to load Prevalidate Budget Data
ValidateAndLoadBudgets: Error in Validating the Budget Load. Please check the ESS log
Releasing Root AM...
Pre Validating Budget Data Started for Run Name: FDM-468
Prevalidating Budget data errored. Error message: There exist multiple ledgers associated with different Chart Of Accounts and Calendar. All ledgers in a single run should be associated with the same Chart Of Accounts and Calendar
Los datos del presupuesto tienen varios libros mayores pero no un calendario común.
--------------------------------------------------------- END: Process Log From the Ess Job ---------------------------------------------------------
Deleting temporary file: /u02/user_projects/instance0/tmp/213234.log
The FusionAdapter main program has completed.
INFO: The script FusionCloudAdapter has failed as reported above.
2019-03-04 21:27:47,687 INFO [AIF]: Standard Error: java.lang.Exception: Ess request has completed with errors.
at com.hyperion.aif.fusion.FusionAdapter.pollEssRequestStatus(FusionAdapter.java:666)
at com.hyperion.aif.fusion.FusionAdapter.main(FusionAdapter.java:270)
2019-03-04 21:27:47,688 ERROR [AIF]: The script has failed to execute:
2019-03-04 21:27:47,690 FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
File "<string>", line 563, in executeJythonScript
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 154, in <module>
fusionCloudAdapter.exportDataToFusion()
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 60, in exportDataToFusion
self.fusionCloudHelper("exportDataToFusion")
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 120, in fusionCloudHelper
raise RuntimeError
RuntimeError
2019-03-04 21:27:47,691 FATAL [AIF]: Error in CommData.exportData
Traceback (most recent call last):
File "<string>", line 3859, in exportData
File "<string>", line 475, in executeFusionService
File "<string>", line 563, in executeJythonScript
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 154, in <module>
fusionCloudAdapter.exportDataToFusion()
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 60, in exportDataToFusion
self.fusionCloudHelper("exportDataToFusion")
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 120, in fusionCloudHelper
raise RuntimeError
RuntimeError
2019-03-04 21:27:47,838 FATAL [AIF]: Error in COMM Export Data
2019-03-04 21:27:47,847 INFO [AIF]: FDMEE Process End, Process ID: 468