Background Jobs - Re-execute works however Re-execute in background does not work.
Hi,
We have a problem with the background jobs. While a user releases a customer order the procedure creates a background job for the Customer_Order_Line_API.Calculate_Revenue__ procedure. This procedure throws an error while working in the background however when we re-execute the job works. Even if we Re-execute in the background manually from background jobs it gives an error. We created a new queue for this procedure but it still throws the same error. The screenshot of the error is below. What could be the problem? How can we solve it?
The error about combination rules.
Page 1 / 1
Hi
You are logon to IFS using “en” language. Background job is executed using different language(turkish?) based on queue settings. This is difference and it seems You faced application bug. This is common problem. Most of problems which I reported to RnD are related to hardcoded client values, etc.
Which update is it? Please show BG job queue settings.
Hi @knepiosko
We are using IFS 10 Update 14. I will try “en” as the language. The queue language was “tr” like below. Thank you. I will inform you.
@knepiosko hi,
I changed the language of the queue. The job waiting in the posted status. In my opinion due to language.
I think the customer order line release operation throws the jobs with the client's language. Do you have any idea?
Hi @hhy38
I believe this error is related to the data entered for the certain customer order.
You can try to release another customer order with correct data or previous data. If this customer order is released, you should look at the new customer order’s data.
If this customer order is not released, you should check Customer_Order_Line_API.Calculate_Revenue__.
Best Regards.
Hi @hhy38
Job is in state posted becasuse its language code is different than batch queue language code. Please remove language value from batch queue definition.
@knepiosko Hi,
I removed. Do you have any idea?
@nafismertapaydin Hi,
I will check. Nowadays, I am too busy. I can’t search deeply.
Hi @hhy38
I believe this error is related to the data entered for the certain customer order.
You can try to release another customer order with correct data or previous data. If this customer order is released, you should look at the new customer order’s data.
If this customer order is not released, you should check Customer_Order_Line_API.Calculate_Revenue__.
Best Regards.
I don’t think the problem is directly related to the customer. When we re-execute the job, it works. However, when we re-execute in the background, it throws an error.
Can you detail the behavior when click both Re-Execute in Background and Re-Execute if you open the client in Turkish ?
(As in, change your client language to Turkish, restart IFS, try both options again and tell us if the behavior remains the same or is now different for either of the options) ?
@SimonTestard Hi,
It's very strange. I logged in with the user’s account. Both options throw errors. I defined fnd_admin permission for the account. Still, it throws the same error. There shouldn’t be a problem with region settings, NLS_LANG, or charset. Because I am testing on the same computer, there should be a problem with the user account. But I couldn’t find it.
Hi,
I found the solution. I should have checked this first, but I checked it last.
The source of the problem is Finance User Groups. I arranged groups for users, and then I solved it.