Error Integrating Fusion with PBCS

Robert Coronel

Hi everyone,

Im traying to integrate Fusion GL to PBCS, but when I run the rule I am getting this error:

2015-08-19 15:50:28,771 INFO  [AIF]: FDMEE Process Start, Process ID: 150

2015-08-19 15:50:28,772 INFO  [AIF]: FDMEE Logging Level: 4

2015-08-19 15:50:28,772 INFO  [AIF]: User:rcoronel

2015-08-19 15:50:28,772 INFO  [AIF]: Location:Transfer_From_GL (Partitionkey:13)

2015-08-19 15:50:28,772 INFO  [AIF]: Period Name:Aug-15 (Period Key:8/1/15 12:00 AM)

2015-08-19 15:50:28,772 INFO  [AIF]: Category Name:Escenario (Category key:5)

2015-08-19 15:50:28,772 INFO  [AIF]: Rule Name:Test (Rule ID:21)

2015-08-19 15:50:31,141 INFO  [AIF]: FDM Version: 11.1.2.4.000

2015-08-19 15:50:31,141 INFO  [AIF]: Log File Encoding: UTF-8

2015-08-19 15:50:32,441 INFO  [AIF]: -------START IMPORT STEP-------

2015-08-19 15:50:32,697 INFO  [AIF]: Executing the following script: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py

2015-08-19 15:50:35,964 ERROR [AIF]: The script has failed to execute:

2015-08-19 15:50:35,966 FATAL [AIF]: Error in Comm.executeJythonScript

Traceback (most recent call last):

  File "<string>", line 528, in executeJythonScript

  File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 147, in <module>

    fusionCloudAdapter.importDataFromFusion()

  File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 51, in importDataFromFusion

    raise RuntimeError

RuntimeError

2015-08-19 15:50:36,066 FATAL [AIF]: Error in COMM Pre Import Data

2015-08-19 15:50:36,071 INFO  [AIF]: FDMEE Process End, Process ID: 150

I think there may be an issue with the source configuration (url configuration), I am using this:

https://ebzm-test.login.us2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL

Do you know if there is a way to validate this url??

Thanks...

Regards

Roberto Coronel

Robert Coronel

For the record... its a bug:

"Bug 21555271 - PBCS: IMPORT FROM FUSION GL ISSUE

Currently the bug is in unpublished status so you will not be able to view the details available. "

The development team have confirmed that this issue has get fixed in the version 15.08.83 were the FusionCloudAdapter.sh file get modified to specify proxy port as 80 instead of 443.

Regards.

RC

2959599

I'm facing the same. Did you find any break-through?

Thanks,

Sathish Radhakrishnan

2959599

The URL seems to be incorrect. Also, try creating the same process using a flat file load. It works

Regards,
Sathish Radhakrishnan

Robert Coronel

Actually I already have it configurated (Flat File), but ideally, direct communication between GL and Planning should be working. I am about to create an SR and leave it to Oracle

Btw... You mention that my URL is probably wrong , how do you think it would be correct??

Robert Coronel

New URL https://ebzm-test.fin.us2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL

At least this show something. So.... The error is caused by something else

Venkat Chowdary

Hi,

How are you integrating Fusion GL to Planning, is it through extracting the file from Fusion GL and placing the PID in FDMEE Rule.

If so what is the directory that you are giving, give it as all small letters as inbox.

And set the log level to 5 in user settings, so that error would be briefly elobrated.

Regards,

SR

Robert Coronel

Yes, that is exactly how i did it. 

Log level 5 give this line:

  2015-08-27
15:05:14,400 DEBUG [AIF]: stdErrData: javax.xml.ws.soap.SOAPFaultException:
FailedAuthentication : The security token cannot be authenticated.

The message is quite clear "FailedAuthentication : The security token cannot be authenticated"... There should be something wrong with security, maybe I need a specific role.

Thanks... 

Robert Coronel

For the record... its a bug:

"Bug 21555271 - PBCS: IMPORT FROM FUSION GL ISSUE

Currently the bug is in unpublished status so you will not be able to view the details available. "

The development team have confirmed that this issue has get fixed in the version 15.08.83 were the FusionCloudAdapter.sh file get modified to specify proxy port as 80 instead of 443.

Regards.

RC