{"id":299,"date":"2023-10-14T02:15:33","date_gmt":"2023-10-14T02:15:33","guid":{"rendered":"https:\/\/e360hospitality.com\/?p=299"},"modified":"2023-10-17T17:07:15","modified_gmt":"2023-10-17T17:07:15","slug":"rep-1213-field-references-column-at-a-frequency","status":"publish","type":"post","link":"https:\/\/e360hospitality.com\/opera-pms-technical\/rep-1213-field-references-column-at-a-frequency\/","title":{"rendered":"REP-1213: Field references column at a frequency below its group in Oracle Reports."},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">REP-1213 simply means, in your report layout, you&#8217;re using\/referring to a field within a Repeating Frame but the source query of this Repeating Frame does not contain this field.<\/h4>\n\n\n\n<p>To understand this error in detail, we have built a tiny sample report. Let&#8217;s see that below:<\/p>\n\n\n\n<p>Our sample report uses two tables to generate the report. We have an employee NAMES table from <a href=\"https:\/\/e360hospitality.com\/opera-pms-technical\/simplifying-opera-pms-api-integration\/\" target=\"_blank\" rel=\"noopener\" title=\"Opera PMS interface\">Opera PMS database<\/a> and an employee phone table called, NAME_PHONE. The report output should look like this:<\/p>\n\n\n\n<p>And, our queries look like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"1120\" height=\"617\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=1120%2C617&#038;ssl=1\" alt=\"rep-1213, oracle report error list\" class=\"wp-image-306\" style=\"aspect-ratio:1.8152350081037276;width:840px;height:auto\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?w=1120&amp;ssl=1 1120w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=500%2C275&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=300%2C165&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=768%2C423&amp;ssl=1 768w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=136%2C75&amp;ssl=1 136w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=480%2C264&amp;ssl=1 480w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-queries.jpg?resize=800%2C441&amp;ssl=1 800w\" sizes=\"(max-width:767px) 480px, (max-width:1120px) 100vw, 1120px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Notice that we have linked both tables in using the field, NAME_ID. To see the link details, double-click on the arrow line. The Property Inspector opens with the details. Just make a note of it for now and close.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"1127\" height=\"453\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=1127%2C453&#038;ssl=1\" alt=\"rep-1213\" class=\"wp-image-307\" style=\"aspect-ratio:2.487858719646799;width:840px;height:auto\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?w=1127&amp;ssl=1 1127w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=500%2C201&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=300%2C121&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=768%2C309&amp;ssl=1 768w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=150%2C60&amp;ssl=1 150w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=480%2C193&amp;ssl=1 480w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-link-details.jpg?resize=800%2C322&amp;ssl=1 800w\" sizes=\"(max-width:767px) 480px, (max-width:1127px) 100vw, 1127px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>And, out Paper Layout is below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1028\" height=\"600\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=1028%2C600&#038;ssl=1\" alt=\"\" class=\"wp-image-311\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?w=1028&amp;ssl=1 1028w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=500%2C292&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=300%2C175&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=768%2C448&amp;ssl=1 768w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=129%2C75&amp;ssl=1 129w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=480%2C280&amp;ssl=1 480w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/image-1.png?resize=800%2C467&amp;ssl=1 800w\" sizes=\"(max-width:767px) 480px, (max-width:1028px) 100vw, 1028px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<ul>\n<li>Main Frame, M_G_NAME_ID_GRPFR covering all report objects.<\/li>\n\n\n\n<li>Inner Frame, M_G_NAME_ID_HDR containing report column titles (text\/boilerplate type)<\/li>\n\n\n\n<li>A Repeating Frame, R_G_NAME_ID, containing all data fields from the queries.<\/li>\n<\/ul>\n\n\n\n<p>Here, it is important to note the source of the Repeating Frame: currently, set to<strong> G_NAMES<\/strong> query.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"921\" height=\"573\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=921%2C573&#038;ssl=1\" alt=\"\" class=\"wp-image-312\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?w=921&amp;ssl=1 921w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=500%2C311&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=300%2C187&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=768%2C478&amp;ssl=1 768w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=121%2C75&amp;ssl=1 121w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=480%2C299&amp;ssl=1 480w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame-source.jpg?resize=800%2C498&amp;ssl=1 800w\" sizes=\"(max-width:767px) 480px, (max-width:921px) 100vw, 921px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>If you run the report, you get the below error:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"903\" height=\"212\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=903%2C212&#038;ssl=1\" alt=\"\" class=\"wp-image-313\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?w=903&amp;ssl=1 903w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=500%2C117&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=300%2C70&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=768%2C180&amp;ssl=1 768w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=150%2C35&amp;ssl=1 150w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=480%2C113&amp;ssl=1 480w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-error.jpg?resize=800%2C188&amp;ssl=1 800w\" sizes=\"(max-width:767px) 480px, (max-width:903px) 100vw, 903px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>To resolve REP-1213:<\/strong><\/h3>\n\n\n\n<p>To resolve, Options A: You can add a new Repeating Frame inside the main frame and set the source to sub-query. Option B:  Change the source of the existing Repeating Frame to the sub-query. The report output differs as explained below.<\/p>\n\n\n\n<p><strong>Option A<\/strong>: Add a <a href=\"https:\/\/e360hospitality.com\/opera-pms-technical\/simplifying-opera-pms-api-integration\/\" target=\"_blank\" rel=\"noopener\" title=\"\">Repeating Frame<\/a> with its source set to G_PHONE_NUMBER inside the other Repeating Frame like below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1076\" height=\"528\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=1076%2C528&#038;ssl=1\" alt=\"\" class=\"wp-image-315\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?w=1076&amp;ssl=1 1076w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=500%2C245&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=300%2C147&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=768%2C377&amp;ssl=1 768w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=150%2C75&amp;ssl=1 150w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=480%2C236&amp;ssl=1 480w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/rep-1213-repeating-frame.jpg?resize=800%2C393&amp;ssl=1 800w\" sizes=\"(max-width:767px) 480px, (max-width:1076px) 100vw, 1076px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"629\" height=\"267\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-1.jpg?resize=629%2C267&#038;ssl=1\" alt=\"\" class=\"wp-image-316\" style=\"aspect-ratio:2.355805243445693;width:410px;height:auto\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-1.jpg?w=629&amp;ssl=1 629w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-1.jpg?resize=500%2C212&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-1.jpg?resize=300%2C127&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-1.jpg?resize=150%2C64&amp;ssl=1 150w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-1.jpg?resize=480%2C204&amp;ssl=1 480w\" sizes=\"(max-width:767px) 480px, 629px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Option B<\/strong>: Instead of adding a Repeating Frame inside the main RF, just change the source of the main Repeating Frame to  G_PHONE_NUMBER (from G_NAMES before). However, the output would be different:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"612\" height=\"268\" src=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-2.jpg?resize=612%2C268&#038;ssl=1\" alt=\"rep-1213 error\" class=\"wp-image-317\" style=\"aspect-ratio:2.283582089552239;width:393px;height:auto\" srcset=\"https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-2.jpg?w=612&amp;ssl=1 612w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-2.jpg?resize=500%2C219&amp;ssl=1 500w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-2.jpg?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-2.jpg?resize=150%2C66&amp;ssl=1 150w, https:\/\/i0.wp.com\/e360hospitality.com\/wp-content\/uploads\/2023\/10\/output-option-2.jpg?resize=480%2C210&amp;ssl=1 480w\" sizes=\"(max-width:767px) 480px, 612px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Hope it helps.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>REP-1213 simply means, in your report layout, you&#8217;re using\/referring to a field within a Repeating Frame but the source query of this Repeating Frame does not contain this field. To<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"ub_ctt_via":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[19,18,33],"aioseo_notices":[],"featured_image_src":null,"author_info":{"display_name":"Staff Writer","author_link":"https:\/\/e360hospitality.com\/author\/staff-writer\/"},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","wps_subtitle":"","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts\/299"}],"collection":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/comments?post=299"}],"version-history":[{"count":5,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts\/299\/revisions"}],"predecessor-version":[{"id":362,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts\/299\/revisions\/362"}],"wp:attachment":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/media?parent=299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/categories?post=299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/tags?post=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}