We are currently using APPS10 update 20We have a report rule working to generate a PDF file on a local server with an OutputFileName naming convention:INV_6302_IFS[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO].pdfThis works perfectlyI now want to add the invoice date as a string ‘YYYYDDMM’When I try to add the field I get no error but also no output.INV_6302_IFS[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE].pdf Assuming this is because of the date format being pulled from the field but how do I change it. Any help appreciatedAction properties:
We are trying to create a copy of a customer invoice at the point of creation to be saved as a PDF on a file server external to IFS.I created a report rule as below but when i generate an invoice no file is created.I get no errors in the Report Rule Log.Any help appreciated
I am looking to extract the email addresses from user accounts in sqldeveloper but do not know the location of the field.Using version 10It is showing on the create User screen but system info shows only as Control: textboxEmailWhats this ID: labelEmail.Any help appreciated
I’m pulling a phone number from Apps8 in Crystal Reports using the following code on an SQL Expession Field(Select Value from prin1app.comm_Method WhereCompany_ID ="CUST_STMT_ACCT_REP"."COMPANY" AND Party_type = 'Company' ANDMethod_ID = 'Phone' ANDMethod_Default = 'TRUE') I get an ORA-00904 invalid identifier for the reference "CUST_STMT_ACCT_REP"."COMPANY" even though this has been selected from the list of fields in the view. The statement works perfectly from different views or if I use a value Company_ID = ‘7’
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.