When a specific user tries to load customers on the customer analysis screen, they receive the error “Invalid Table Name. Failed executing query (ORA-00903: invalid table name)”.This issue only affects this user who has all the permissions that seem necessary and on a test database can access this fine.When I look at the query being ran that throws the error, for the user the table name “ledger_item_cu_det_qry_cfv” is missing. For any other user this table name is present in the query and they can load customers on this screen. Any ideas?
I found code on here that allowed me to attach a document to an email. This worked fine but it uses COMMAND_SYS: PROCEDURE EMAIL_DOC(mailto_ varchar2,mailfrom_ varchar2,doc_class_ varchar2,doc_no_ varchar2,doc_rev_ varchar2,doc_sheet_ varchar2,title_ varchar2,subject_ varchar2,message_ varchar2) IS file_name_ VARCHAR2(2000); file_names_ VARCHAR2(2000); doc_type_ VARCHAR2(2000); f_ VARCHAR2(2000); error_msg_ VARCHAR2(32000); rec_ Plsqlap_Record_API.type_record_; doc_ref_ VARCHAR2(32000); CURSOR get_doc_reference IS SELECT doc_object_desc FROM DOC_REFERENCE_OBJECT WHERE doc_class = doc_class_ AND doc_no = doc_no_; BEGIN OPEN get_doc_reference; FETCH get_doc_reference INTO doc_ref_; IF get_doc_reference%FOUND THEN EDM_FILE_API.REFERENCE_EXIST(f_, doc_class_, doc_no_, doc_sheet_, doc_rev_,'VIEW'); IF f_
I am trying to show an error message in WADACO using “raise_application_error(-20101,’my error message’);” The error works normally outside of WADACO but inside WADACA the error doesn’t display properly Is there a different method to show a message in WADACO?
Hi, I am trying to create a before custom event (apps9) to check the expiry date entered by the user before the receive order dialog can finish. Does anyone know what view I need to set the custom event on for this to work?
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.