Thank you @JohnW-Oracle. Some corrupted cookies appear to have messed up the Sessions and Query Logs page so that I couldn't see anything on the screen. After clearing cookies I can see what you see. Scott

@JohnW-Oracle, I tried your instructions, but there is no option in OAC > Console > Sessions and Query Logs to set a logging level. However, a google search for "set log level to trace in oracle analytics cloud" gave the following: To set the log level to "Trace" in Oracle Analytics Cloud (OAC), the specific method depends…

My apologies for the late reply. I didn't think it would matter what the transaction types are, as there will be different combinations. However, one example would be accessing the corresponding SO line from a PO line.

Good morning @James Mendoza-Oracle . I marked the original question as having been answered but am hoping you can provide links to documentation that discuss how custom metrics with filters can be used to build time-based comparison. Please reply whether or not that is possible, either way. Thanks.

@James Mendoza-Oracle - is there any documentation on how, in the absence of the AGO function, custom metrics with filters can be used to build time-based comparisons? Thanks.

Thank you @James Mendoza-Oracle. That field only references the preceding transaction. To replicate what is possible in SuiteAnalytics Workbook, we need the field or fields that get back to the specific line on the preceding transaction from which each line was created.

Is access to the Previous Transaction Link not possible with the standard NSAW subject area datasets? If so, how have others gotten around this? Thanks.

Thank you @James Mendoza-Oracle. I couldn't find references in the documentation link (both links you provided go to the same documentation, just in two different systems) to either of the built-in time comparison functions you referenced for workbooks - Period-over-Period, or Year-over-Year. Since those aren't in the…

Thank you @Ayitah Tallada-Oracle .

Thank you @Shiela Marie Villaluz-Oracle. While DECIMAL(10,2) is not an allowed type for CAST, simply replacing the going from CAST(Age_months / 12 AS FLOAT) to CAST(Age_months / 12.0 AS FLOAT) did the trick. Much appreciated!

@Shiela Marie Villaluz-Oracle The issue is not with the float values only getting two decimal places but rather that the floats have no decimal places and are truncated to all integer values.

Is there anyway to augment the dataset to include this standard field?

Thank you Red. I would be happy to have the field displayed just not editable. However, I've tried versions of the form with Name/ID set to Disabled or Inline Text, and in both cases the field remains editable. Is that expected?

Thank you @Tigran Shahnazaryan . Based on your comment, I assume that just using the form and role settings can't get the desired result. I may look into the workflow option but want to keep the solution simple and not add complexity where it shouldn't be needed.

Thank you Francesca. I don't need an answer, I was just trying to pass along something I learned from a case with NetSuite Support regarding differences in system behavior when using a custom transaction link field and a native transaction link field. Is there a better method for posting helpful information for others?

There is a known issue when using TO_DATE on some Free-Form Text type fields, but that issue was closed by NetSuite Engineering as a "fact of life". It was originally encountered with the following formula: TO_DATE(CONCAT('01', SUBSTR({custom field ID}, -9)), 'DD Mon YYYY'). I guess closing it as a "fact of life" simply…

Thanks @Angelica Mae Segador-Oracle. I submitted a support case this morning and will provide an update on what is found.

Thank you @Tigran Shahnazaryan. I'll reach out to NetSuite support.

That did not work. I also tried that with Formula (Text) which is what I would expect should be used with a TO_CHAR() formula. This boils down to something very simple. I've confirmed the contents of the field and created a literal string that exactly matches those contents, as proven by a formula comparing the field with…

Angelica, Tigran's response does not address the problem. For some unknown reason, I cannot use the custom field in the TO_DATE() function, even though (1) it can be used in other functions, and (2) the TO_DATE() function works if the custom field is replaced with a literal string that exactly matches the contents of the…

Thanks Tigran. Formula (Text) with TO_DATE({custrecord_ctc_cw_contacts_lastupdated}, 'YYYY-MM-DD"T"HH24:MI:SS"Z"') also generates and error, but Formula (Text) with TO_DATE('2023-04-13T22:04:12Z', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') does not.

Yes. That was in the original post. Here is a summary of all of the formula tests done and the results. 1 - Reference to the field 2 - Reference using the field id 3 - Shows that the field value is equal to the literal string '2023-04-13T22:04:12Z' 4 - Shows that the TO_DATE() call with the literal string and format works…

Yes, I attempted the formula you provided as Formula(Text) because the outermost function was TO_CHAR(). Since that didn't work, it was necessary to figure out if the issue was with the inner portion of the formula. That's why I tried the different variations of TO_DATE() in my last comment as Formula(Date/Time). Those…

Thank you @Tigran Shahnazaryan. That also generates an error, but I believe it's because TO_DATE() requires a format when the string is not in a local format. For example, here are the results using literal strings. TO_DATE('2023-04-13T22:04:12Z') —> error TO_DATE('2023-04-13') —> error TO_DATE('04-13-2023') —> 4/13/2023…

OK. You can close the post. Since NetSuite knows that a script file in our system uses the call, I was hoping it would be possible to find out which one it was without having to reach out to everyone.

Thank you Richard. Is there anyway to find out which bundle is using the API call?

Thank you Richard. I know none of our internally developed scripts use the call. I am wondering if there is a way to find out what 3rd party scripts that are parts of bundles that have been installed could be using the call. That code can't be viewed or inspected. NetSuite sent an email saying that scripts in our instance…

Thanks Michelle. It's still confusing what is preventing the emails since without first turning on Marketing Automation the employees have no Soft Opt-Out setting. At this point though it doesn't matter. I'll just be sure to check the Opt-Out Override as I did with this last email. You may close the ticket.

Good morning Michelle. I first went to Lists > Relationships > Groups and defined a dynamic group of employees. To send an email, I open the group and choose the Bulk Merge subtab. However, when I then click email, the list of recipients is empty. However, If I click the Opt-Out Override, the recipient list is correct,…

Marketing Automation is not enabled, but there is no mention that the Mail Merge feature requires Marketing Automation. I don't want to enable that feature until we choose to use it. So the question now is, what Employee field is preventing me from sending emails from NetSuite to Employees using Mail Merge without having…