Skip to main content
Solved

Unable to remove a branch of a DOP Order | Receiving Error:ORA-01476: divisor is equal to zero

  • September 9, 2021
  • 6 replies
  • 1111 views

Shani Fernando
Hero (Employee)
Forum|alt.badge.img+11

Hi Community,

I'm receiving the following error while trying to remove a branch (level 1) from a TOP Level DOP Order.
(RMB on DOP Order ID 2 Line -> Remove Specific Branch(es))

Environment: APP10 Regional TEST LKP
 


Level 1 DOP Order is in cancelled state. After further analyzing, I noticed that the subsidiary DOP Orders are also cancelled.

1. Any idea what might cause the above mentioned oracle error when removing the mentioned branch?
Noticed that the Due Date of this DOP Order is in the past and the demand source is not mentioned in the DOP Header.

2. How to find the demand source when it is not mentioned under the Demand Tab of the DOP Header?

Thank you in advance.

-----------------------------------------------------------------------------

Not sure whether this is a bug in Core. I followed functional flow (but demand created via a customer order), and created the following DOP Header with the same TOP Level Part.

 

Then cancelled the level 1 DOP order and tried to remove the level 1 branch from top level DOP Order, and I was able to remove it without any error.

 

Best answer by Shani Fernando

Issue resolved by RnD.

Solution ID: 296681
Bug ID: 160889 (Severity 2)

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

6 replies

Shani Fernando
Hero (Employee)
Forum|alt.badge.img+11
  • Author
  • Hero (Employee)
  • 87 replies
  • September 10, 2021

Issue recreated in APP10 Regional TEST LKP

Reason: Operations of the level 1 DOP Part has been changed


Shani Fernando
Hero (Employee)
Forum|alt.badge.img+11
  • Author
  • Hero (Employee)
  • 87 replies
  • September 12, 2021

Issue recreated in Core Application when the following requirements are fulfilled,

- DOP Structure has more than 2 levels
- Operations of the level 1 DOP part has been changed (in the DOP Order window, DOP Order ID 2) after creating the DOP Structure
(New operations are different than the operations in the Routing of this part.)
- New operations set has more operations than the old operations set
- Overlapping of the new operations are less than 100%


Forum|alt.badge.img+1
  • Do Gooder
  • 2 replies
  • September 14, 2021

This error occurs when an expression is divided by zero. It is considered a logical error in Oracle. In ordinary arithmetic, the expression has no meaning, as there is no number which, multiplied by 0, gives a (a≠0), and so division by zero is undefined.


Forum|alt.badge.img+1
  • Do Gooder
  • 2 replies
  • September 17, 2021
Jaron wrote:

This error occurs when an expression is divided by zero. It is considered a logical error in Oracle. In ordinary arithmetic, the expression has no meaning, as there is no number which, multiplied by 0, gives a (a≠0), and so division by zero is undefined. upsers   This error occurs when an expression is divided by zero. It is considered a logical error in Oracle.

 

 


Shani Fernando
Hero (Employee)
Forum|alt.badge.img+11
  • Author
  • Hero (Employee)
  • 87 replies
  • September 24, 2021

Hi @Elisabeth55 , @Jaron ,

Thank you very much.
Yes, it seems there was no logic in the code to handle this specific functional flow.

This issue was fixed by RnD. 

Best Regards,
Shani


Shani Fernando
Hero (Employee)
Forum|alt.badge.img+11
  • Author
  • Hero (Employee)
  • 87 replies
  • Answer
  • September 24, 2021

Issue resolved by RnD.

Solution ID: 296681
Bug ID: 160889 (Severity 2)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings