Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creation of logic group - any limitation for the Criteria Value Field?

937632May 16 2012 — edited May 18 2012
I am trying to create simple logic groups in FDM (version 11.1.1.3 and 11.1.2.1). However, an error message displayed in the information bar.

Error: Error adding new record.
Detail: Data access error.

I clicked the "Add" button and created a logic group which contains *1,520* non-sequential source accounts in the Criteria Value Field (with In operator).
I have separated these source accounts with a comma and no spaces in between them. (Note: Operator = x, Value/Exp = 1, Seq = 0) I updated the grid. Then, the error message was displayed and the logic group creation was failed.

And then, I created a new logic group which contains only *100* non-sequential source accounts in the Criteria Value Field (with In operator).
I also separated them with a comma, no spaces and same setting. I updated the grid. And the logic group was added successfully.

Each source account contains 10 characters (alphabet and/or number).

I want to ask:
1. Is there any limitation in specifying source accounts (i.e.. no more than certain number of source accounts for each logic group) in the Criteria Value Field when creating simple logic group?

2. I am adding these logic groups by clicking the "Add" button one by one, is there faster way to do it (i.e.. upload an excel or csv file or source accounts specified)?

Thank you very much!
This post has been answered by JTF85 on May 17 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details