Hi, We got this error message while doing inter-company invoices. Does anyone know what it means? ORA-20105: Invoice.ACCERROR1: Error (No Tax Invoice Series defined for series CUPAY and branch %.) occurred while booking Invoice CD 103543 There were no error messages for the invoices that had an amount, it was just the zero-amount invoices that got this error message. Best regards, Tarjei
Hello, I have been asked to set up a Custom Event that should notify or stop the user (info message / error message) when they try to save a new object based on the values in one custom field, and another standard IFS field. Both exist in separate tables, as you would expect (e.g. NCR_TAB and NCR_CFT). I get this to work on existing objects, either through querying the field directly in the event action, or through the custom attributes in the event. However, in this case I want the event to be triggered when the new object is created, which means that the row does not yet exist in either table / view. Upon testing this this is what I’ve observed: If it is a new object (row), I get no value from the custom attribute If it is NOT a new object, and I have changed the CF$_SOME_FIELD value, I get the previous value If it is NOT a new object, and I have NOT changed the CF$_SOME_FIELD value, I get the correct one It makes sense to me that it works like this, but I am just wonderin
Hello, I have made an event that throws an error message to the user, using the error_sys.record_general function, based on some criteria set in the event, which triggers on a change in the status of the object. error_sys.record_general( 'SomeLogicUnit', 'SOMEERRORMSG: this is an error message'); I am in the process of creating another event that will change the status of the object, but I am wondering if it is possible to catch the exception raised in the other event, and handle it separately? Without handling the event, and running the event manually in a DBMS, the procedure completes, but returns ORA-20110: SomeLogicUnit.SOMEERRORMSG: this is an error message My event would look something like this: BEGIN --change status on object, which may cause an error to be raised in the other eventEXCEPTION WHEN ... THEN -- handle the exception raised from the other eventEND; If I specify “EXCEPTION WHEN others THEN … “ I will catch the error raised in the other event, but I won’t know t
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.