I would like to create a '’Serial Object” from an external application. So in fact I would like to call the next procedure: DECLARE p0_ VARCHAR2(32000) := NULL; p1_ VARCHAR2(32000) := NULL; p2_ VARCHAR2(32000) := NULL; p3_ VARCHAR2(32000) := 'MCH_CODE'||chr(31)||'PH'||chr(30)||'CONTRACT'||chr(31)||'100'||chr(30)||'SUP_CONTRACT'||chr(31)||'100'||chr(30)||'MCH_TYPE'||chr(31)||'07020'||chr(30)||'PART_NO'||chr(31)||'PHDOS001'||chr(30)||'SERIAL_NO'||chr(31)||'SN123456'||chr(30)||'PRODUCTION_DATE'||chr(31)||'2020-06-19-00.00.00'||chr(30)||'ITEM_CLASS_ID'||chr(31)||''||chr(30)||'OWNERSHIP'||chr(31)||'Company Owned'||chr(30)||'SAFE_ACCESS_CODE'||chr(31)||'Not Required'||chr(30)||'PM_PROG_APPLICATION_STATUS'||chr(31)||'FALSE'||chr(30); p4_ VARCHAR2(32000) := 'DO'; BEGIN IFSAPP.EQUIPMENT_SERIAL_API.NEW__( p0_ , p1_ , p2_ , p3_ , p4_ );END;
Thanks for the response The reason code is only available for the corrected (new) line and not for the original one. So that will not work for us We just figured out another solution, which is working for us. We have added a Custom field 'Skip_Line_Print’ on the invoice lines. When the amount of the original and new line is unchanged in case of a correction invoice, there is no correction,so we set the field 'Skip_Line_Print’ :='Y’. Now we have changed the Layout of the document. Only lines with nvl('Skip_Line_Print’ ,'N') <> 'Y 'are printed. Regards, Peter
Already have an account? Login
No account yet? Create an account
Enter your username or 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.