SchemaValidationErrors in GLCrossRef (Doc ID 2871570.1)

Last updated on OCTOBER 26, 2023

Applies to:

Goal

While Uploading GL Cross Reference in MFCS or ReSA, below error thrown:

Error:
SchemaValidationErrors [1] for OUTBOUND : com.oracle.retail.integration.base.bo.glacctcolref.v1.GLAcctColRef 


Upon checking further, RFI side "GLAccount" adapter log has the following errors:

...
2022-05-18T20:06:24,530 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO RfiCfinGlAccountValidationService - Initializing Account Combination Service
2022-05-18T20:06:24,532 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CredentialStoreManager - Extracting userName(<User>) for key/userNameAlias(glAccountValidationEndPointUserAlias).
2022-05-18T20:06:24,534 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CredentialStoreManager - Extracting password for key/userNameAlias(glAccountValidationEndPointUserAlias).
.....
2022-05-18T20:06:24,560 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG RfiCfinGlAccountValidationService - Calling AccountCombinationService using endpoint url as https://<CFIN_HostName>/fscmService/AccountCombinationService
...
2022-05-18T20:06:24,566 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO RfiCfinGlAccountValidationService - Validating Chart of Accounts against CFIN
2022-05-18T20:06:25,274 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR GlAccountValidationServiceProviderImpl - Error while validating GLAccount
com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: Unauthorized
...

and RMSAccountEntry.log has below error:

2022-05-19T04:55:07,272 [Timer-9] DEBUG ErpIntegrationServiceConsumer - Calling FinancialUtilService using endpoint url as https://<CFIN_HostName>/fscmService/ErpIntegrationService
2022-05-19T04:55:07,273 [Timer-9] INFO ErpIntegrationServiceConsumer - Service security policy configuration complete
2022-05-19T04:55:07,273 [Timer-9] INFO ErpIntegrationServiceConsumer - Uploading zip file to UCM
2022-05-19T04:55:10,379 [Timer-9] ERROR ErpIntegrationServiceConsumer - Exception occurred while invoking service.
com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: Unauthorized
....
2022-05-19T04:55:10,381 [Timer-9] ERROR ErpIntegrationServiceConsumer - Failed to connect to CFIN service. Marking file status as N, as file did not reach CFIN.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.