<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Aimpex Resources Group LLC</title>
    <description>The latest articles on DEV Community by Aimpex Resources Group LLC (@aimpexresources).</description>
    <link>https://dev.to/aimpexresources</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4214305%2F817aea4f-390d-4185-a968-9d14b7de8fdc.png</url>
      <title>DEV Community: Aimpex Resources Group LLC</title>
      <link>https://dev.to/aimpexresources</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/aimpexresources"/>
    <language>en</language>
    <item>
      <title>The STEM OPT 12-Month Evaluation Is Separate From the Six-Month Check-In</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Mon, 16 Nov 2026 13:43:18 +0000</pubDate>
      <link>https://dev.to/aimpexresources/the-stem-opt-12-month-evaluation-is-separate-from-the-six-month-check-in-152g</link>
      <guid>https://dev.to/aimpexresources/the-stem-opt-12-month-evaluation-is-separate-from-the-six-month-check-in-152g</guid>
      <description>&lt;p&gt;STEM OPT has more than one kind of report, and they are easy to mix up. The six-month check-in updates a school record. The 12-month evaluation is a signed section of Form I-983, and it has its own deadline.&lt;/p&gt;

&lt;p&gt;Some quick terms first. Optional Practical Training, or OPT, is work permission for some F-1 students after they finish a program. STEM OPT is a 24-month extension of post-completion OPT, limited to some science, technology, engineering and mathematics degrees. Form I-983 is the "Training Plan for STEM OPT Students." A Designated School Official, or DSO, is the school officer who keeps the student's record in the Student and Exchange Visitor Information System. That system is known as SEVIS. U.S. Citizenship and Immigration Services, known as USCIS, is the agency that approves or denies the work-permit card.&lt;/p&gt;

&lt;p&gt;This article comes from Aimpex Resources Group LLC. Our Lincoln, NE team works in ERP Architecture and IT staffing, and we often speak with people on STEM OPT. The 12-month evaluation is one of the deadlines that gets missed because it sits on a different form from the six-month check-in.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the problem look like?
&lt;/h2&gt;

&lt;p&gt;Here is a typical story. A student on STEM OPT completed the six-month validation with their DSO, confirmed their address and employer, and thought the year's reporting was finished. A few weeks after the 12-month mark, the DSO asked for the annual self-evaluation on Form I-983. It had to be signed by both the student and an employer official. The official who had to sign was away, and the 10-day window after the 12-month date was already running.&lt;/p&gt;

&lt;p&gt;The six-month check-in and the 12-month evaluation are both required. Completing one of them does not close out the other.&lt;/p&gt;

&lt;h2&gt;
  
  
  How is the six-month check-in different?
&lt;/h2&gt;

&lt;p&gt;The &lt;a href="https://studyinthestates.dhs.gov/stem-opt-hub/for-students/students-stem-opt-reporting-requirements" rel="noopener noreferrer"&gt;Study in the States page on STEM OPT reporting for students&lt;/a&gt; (last updated July 6, 2026) describes two tracks.&lt;/p&gt;

&lt;p&gt;The first is "Validating SEVIS Information." "Every six months a student must work with their DSO to confirm that the student's record in SEVIS accurately reflects their current circumstance." The items to confirm are legal name, residential or mailing address, employer name and address, and the status of current employment. A change in that information, "including any loss of employment," must be reported "within 10 days of the change."&lt;/p&gt;

&lt;p&gt;That six-month validation is a check of the SEVIS record. It is not the annual evaluation on Form I-983.&lt;/p&gt;

&lt;h2&gt;
  
  
  What is the 12-month evaluation?
&lt;/h2&gt;

&lt;p&gt;The same page has a section titled "Annual Self-Evaluations." "Each STEM OPT student must complete and submit to their DSO an annual self-evaluation describing the progress of the training experience." The student must make sure "that the DSO receives the assessment no later than 10 days following the conclusion of the training period." The assessments themselves are:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;"Initial: 12 months after the STEM OPT start date," and&lt;/li&gt;
&lt;li&gt;"Final assessment that recaps the training and knowledge acquired during the complete, 24 month training period."&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The &lt;a href="https://www.ice.gov/doclib/sevis/pdf/i983Instructions.pdf" rel="noopener noreferrer"&gt;Form I-983 instructions&lt;/a&gt; from U.S. Immigration and Customs Enforcement (ICE) say the same thing and add that this is shared work: "Student evaluations are a shared responsibility of the student and the employer." The student writes the evaluation. "The Employer Official with Signatory Authority" must sign it "to show concurrence with the assessment information that the student has entered." The &lt;a href="https://studyinthestates.dhs.gov/stem-opt-hub/for-employers/employers-and-the-form-i-983" rel="noopener noreferrer"&gt;Study in the States page for employers and Form I-983&lt;/a&gt; puts it this way: "the employer must review this evaluation and sign it to attest to its accuracy."&lt;/p&gt;

&lt;p&gt;&lt;a href="https://www.ice.gov/doclib/sevis/pdf/i983.pdf" rel="noopener noreferrer"&gt;Form I-983&lt;/a&gt; itself has two evaluation blocks: "Evaluation on Student Progress" and "Final Evaluation on Student Progress." A note on the form says the first evaluation is "to occur before the one year anniversary of the start date of the student's STEM OPT employment authorization."&lt;/p&gt;

&lt;h2&gt;
  
  
  When is the 10-day window, and what if the job ends early?
&lt;/h2&gt;

&lt;p&gt;Count 12 months from the STEM OPT start date, then 10 days after that. The ICE instructions say: "The student must submit the 12-month and final evaluations no later than 10 days following the conclusion of the appropriate reporting period."&lt;/p&gt;

&lt;p&gt;If the training ends early, the final evaluation is due sooner. The instructions say: "If a training opportunity ends early, the student must submit the final evaluation within 10 days following the conclusion of the training." The student reporting page repeats this and adds: "Not submitting a final evaluation would be a violation of the terms of the Form I-983, 'Training Plan for STEM OPT Students,' and may jeopardize the student's nonimmigrant status."&lt;/p&gt;

&lt;p&gt;The reporting page also says SEVP Portal users "will receive a reminder via email 30 days before their self-evaluation is due." A reminder is helpful, but the deadline is still the one in the instructions. Track the 12-month date and the early-end date yourself. Give the employer official enough time to read and sign the evaluation before the 10 days run out.&lt;/p&gt;

&lt;h2&gt;
  
  
  What should you have in hand?
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;The STEM OPT start date, from the Employment Authorization Document (the EAD card) or the Form I-20 that recommended the extension.&lt;/li&gt;
&lt;li&gt;The "Evaluation on Student Progress" section of Form I-983, with a date range and a written self-evaluation.&lt;/li&gt;
&lt;li&gt;The student's signature and the employer official's signature, with printed names and dates, as the ICE instructions require.&lt;/li&gt;
&lt;li&gt;A way to get the signed pages to the DSO within 10 days after the 12-month date. If the training ends early, that window is 10 days after it ends.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The DSO keeps the completed evaluation in the student's record. The &lt;a href="https://www.uscis.gov/working-in-the-united-states/students-and-exchange-visitors/optional-practical-training-extension-for-stem-students-stem-opt" rel="noopener noreferrer"&gt;USCIS STEM OPT page&lt;/a&gt; and the &lt;a href="https://studyinthestates.dhs.gov/stem-opt-hub" rel="noopener noreferrer"&gt;STEM OPT Hub&lt;/a&gt; are the official starting points if you need the current form and the reporting pages.&lt;/p&gt;

&lt;p&gt;The six-month SEVIS check-in does not take the place of this evaluation. The evaluation is a signed Form I-983 section, and both the student and the employer official have to complete it on time.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://studyinthestates.dhs.gov/stem-opt-hub/for-students/students-stem-opt-reporting-requirements" rel="noopener noreferrer"&gt;Study in the States: Students, STEM OPT Reporting Requirements&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://studyinthestates.dhs.gov/stem-opt-hub/for-employers/employers-and-the-form-i-983" rel="noopener noreferrer"&gt;Study in the States: Employers and the Form I-983&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ice.gov/doclib/sevis/pdf/i983Instructions.pdf" rel="noopener noreferrer"&gt;ICE: Instructions for Form I-983&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ice.gov/doclib/sevis/pdf/i983.pdf" rel="noopener noreferrer"&gt;ICE: Form I-983, Training Plan for STEM OPT Students&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/working-in-the-united-states/students-and-exchange-visitors/optional-practical-training-extension-for-stem-students-stem-opt" rel="noopener noreferrer"&gt;USCIS: Optional Practical Training Extension for STEM Students&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://studyinthestates.dhs.gov/stem-opt-hub" rel="noopener noreferrer"&gt;Study in the States: STEM OPT Hub&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;This post is not legal advice from Aimpex Resources Group LLC. We are a staffing and consulting company, so we cannot review a student's Form I-983 or set a filing date. Ask your DSO and an immigration attorney to look at your STEM OPT start date, your I-983 evaluations and your school's deadlines together.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Based in Lincoln, NE and founded in 2025, Aimpex Resources Group LLC works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. The company operates as a Direct Vendor for Bank of America. We are a Verified Employer with active corporate sponsorship pathways for qualified STEM OPT and H-1B professionals. People comparing those STEM OPT pathways can read more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;. Sponsorship is never a promise of visa selection or approval.&lt;/p&gt;

</description>
      <category>immigration</category>
      <category>opt</category>
      <category>students</category>
      <category>career</category>
    </item>
    <item>
      <title>Oracle Fusion REST API Returns Only 25 Invoices? Page Through With limit, offset and hasMore</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Mon, 16 Nov 2026 05:42:14 +0000</pubDate>
      <link>https://dev.to/aimpexresources/oracle-fusion-rest-api-returns-only-25-invoices-page-through-with-limit-offset-and-hasmore-3887</link>
      <guid>https://dev.to/aimpexresources/oracle-fusion-rest-api-returns-only-25-invoices-page-through-with-limit-offset-and-hasmore-3887</guid>
      <description>&lt;p&gt;A REST call to Oracle Fusion Cloud ERP that returns exactly 25 rows is usually telling you something. For ERP Architecture teams at Aimpex Resources Group LLC, that number is a reason to check paging before anything else.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the problem look like?
&lt;/h2&gt;

&lt;p&gt;A team built an AI agent on the Payables invoices REST resource. When it asked for all invoices on one day, it got exactly 25 records and treated them as the full list, though there were many more.&lt;/p&gt;

&lt;p&gt;The team also saw different results from these two calls:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;/fscmRestApi/resources/11.13.18.05/invoices?orderBy=InvoiceDate:desc
/fscmRestApi/resources/11.13.18.05/invoices?orderBy=InvoiceDate:asc
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Both problems come from the same place: how Fusion REST returns a collection one page at a time.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why does the API stop at 25?
&lt;/h2&gt;

&lt;p&gt;Oracle's REST docs explain it in the section on navigating a collection: "Each call to a collection resource returns a fragment of the collection (a single page). The default size of the page is 25 items." (&lt;a href="https://docs.oracle.com/en/cloud/saas/human-resources/farws/Navigate_a_Collection.html" rel="noopener noreferrer"&gt;Oracle Fusion Cloud REST: Navigate a collection&lt;/a&gt;)&lt;/p&gt;

&lt;p&gt;The response tells you when there is more. The &lt;a href="https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-invoices-get.html" rel="noopener noreferrer"&gt;Get all invoices&lt;/a&gt; page describes &lt;code&gt;hasMore&lt;/code&gt; this way: "If the value is true, then there are more resources to retrieve from the server." A response that looks like this is a first page, not the full answer:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nl"&gt;"items"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt; &lt;span class="err"&gt;...&lt;/span&gt; &lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"count"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"hasMore"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;true&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"limit"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nl"&gt;"offset"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;So the tool read page one and stopped. The data was fine. The loop was missing.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you read every page?
&lt;/h2&gt;

&lt;p&gt;Oracle's rule is short: "To retrieve the next page of the collection, increase the offset by the limit value." And: "to retrieve all the items, you must repeat the process until hasMore is false."&lt;/p&gt;

&lt;p&gt;The invoices page adds one detail that is easy to miss. In the response, &lt;code&gt;limit&lt;/code&gt; is "The actual paging size used by the server." That may not be the number you asked for. Moving &lt;code&gt;offset&lt;/code&gt; by the server's &lt;code&gt;limit&lt;/code&gt;, not your own, keeps the loop from skipping rows.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why did asc and desc give different invoices?
&lt;/h2&gt;

&lt;p&gt;Sort order matters while paging. Oracle's Fusion collection docs say: "When you specify the limit and offset parameters, the paginated result isn't ordered. To ensure consistent results, use the orderBy parameter to order the results." (&lt;a href="https://docs.oracle.com/en/cloud/saas/industries/faraa/Manage_Collections.html" rel="noopener noreferrer"&gt;Manage collections&lt;/a&gt;)&lt;/p&gt;

&lt;p&gt;In the example above, &lt;code&gt;orderBy=InvoiceDate:desc&lt;/code&gt; and &lt;code&gt;InvoiceDate:asc&lt;/code&gt; return the first 25 rows of two different sort orders, so they show different invoices. On top of that, many invoices share the same &lt;code&gt;InvoiceDate&lt;/code&gt;, so the order inside one date is not fixed. For paging, sort on a unique key such as &lt;code&gt;InvoiceId&lt;/code&gt;. The same docs also warn: "If you update the collection resource between paging requests, the records displayed in each page may vary."&lt;/p&gt;

&lt;h2&gt;
  
  
  What does a full read look like in Python?
&lt;/h2&gt;

&lt;p&gt;The invoices page lists the query parameters this script uses: &lt;code&gt;q&lt;/code&gt; for the filter, &lt;code&gt;orderBy&lt;/code&gt;, &lt;code&gt;fields&lt;/code&gt;, &lt;code&gt;onlyData&lt;/code&gt;, &lt;code&gt;limit&lt;/code&gt; and &lt;code&gt;offset&lt;/code&gt;. Its example request uses basic authentication with &lt;code&gt;curl -i -u "&amp;lt;username&amp;gt;:&amp;lt;password&amp;gt;"&lt;/code&gt;, so the script does the same with &lt;code&gt;requests&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;

&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;

&lt;span class="no"&gt;BASE_URL&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FUSION_BASE_URL"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;  &lt;span class="c1"&gt;# for example https://servername.fa.us2.oraclecloud.com&lt;/span&gt;
&lt;span class="no"&gt;RESOURCE&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s2"&gt;"/fscmRestApi/resources/11.13.18.05/invoices"&lt;/span&gt;

&lt;span class="n"&gt;session&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;Session&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;session&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;auth&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FUSION_USER"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FUSION_PASSWORD"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;


&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;get_invoices_for_day&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;day&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;page_size&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;200&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;rows&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;offset&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;
    &lt;span class="k"&gt;while&lt;/span&gt; &lt;span class="kc"&gt;True&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="n"&gt;resp&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;session&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
            &lt;span class="no"&gt;BASE_URL&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="no"&gt;RESOURCE&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
            &lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;
                &lt;span class="s2"&gt;"q"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;f&lt;/span&gt;&lt;span class="s2"&gt;"InvoiceDate='{day}'"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
                &lt;span class="s2"&gt;"orderBy"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"InvoiceId:asc"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
                &lt;span class="s2"&gt;"fields"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"InvoiceId,InvoiceNumber,InvoiceDate,Supplier,InvoiceAmount"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
                &lt;span class="s2"&gt;"onlyData"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"true"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
                &lt;span class="s2"&gt;"limit"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;page_size&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
                &lt;span class="s2"&gt;"offset"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;offset&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
            &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
            &lt;span class="n"&gt;timeout&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;120&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;resp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;raise_for_status&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;body&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;resp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;json&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;rows&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;extend&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;body&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"items"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="ow"&gt;not&lt;/span&gt; &lt;span class="n"&gt;body&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"hasMore"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="ow"&gt;or&lt;/span&gt; &lt;span class="n"&gt;body&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"count"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
            &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;rows&lt;/span&gt;
        &lt;span class="n"&gt;offset&lt;/span&gt; &lt;span class="o"&gt;+=&lt;/span&gt; &lt;span class="n"&gt;body&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"limit"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;  &lt;span class="c1"&gt;# the page size the server actually used&lt;/span&gt;


&lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;__name__&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="s2"&gt;"__main__"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;invoices&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;get_invoices_for_day&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"2026-11-03"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nb"&gt;len&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;invoices&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"invoices"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;What each part does:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;q&lt;/code&gt;&lt;/strong&gt; filters on &lt;code&gt;InvoiceDate&lt;/code&gt;, which is listed as a queryable attribute on the invoices page. Check the date format against your own release before relying on it.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;orderBy=InvoiceId:asc&lt;/code&gt;&lt;/strong&gt; gives every page a fixed order, so no row moves between pages.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;fields&lt;/code&gt; and &lt;code&gt;onlyData&lt;/code&gt;&lt;/strong&gt; cut the payload down to the columns you need. Per the docs, &lt;code&gt;onlyData&lt;/code&gt; filters the payload "to contain only data (no links section, for example)."&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;offset += body["limit"]&lt;/code&gt;&lt;/strong&gt; follows Oracle's paging rule and uses the server's page size.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;The &lt;code&gt;count == 0&lt;/code&gt; check&lt;/strong&gt; is a guard so the loop can never spin on an empty page.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you need a total before you start, add &lt;code&gt;totalResults=true&lt;/code&gt;. The invoices page says the response then includes the "estimated row count", so treat it as a hint and still loop on &lt;code&gt;hasMore&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you test it before production?
&lt;/h2&gt;

&lt;p&gt;Run the loop against a day where you already know the invoice count from the Payables screens. Then check three things:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;The number of rows matches that known count.&lt;/li&gt;
&lt;li&gt;No &lt;code&gt;InvoiceId&lt;/code&gt; appears twice.&lt;/li&gt;
&lt;li&gt;The last response has &lt;code&gt;hasMore&lt;/code&gt; set to false.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If the count is short, look at the &lt;code&gt;q&lt;/code&gt; filter first. If there are duplicates, look at the sort key.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-invoices-get.html" rel="noopener noreferrer"&gt;Oracle: REST API for Oracle Fusion Cloud Financials, Get all invoices&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://docs.oracle.com/en/cloud/saas/human-resources/farws/Navigate_a_Collection.html" rel="noopener noreferrer"&gt;Oracle: Oracle Fusion Cloud REST, Navigate a collection&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://docs.oracle.com/en/cloud/saas/industries/faraa/Manage_Collections.html" rel="noopener noreferrer"&gt;Oracle: Oracle Fusion Cloud REST, Manage collections&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;Founded in 2025 and based in Lincoln, NE, Aimpex Resources Group LLC delivers ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. Its architects work across Oracle Cloud ERP, SAP S/4HANA and Microsoft Dynamics, including the integrations that pull Payables data into reports and tools. Teams building on Oracle Fusion REST can learn more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>oracle</category>
      <category>erp</category>
      <category>api</category>
      <category>python</category>
    </item>
    <item>
      <title>A New HttpClient on Every Call Exhausts TCP Ports. Reuse One Client, or Use IHttpClientFactory</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Sun, 15 Nov 2026 13:44:04 +0000</pubDate>
      <link>https://dev.to/aimpexresources/a-new-httpclient-on-every-call-exhausts-tcp-ports-reuse-one-client-or-use-ihttpclientfactory-596g</link>
      <guid>https://dev.to/aimpexresources/a-new-httpclient-on-every-call-exhausts-tcp-ports-reuse-one-client-or-use-ihttpclientfactory-596g</guid>
      <description>&lt;p&gt;A small .NET service can look healthy in a quiet test. Then it can fail on a busy morning because it opens a new network client for every call. The failure is often a shortage of TCP ports, not a bug in the ERP API it is calling.&lt;/p&gt;

&lt;p&gt;Some quick terms first. &lt;code&gt;HttpClient&lt;/code&gt; is the .NET class that sends HTTP requests and reads the replies. HTTP is the protocol used by most web and REST APIs. A connection pool is a set of open network connections that a client can reuse. TCP is the transport that carries those connections. After a connection closes, the operating system keeps its port in a short "TIME-WAIT" state, so the port cannot be used again at once. Domain Name System, or DNS, is the directory that maps a name such as &lt;code&gt;api.example.com&lt;/code&gt; to a network address.&lt;/p&gt;

&lt;p&gt;This write-up is from Aimpex Resources Group LLC. Our Lincoln, NE team works on ERP Architecture across SAP S/4HANA, Oracle Cloud ERP and Microsoft Dynamics. We place .NET engineers on the integrations that pull that data into other tools. A fresh &lt;code&gt;HttpClient&lt;/code&gt; on every request is one of the first things worth looking for in those services.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the problem look like?
&lt;/h2&gt;

&lt;p&gt;A team built a .NET service to pull purchase orders from an ERP REST API. The method that called the API created a new &lt;code&gt;HttpClient&lt;/code&gt; inside a &lt;code&gt;using&lt;/code&gt; block, sent one request, and disposed the client. In a short test this looked fine. After a long run of calls, new requests began to fail, and the machine showed a large number of TCP connections sitting in TIME-WAIT.&lt;/p&gt;

&lt;p&gt;The shape of the code was like this:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight csharp"&gt;&lt;code&gt;&lt;span class="k"&gt;public&lt;/span&gt; &lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="nc"&gt;Task&lt;/span&gt;&lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="kt"&gt;string&lt;/span&gt;&lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="nc"&gt;ReadOrdersAsync&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nc"&gt;Uri&lt;/span&gt; &lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="k"&gt;using&lt;/span&gt; &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;HttpClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;GetStringAsync&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each call built a new client, and each client had its own connection pool. Disposing the client closed the connections, and the ports then sat in TIME-WAIT.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why does a new client on every call run out of ports?
&lt;/h2&gt;

&lt;p&gt;Microsoft's page on &lt;a href="https://learn.microsoft.com/en-us/dotnet/fundamentals/networking/http/httpclient-guidelines" rel="noopener noreferrer"&gt;using HttpClient&lt;/a&gt; (last updated August 6, 2026) states the cause directly. "The connection pool for an HttpClient is linked to the underlying SocketsHttpHandler." A new client means a new pool. "Sending another request to the same server using a different handler requires a new connection." After a connection closes, "TCP ports aren't released immediately." Microsoft points to the TIME-WAIT behavior in &lt;a href="https://www.rfc-editor.org/rfc/rfc9293.html" rel="noopener noreferrer"&gt;RFC 9293&lt;/a&gt;. "If the rate of requests is high, the operating system limit of available ports might be exhausted."&lt;/p&gt;

&lt;p&gt;The official advice that follows is short: "To avoid port exhaustion problems, reuse HttpClient instances for as many HTTP requests as possible."&lt;/p&gt;

&lt;p&gt;There is a second trap if you reuse a client and never replace its connections. "HttpClient only resolves DNS entries when a connection is created. It doesn't track any time to live (TTL) durations specified by the DNS server." If the server's address changes, a client that keeps the old connection forever will still aim at the old address.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does Microsoft recommend?
&lt;/h2&gt;

&lt;p&gt;The same page sums up two safe lifetime patterns. "You should use either long-lived clients and set PooledConnectionLifetime (.NET Core and .NET 5+) or short-lived clients created by IHttpClientFactory."&lt;/p&gt;

&lt;p&gt;For .NET Core and .NET 5 or later, Microsoft's first pattern is a static or singleton &lt;code&gt;HttpClient&lt;/code&gt; with &lt;code&gt;PooledConnectionLifetime&lt;/code&gt; set to an interval you choose. Microsoft's examples use two or 15 minutes. The 15-minute figure in Microsoft's sample "was chosen arbitrarily for illustration purposes." You should pick a value that matches how often you expect DNS or network changes. After that interval, and after the connection's last request finishes, the connection is closed. The next request creates a new one, and DNS is read again. This "solves both the port exhaustion and DNS changes problems" without adding &lt;code&gt;IHttpClientFactory&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;Microsoft also says that a limited number of long-lived clients is acceptable. "What matters is that they're not created and disposed with each request, as they each contain a connection pool."&lt;/p&gt;

&lt;p&gt;On .NET Framework, Microsoft says to use &lt;code&gt;IHttpClientFactory&lt;/code&gt; to manage &lt;code&gt;HttpClient&lt;/code&gt; instances. "If you don't use the factory and instead create a new client instance for each request yourself, you can exhaust available ports."&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the long-lived fix look like in C#?
&lt;/h2&gt;

&lt;p&gt;This follows Microsoft's sample: one shared client, one handler, and a pooled-connection lifetime.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight csharp"&gt;&lt;code&gt;&lt;span class="k"&gt;static&lt;/span&gt; &lt;span class="k"&gt;readonly&lt;/span&gt; &lt;span class="nc"&gt;HttpClient&lt;/span&gt; &lt;span class="nc"&gt;SharedClient&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;HttpClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;SocketsHttpHandler&lt;/span&gt;
    &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="nc"&gt;PooledConnectionLifetime&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nc"&gt;TimeSpan&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;FromMinutes&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;15&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="k"&gt;public&lt;/span&gt; &lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="nc"&gt;Task&lt;/span&gt;&lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="kt"&gt;string&lt;/span&gt;&lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="nc"&gt;ReadOrdersAsync&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nc"&gt;Uri&lt;/span&gt; &lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="nc"&gt;SharedClient&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;GetStringAsync&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The client is created once and reused. Do not wrap &lt;code&gt;SharedClient&lt;/code&gt; in a &lt;code&gt;using&lt;/code&gt; statement on every call. Disposing that shared client would close the pool you are trying to keep.&lt;/p&gt;

&lt;p&gt;If the service talks to more than one host, or needs different settings, Microsoft says more than one long-lived instance is fine. The mistake is creating and disposing a client per request, not having two or three shared ones.&lt;/p&gt;

&lt;h2&gt;
  
  
  When should you use IHttpClientFactory instead?
&lt;/h2&gt;

&lt;p&gt;&lt;code&gt;IHttpClientFactory&lt;/code&gt; is a helper in the &lt;code&gt;Microsoft.Extensions.Http&lt;/code&gt; package. It creates &lt;code&gt;HttpClient&lt;/code&gt; instances and reuses the handlers behind them. Microsoft's &lt;a href="https://learn.microsoft.com/en-us/dotnet/core/extensions/httpclient-factory" rel="noopener noreferrer"&gt;IHttpClientFactory page&lt;/a&gt; (also last updated August 6, 2026) says the factory-created clients are meant to be short-lived, and that the factory "manages the caching and lifetime of underlying HttpClientHandler instances." Microsoft's &lt;a href="https://learn.microsoft.com/en-us/dotnet/fundamentals/networking/http/httpclient-guidelines" rel="noopener noreferrer"&gt;page on using HttpClient&lt;/a&gt; says that this reuse "avoids any socket exhaustion issues." It also avoids the DNS problem that shows up when a single client is kept forever.&lt;/p&gt;

&lt;p&gt;A typical ASP.NET Core registration looks like this:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight csharp"&gt;&lt;code&gt;&lt;span class="n"&gt;builder&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;Services&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;AddHttpClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;A service then asks for &lt;code&gt;IHttpClientFactory&lt;/code&gt; and creates a client when it needs one:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight csharp"&gt;&lt;code&gt;&lt;span class="k"&gt;public&lt;/span&gt; &lt;span class="k"&gt;sealed&lt;/span&gt; &lt;span class="k"&gt;class&lt;/span&gt; &lt;span class="nc"&gt;OrderReader&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nc"&gt;IHttpClientFactory&lt;/span&gt; &lt;span class="n"&gt;httpClientFactory&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="k"&gt;public&lt;/span&gt; &lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="nc"&gt;Task&lt;/span&gt;&lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="kt"&gt;string&lt;/span&gt;&lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="nc"&gt;ReadOrdersAsync&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nc"&gt;Uri&lt;/span&gt; &lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="nc"&gt;HttpClient&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;httpClientFactory&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;CreateClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
        &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;GetStringAsync&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This is safe because the factory, not the calling code, owns the handler and the pool. Creating a client from the factory on each call is the opposite of &lt;code&gt;new HttpClient()&lt;/code&gt; on each call.&lt;/p&gt;

&lt;p&gt;Microsoft warns that if the app relies on cookies, &lt;code&gt;IHttpClientFactory&lt;/code&gt; is a poor fit. Pooled handlers share a &lt;code&gt;CookieContainer&lt;/code&gt;, so cookies can leak between parts of the app, and cookies are lost when the handler is recycled. In that case, prefer the long-lived &lt;code&gt;HttpClient&lt;/code&gt; with &lt;code&gt;PooledConnectionLifetime&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you test it before production?
&lt;/h2&gt;

&lt;p&gt;Pick a call you can repeat against a test endpoint, and run it in a tight loop. First try a new &lt;code&gt;HttpClient&lt;/code&gt; on every call, and then try the shared client or the factory.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Watch the number of TCP connections in TIME-WAIT on the machine, for example with &lt;code&gt;netstat&lt;/code&gt; or &lt;code&gt;Get-NetTCPConnection&lt;/code&gt; in PowerShell. The per-request client should leave a growing pile of waiting ports. The shared or factory client should not.&lt;/li&gt;
&lt;li&gt;Confirm that later requests still succeed after several minutes, so you have passed at least one &lt;code&gt;PooledConnectionLifetime&lt;/code&gt; interval.&lt;/li&gt;
&lt;li&gt;If you use the factory and the API depends on cookies, confirm that cookies are not crossing from one user or one flow into another.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The ERP API was not the broken part. The client that called it was. Reuse a long-lived &lt;code&gt;HttpClient&lt;/code&gt; with &lt;code&gt;PooledConnectionLifetime&lt;/code&gt;, or let &lt;code&gt;IHttpClientFactory&lt;/code&gt; manage short-lived clients, exactly as Microsoft describes.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/dotnet/fundamentals/networking/http/httpclient-guidelines" rel="noopener noreferrer"&gt;Microsoft Learn: Using HttpClient&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/dotnet/core/extensions/httpclient-factory" rel="noopener noreferrer"&gt;Microsoft Learn: IHttpClientFactory with .NET&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.rfc-editor.org/rfc/rfc9293.html" rel="noopener noreferrer"&gt;RFC 9293: Transmission Control Protocol, TIME-WAIT&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;Aimpex Resources Group LLC is a Lincoln, NE firm founded in 2025 that works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. We operate as a Direct Vendor for Bank of America. We are a Verified Employer with active corporate sponsorship pathways for qualified STEM OPT and H-1B professionals. Our ERP architects work across SAP S/4HANA, Oracle Cloud ERP and Microsoft Dynamics. Our staffing practice aligns SAP specialists, Java and .NET engineers, cloud practitioners, data professionals and quality engineers with clearly defined roles. Teams that want cleaner .NET clients on those integrations can learn more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;. Sponsorship is never a promise of visa selection or approval.&lt;/p&gt;

</description>
      <category>csharp</category>
      <category>dotnet</category>
      <category>http</category>
      <category>performance</category>
    </item>
    <item>
      <title>An H-1B Site Visit Came to the Door: What USCIS Checks and What Happens After</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Sun, 15 Nov 2026 05:50:04 +0000</pubDate>
      <link>https://dev.to/aimpexresources/an-h-1b-site-visit-came-to-the-door-what-uscis-checks-and-what-happens-after-1af0</link>
      <guid>https://dev.to/aimpexresources/an-h-1b-site-visit-came-to-the-door-what-uscis-checks-and-what-happens-after-1af0</guid>
      <description>&lt;p&gt;A knock on the door from a USCIS officer can feel like bad news, even when nothing is wrong. At Aimpex Resources Group LLC, we think the best answer to that worry is knowing what the officer is there to check.&lt;/p&gt;

&lt;h2&gt;
  
  
  What can a visit look like?
&lt;/h2&gt;

&lt;p&gt;Here is a typical story. An officer came to an H-1B worker's home and asked for ID, the employer's name and the start date. The officer asked if the work was for a client or in-house, asked for the manager's email, and watched a short demo of the work. Later the officer emailed the manager to confirm the role and duties.&lt;/p&gt;

&lt;p&gt;The worker's big question was simple: how do you know if everything is okay?&lt;/p&gt;

&lt;h2&gt;
  
  
  Who sends officers on these visits?
&lt;/h2&gt;

&lt;p&gt;The visits come from the USCIS Fraud Detection and National Security Directorate (FDNS). The &lt;a href="https://www.uscis.gov/about-us/organization/directorates-and-program-offices/fraud-detection-and-national-security-directorate/administrative-site-visit-and-verification-program" rel="noopener noreferrer"&gt;USCIS page on the Administrative Site Visit and Verification Program&lt;/a&gt; describes two programs:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;ASVVP&lt;/strong&gt;, started in 2009. "Under ASVVP, petitions are selected at random for site visits."&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;TSVVP&lt;/strong&gt;, started in 2017, which takes "a more data-driven approach to petition verification."&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;H-1B petitions are on the list for both. USCIS says officers "make unannounced site visits to collect information as part of a compliance review." It also says the officers "conduct their work for fact-finding purposes and are not law enforcement officers."&lt;/p&gt;

&lt;p&gt;A visit does not mean someone did something wrong. Random selection is part of the program by design.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why would an officer come to a home?
&lt;/h2&gt;

&lt;p&gt;The rule allows it. Since the December 2024 H-1B final rule (&lt;a href="https://www.federalregister.gov/documents/2024/12/18/2024-29354/modernizing-h-1b-requirements-providing-flexibility-in-the-f-1-program-and-program-improvements" rel="noopener noreferrer"&gt;89 FR 103054&lt;/a&gt;, published December 18, 2024 and effective January 17, 2025), site visits are written into &lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2(h)(4)(i)(B)(2)&lt;/a&gt;. That rule says an inspection may take place at "the petitioner's headquarters, satellite locations, or the location where the beneficiary works, has worked, or will work, including third party worksites."&lt;/p&gt;

&lt;p&gt;For a remote H-1B worker, the place they work can be their home, so a visit can happen there.&lt;/p&gt;

&lt;p&gt;The same rule says USCIS may verify facts "at any time after an H-1B petition is filed, including any time before or after the final adjudication of the petition." So a visit can happen while a petition is pending or long after it was approved.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the officer check?
&lt;/h2&gt;

&lt;p&gt;The USCIS page lists the officer's tasks. For H-1B workers, the most useful line reads: "Interview personnel to confirm the beneficiary's work location, physical workspace, hours, salary and duties." The questions in the story above fit that list closely: start date, employer, client or in-house work, manager contact and a look at the actual work.&lt;/p&gt;

&lt;p&gt;The rule also allows "interviews with any other individuals possessing pertinent information," which "may be conducted in the absence of the employer or the employer's representatives." That covers the email the officer sent to the manager.&lt;/p&gt;

&lt;p&gt;Before any visit, it helps to know these facts from the petition and be able to say them clearly:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Job title and main duties.&lt;/li&gt;
&lt;li&gt;Work address, including a home office if you work remotely.&lt;/li&gt;
&lt;li&gt;Salary and normal hours.&lt;/li&gt;
&lt;li&gt;Who you report to, and whether the work is for a client or in-house.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If any of these changed after the petition was filed, talk to your employer soon. Some changes are "material" and need an amended petition under 8 CFR 214.2(h)(2)(i)(E). Failing to file one is listed as a ground for revocation in 8 CFR 214.2(h)(11)(iii).&lt;/p&gt;

&lt;h2&gt;
  
  
  Can you say no?
&lt;/h2&gt;

&lt;p&gt;You can, but there is a cost. USCIS says officers "will terminate a site visit or telephonic or electronic inquiry if an individual expresses an unwillingness to participate," and will document why it ended. The rule then says that being unable to verify facts, "including due to failure or refusal to cooperate, may result in denial or revocation of any H-1B petition for H-1B workers performing services at the location or locations that are a subject of inspection or compliance review."&lt;/p&gt;

&lt;p&gt;USCIS's advice to employers is simple. Before a visit, be ready "to present any information originally submitted with a petition." During it, "immediately provide all readily available documents and information." After it, "provide all additional information that USCIS requests in any follow-up communication."&lt;/p&gt;

&lt;h2&gt;
  
  
  How will you know the result?
&lt;/h2&gt;

&lt;p&gt;This is the question most workers ask. The answer is that the officer does not decide anything. USCIS says: "Because FDNS immigration officers are not adjudicators, they do not make decisions on petitions or applications for immigration benefits. USCIS adjudicators review an FDNS officer's report for any indicators of fraud or noncompliance."&lt;/p&gt;

&lt;p&gt;If there is a problem, the notice goes to the employer, because the employer is the petitioner. USCIS says it "would then notify the petitioner if adverse action is taken on a petition." For an approved petition, &lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2(h)(11)(iii)&lt;/a&gt; says a notice of intent to revoke must give "a detailed statement of the grounds," and the petitioner "may submit evidence in rebuttal within 30 days of receipt of the notice."&lt;/p&gt;

&lt;p&gt;USCIS describes a notice when adverse action is taken, so a visit may never lead to any letter at all. Tell your employer about the visit the same day, share what was asked, and ask them to let you know if USCIS sends anything.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/about-us/organization/directorates-and-program-offices/fraud-detection-and-national-security-directorate/administrative-site-visit-and-verification-program" rel="noopener noreferrer"&gt;USCIS: Administrative Site Visit and Verification Program&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2, eCFR (paragraphs (h)(2)(i)(E), (h)(4)(i)(B)(2) and (h)(11)(iii))&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.federalregister.gov/documents/2024/12/18/2024-29354/modernizing-h-1b-requirements-providing-flexibility-in-the-f-1-program-and-program-improvements" rel="noopener noreferrer"&gt;Federal Register, 89 FR 103054 (Dec. 18, 2024 final rule, Modernizing H-1B Requirements)&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;This post is not legal advice from Aimpex Resources Group LLC. As a staffing and consulting company, we cannot tell anyone how a site visit report will be read. If USCIS contacts you or your employer after a visit, ask an immigration attorney to review the notice and the petition together.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Based in Lincoln, NE and founded in 2025, Aimpex Resources Group LLC works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions, and operates as a Direct Vendor for Bank of America. We are a Verified Employer with active corporate sponsorship pathways for qualified STEM OPT and H-1B professionals. Clear job titles, duties and worksites are exactly what a site visit checks, so they matter in every role we support. Sponsorship is never a promise of visa selection or approval. Learn more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>h1b</category>
      <category>immigration</category>
      <category>uscis</category>
      <category>career</category>
    </item>
    <item>
      <title>H-1B Extension Approved, but the H-4 I-94 Still Shows the Old Date</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Sat, 14 Nov 2026 13:53:17 +0000</pubDate>
      <link>https://dev.to/aimpexresources/h-1b-extension-approved-but-the-h-4-i-94-still-shows-the-old-date-na</link>
      <guid>https://dev.to/aimpexresources/h-1b-extension-approved-but-the-h-4-i-94-still-shows-the-old-date-na</guid>
      <description>&lt;p&gt;An H-1B approval notice can look as if it covers the whole family. It does not. The worker's petition and a spouse's or child's stay are different filings, and each person has their own Form I-94.&lt;/p&gt;

&lt;p&gt;Some quick terms first. H-1B is the U.S. work visa for a job that needs a specialized degree. H-4 is the nonimmigrant class used by a spouse, or by an unmarried child under 21, of a person in H-1B status. Form I-94 is the arrival and departure record that shows how long a person may stay. The employer uses Form I-129 to ask USCIS to grant or extend the worker's H-1B stay. A spouse or child uses Form I-539 to ask for more time, or for a change of status, in their own name. U.S. Citizenship and Immigration Services, known as USCIS, reviews both filings and issues the decisions.&lt;/p&gt;

&lt;p&gt;This article comes from Aimpex Resources Group LLC. Our Lincoln, NE team works in ERP Architecture and IT staffing. Many of the people we speak with hold H-1B status, often with family members on H-4. The question after an H-1B approval is almost always the same: did that notice also extend the family's stay?&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the problem look like?
&lt;/h2&gt;

&lt;p&gt;Here is a typical story. An employer filed an H-1B extension, and USCIS approved it. The worker's new stay dates were on the approval notice. The spouse then looked at their own Form I-94 and saw the old end date. The family had assumed one approval would update everyone.&lt;/p&gt;

&lt;p&gt;The worker's notice does not replace the spouse's or child's I-94. Each H-4 family member needs their own decision on Form I-539.&lt;/p&gt;

&lt;h2&gt;
  
  
  Who files which form?
&lt;/h2&gt;

&lt;p&gt;The split is written into the form instructions.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://www.uscis.gov/sites/default/files/document/forms/i-129instr.pdf" rel="noopener noreferrer"&gt;Instructions for Form I-129&lt;/a&gt; (edition 09/09/26) say: "The beneficiary's dependent family members (generally, spouses and children under 21) should use Form I-539, Application to Change/Extend Nonimmigrant Status, to apply for a change of status or extension of stay." The same point is repeated later: "Dependent family members should use Form I-539 to file for an extension of stay."&lt;/p&gt;

&lt;p&gt;&lt;a href="https://www.uscis.gov/sites/default/files/document/forms/i-539instr.pdf" rel="noopener noreferrer"&gt;Instructions for Form I-539&lt;/a&gt; (edition 08/28/24) make the other side just as clear. A section titled "H-4 Dependents of an H, Temporary Worker" tells H-4 applicants what to send. The same pages add: "H-1B, H-2A, H-2B, H-3 nonimmigrants may not use Form I-539 to request an extension of stay." The H-1B worker's stay is requested on the employer's Form I-129, not on the family's Form I-539.&lt;/p&gt;

&lt;p&gt;The &lt;a href="https://www.uscis.gov/i-539" rel="noopener noreferrer"&gt;Form I-539 page&lt;/a&gt; says the same thing in a different way. "Requests for extension of stay in, or change of status to, certain employment-based classifications must be filed using Form I-129, Petition for a Nonimmigrant Worker, rather than Form I-539." The list of classifications you "must NOT" request on Form I-539 includes H-1B.&lt;/p&gt;

&lt;p&gt;So two filings are in play. The employer files Form I-129 for the worker. Each H-4 spouse or child must be included on a Form I-539. An approved I-129 does not take the place of that I-539.&lt;/p&gt;

&lt;h2&gt;
  
  
  When should Form I-539 be filed?
&lt;/h2&gt;

&lt;p&gt;USCIS says to file before the current stay ends.&lt;/p&gt;

&lt;p&gt;The Form I-539 page tells applicants to submit the application "before the expiration date as shown on the admission stamp in your travel document on your Form I-94, Arrival-Departure Record." The &lt;a href="https://www.uscis.gov/sites/default/files/document/forms/i-539instr.pdf" rel="noopener noreferrer"&gt;instructions&lt;/a&gt; use almost the same line: "you generally must submit your application before your current authorized stay expires." USCIS also writes: "We suggest you file at least 45 days, but generally not more than 6 months, before your stay expires."&lt;/p&gt;

&lt;p&gt;The 45-day figure is a suggestion, not a second deadline. The date that matters is the end date on that person's I-94.&lt;/p&gt;

&lt;p&gt;If Form I-539 is filed after that date, the person may be out of status. The form page and the instructions list limited circumstances in which USCIS may excuse a late filing. They also warn that staying past the authorized date can affect later travel and later benefits. Do not count on a late filing being excused. If the I-94 date is close, talk to an immigration attorney right away.&lt;/p&gt;

&lt;p&gt;Form I-539 can be sent while the H-1B extension is still pending. A final I-129 decision is not a prerequisite. The H-4 instructions, described next, allow an applicant to send a copy of the pending petition or its receipt notice.&lt;/p&gt;

&lt;h2&gt;
  
  
  What should go with the application?
&lt;/h2&gt;

&lt;p&gt;The "H-4 Dependents" section of the I-539 instructions asks for three things:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;A copy of the front and back of Form I-94 for each person included on the application.&lt;/li&gt;
&lt;li&gt;Evidence of the relationship to the H-1B worker, such as a marriage certificate or a birth certificate.&lt;/li&gt;
&lt;li&gt;At least one of these:

&lt;ul&gt;
&lt;li&gt;A copy of the Form I-129 filed for the worker.&lt;/li&gt;
&lt;li&gt;A copy of the Form I-797 receipt notice for that pending petition.&lt;/li&gt;
&lt;li&gt;A copy of the worker's most recent Form I-94.&lt;/li&gt;
&lt;li&gt;A copy of the worker's Form I-797 approval notice for the period requested on the H-4 application.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The &lt;a href="https://www.uscis.gov/i-129" rel="noopener noreferrer"&gt;Form I-129 page&lt;/a&gt; and the I-539 instructions both note that the employer, not the family, files Form I-129 for the H-1B worker. If more than one family member is included, Form I-539A is the supplement named on the Form I-539 page.&lt;/p&gt;

&lt;p&gt;A work permit for an H-4 spouse, when one is available, is a different filing: Form I-765. That card does not replace Form I-539, and an I-539 decision is not the same as a work-permit decision.&lt;/p&gt;

&lt;h2&gt;
  
  
  How can you check each person's I-94?
&lt;/h2&gt;

&lt;p&gt;Look at each person's most recent Form I-94, not only the H-1B approval notice. For a stay that USCIS already extended, the I-94 may be attached to that person's own approval notice. For a stay granted at a port of entry, U.S. Customs and Border Protection (CBP) says travelers "can access their CBP arrival/departure record information online." Travelers can also print a copy from the I-94 website, as the &lt;a href="https://www.cbp.gov/travel/international-visitors/i-94" rel="noopener noreferrer"&gt;CBP I-94 page&lt;/a&gt; explains.&lt;/p&gt;

&lt;p&gt;Use the latest end date that applies to that person. The worker's new dates do not change the spouse's or child's record.&lt;/p&gt;

&lt;h2&gt;
  
  
  Does a faster process cover the H-4 filing?
&lt;/h2&gt;

&lt;p&gt;Often people assume it does, because the H-1B petition itself can use premium processing. The current &lt;a href="https://www.uscis.gov/forms/all-forms/how-do-i-request-premium-processing" rel="noopener noreferrer"&gt;USCIS premium processing page&lt;/a&gt; (last reviewed November 10, 2026) says the opposite for these dependents: "Premium processing is not available for Form I-539 applications filed for dependents of a Form I-129 beneficiary classification."&lt;/p&gt;

&lt;p&gt;The same page says an H-4 Form I-539 that is "packaged together with and properly filed at the same time and in the same location as the principal's Form I-129" will be reviewed "as soon as possible after reviewing the principal's Form I-129." It also says this is not always possible, for example when biometrics or other checks are still open. Filing the two forms together can help, but it is not a promise that both decisions will arrive on the same day.&lt;/p&gt;

&lt;h2&gt;
  
  
  What is worth checking now?
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Find each family member's most recent Form I-94 and write down its end date.&lt;/li&gt;
&lt;li&gt;Confirm that Form I-539 has been filed for every H-4 spouse and child who needs more time. Confirm that it was filed before that person's I-94 ended.&lt;/li&gt;
&lt;li&gt;If Form I-539 has not been filed and the I-94 date is near, speak with an immigration attorney at once.&lt;/li&gt;
&lt;li&gt;Keep the I-129 receipt or approval with the I-539 receipt, so the two filings can be matched.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The H-1B approval is the worker's result. The H-4 I-94 is a separate record, and it changes only after Form I-539 is decided.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/i-539" rel="noopener noreferrer"&gt;USCIS: Form I-539, Application to Extend/Change Nonimmigrant Status&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/sites/default/files/document/forms/i-539instr.pdf" rel="noopener noreferrer"&gt;USCIS: Instructions for Form I-539 (edition 08/28/24)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/i-129" rel="noopener noreferrer"&gt;USCIS: Form I-129, Petition for a Nonimmigrant Worker&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/sites/default/files/document/forms/i-129instr.pdf" rel="noopener noreferrer"&gt;USCIS: Instructions for Form I-129 (edition 09/09/26)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/forms/all-forms/how-do-i-request-premium-processing" rel="noopener noreferrer"&gt;USCIS: How Do I Request Premium Processing?&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.cbp.gov/travel/international-visitors/i-94" rel="noopener noreferrer"&gt;CBP: Arrival/Departure Forms, I-94&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;This post is not legal advice from Aimpex Resources Group LLC. We are a staffing and consulting company, so we cannot review a family's I-94 records or choose a filing date for them. Before filing Form I-539, ask an immigration attorney to look at each person's I-94, the H-1B petition dates and the I-129 receipt together.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Based in Lincoln, NE and founded in 2025, Aimpex Resources Group LLC works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. The company operates as a Direct Vendor for Bank of America. We are a Verified Employer with active corporate sponsorship pathways for qualified STEM OPT and H-1B professionals. Families comparing those pathways can read more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;. Sponsorship is never a promise of visa selection or approval.&lt;/p&gt;

</description>
      <category>immigration</category>
      <category>h1b</category>
      <category>uscis</category>
      <category>visa</category>
    </item>
    <item>
      <title>Dynamics 365 Finance OData Returns Only One Company: How to Read Them All</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Sat, 14 Nov 2026 05:42:42 +0000</pubDate>
      <link>https://dev.to/aimpexresources/dynamics-365-finance-odata-returns-only-one-company-how-to-read-them-all-5bp3</link>
      <guid>https://dev.to/aimpexresources/dynamics-365-finance-odata-returns-only-one-company-how-to-read-them-all-5bp3</guid>
      <description>&lt;p&gt;A sales report built on Dynamics 365 finance and operations data can look complete and still be missing most of the business. For Supply Chain Analytics teams at Aimpex Resources Group LLC, this is a problem worth catching early, because the numbers add up but only for one legal entity.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the problem look like?
&lt;/h2&gt;

&lt;p&gt;A common report: a Power BI report pulls Dynamics 365 data, but the dataAreaId column shows only one company. Adding &lt;code&gt;cross-company=true&lt;/code&gt; seems not to help when the feed uses &lt;code&gt;Implementation="2.0"&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;In this version, the option sits on the service root and the entity is picked in a navigation step. In reports like this, the option did not carry through:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;let Source = OData.Feed("https://yourenv.operations.dynamics.com/data/?cross-company=true", null, [Implementation = "2.0"]), Items = Source{[Name = "InventTableBiEntities", Signature = "table"]}[Data] in Items
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This version calls the entity directly, with the option on that URL:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;let Items = OData.Feed("https://yourenv.operations.dynamics.com/data/InventTableBiEntities?cross-company=true", null, [Implementation = "2.0"]), WithKey = Table.AddColumn(Items, "CompanyItemKey", each [dataAreaId] &amp;amp; "-" &amp;amp; [ItemId], type text) in WithKey
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Why does OData show one company by default?
&lt;/h2&gt;

&lt;p&gt;Microsoft documents this on the &lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata" rel="noopener noreferrer"&gt;OData page for finance and operations apps&lt;/a&gt;: "By default, OData returns only data that belongs to the user's default company." To see more, "specify the ?cross-company=true query option. This option returns data from all companies that the user has access to."&lt;/p&gt;

&lt;p&gt;Two parts of that sentence matter:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Default company.&lt;/strong&gt; The filter comes from the user or service account behind the call, not from the report.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Companies the user has access to.&lt;/strong&gt; &lt;code&gt;cross-company=true&lt;/code&gt; does not bypass security. If the service account cannot see a legal entity, that data still will not come back.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The &lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/cross-company-behavior" rel="noopener noreferrer"&gt;cross-company behavior article&lt;/a&gt; explains where the filter comes from. Each data entity has a &lt;code&gt;PrimaryCompanyContext&lt;/code&gt; property. When it is set, the entity gets a &lt;code&gt;dataAreaId&lt;/code&gt; field that ties each row to a company. When it is empty, the entity behaves like a shared table. Not every standard entity is built for cross-company reads.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you ask for every company, or one other company?
&lt;/h2&gt;

&lt;p&gt;Put the option on the entity URL, not on the &lt;code&gt;/data/&lt;/code&gt; root. Microsoft's two examples use the Fleet Management sample entity:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;https://[baseURI]/data/FleetCustomers?cross-company=true
https://[baseURI]/data/FleetCustomers?$filter=dataAreaId eq 'usrt'&amp;amp;cross-company=true
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The first returns all companies the user can see. The second reads one company that is not the user's default. In your own system, swap in your entity name and company ID. The list of public entities is at &lt;code&gt;[Your organization's root URL]/data&lt;/code&gt;, and field names are in &lt;code&gt;/data/$metadata&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you pull it from Python?
&lt;/h2&gt;

&lt;p&gt;A scheduled extract for a data warehouse usually runs as an app, not a person. The &lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/services-home-page" rel="noopener noreferrer"&gt;service endpoints overview&lt;/a&gt; says OData supports OAuth 2.0 with "Service to service calls using client credentials (shared secret or certificate)." The app needs two setups: an app registration in Microsoft Entra ID, and a record under &lt;strong&gt;System administration &amp;gt; Setup &amp;gt; Microsoft Entra applications&lt;/strong&gt; that maps the client ID to a service account. Microsoft suggests a dedicated service account "that has the correct permissions" rather than Admin. That service account decides which companies &lt;code&gt;cross-company=true&lt;/code&gt; can return.&lt;/p&gt;

&lt;p&gt;This script gets a token with MSAL (Microsoft's sign-in library for Python), reads every page, and counts rows per company:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;time&lt;/span&gt;
&lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;collections&lt;/span&gt; &lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nc"&gt;Counter&lt;/span&gt;

&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;msal&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;

&lt;span class="no"&gt;TENANT_ID&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FO_TENANT_ID"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="no"&gt;CLIENT_ID&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FO_CLIENT_ID"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="no"&gt;CLIENT_SECRET&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FO_CLIENT_SECRET"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="no"&gt;BASE_URL&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;os&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;environ&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"FO_BASE_URL"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;  &lt;span class="c1"&gt;# for example https://yourenv.operations.dynamics.com (no trailing slash)&lt;/span&gt;


&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;get_token&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;app&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;msal&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;ConfidentialClientApplication&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
        &lt;span class="no"&gt;CLIENT_ID&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="n"&gt;authority&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="n"&gt;f&lt;/span&gt;&lt;span class="s2"&gt;"https://login.microsoftonline.com/{TENANT_ID}"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="n"&gt;client_credential&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="no"&gt;CLIENT_SECRET&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;result&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;app&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;acquire_token_for_client&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;scopes&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;f&lt;/span&gt;&lt;span class="s2"&gt;"{BASE_URL}/.default"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="s2"&gt;"access_token"&lt;/span&gt; &lt;span class="ow"&gt;not&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="n"&gt;result&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="k"&gt;raise&lt;/span&gt; &lt;span class="nc"&gt;RuntimeError&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;result&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"error_description"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"token request failed"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;result&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"access_token"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;


&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;get_all&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;entity&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;token&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;max_retries&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;5&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;url&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;f&lt;/span&gt;&lt;span class="s2"&gt;"{BASE_URL}/data/{entity}"&lt;/span&gt;
    &lt;span class="n"&gt;headers&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"Authorization"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;f&lt;/span&gt;&lt;span class="s2"&gt;"Bearer {token}"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"Accept"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"application/json"&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="n"&gt;rows&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;retries&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;
    &lt;span class="k"&gt;while&lt;/span&gt; &lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="n"&gt;resp&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;timeout&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;120&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;resp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;status_code&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="mi"&gt;429&lt;/span&gt; &lt;span class="ow"&gt;and&lt;/span&gt; &lt;span class="n"&gt;retries&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt; &lt;span class="n"&gt;max_retries&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
            &lt;span class="n"&gt;retries&lt;/span&gt; &lt;span class="o"&gt;+=&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;
            &lt;span class="n"&gt;wait&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;resp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"Retry-After"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"30"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
            &lt;span class="n"&gt;time&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;sleep&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kt"&gt;int&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;wait&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;wait&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;isdigit&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;else&lt;/span&gt; &lt;span class="mi"&gt;30&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
            &lt;span class="k"&gt;continue&lt;/span&gt;
        &lt;span class="n"&gt;resp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;raise_for_status&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;retries&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;
        &lt;span class="n"&gt;body&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;resp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;json&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;rows&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;extend&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;body&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"value"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;url&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;body&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"@odata.nextLink"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;params&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="kc"&gt;None&lt;/span&gt;  &lt;span class="c1"&gt;# the next link already carries the query options&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;rows&lt;/span&gt;


&lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;__name__&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="s2"&gt;"__main__"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;token&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;get_token&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;customers&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;get_all&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
        &lt;span class="s2"&gt;"CustomersV3"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="p"&gt;{&lt;/span&gt;
            &lt;span class="s2"&gt;"cross-company"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"true"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
            &lt;span class="s2"&gt;"$select"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"dataAreaId,CustomerAccount,CustomerGroupId"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="n"&gt;token&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nc"&gt;Counter&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"dataAreaId"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="n"&gt;customers&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;What each part of the script does:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Paging.&lt;/strong&gt; The OData page says the service "supports serving driven paging with a maximum page size of 10,000." Large entities come back in pages, so the loop follows &lt;code&gt;@odata.nextLink&lt;/code&gt; until it is gone. The next link already holds the query options, so &lt;code&gt;params&lt;/code&gt; is cleared after the first call.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Throttling.&lt;/strong&gt; The &lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/service-protection-api-limits" rel="noopener noreferrer"&gt;service protection API limits page&lt;/a&gt; says the service returns "429 Too Many Requests" when limits are hit, and suggests a 429 handler "that uses Retry-After logic." The loop waits and retries a few times before it gives up.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Field names.&lt;/strong&gt; &lt;code&gt;CustomersV3&lt;/code&gt; and its fields are only an example. Check &lt;code&gt;/data/$metadata&lt;/code&gt; for the entity you need.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Secrets.&lt;/strong&gt; The client secret comes from an environment variable. Keep it out of the script and out of source control.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  How do you know the fix worked?
&lt;/h2&gt;

&lt;p&gt;The last line prints a count per &lt;code&gt;dataAreaId&lt;/code&gt;. Before the fix, it shows one company. After it, it should show every legal entity the service account can see. If a company is still missing, check these three things:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;The service account's access to that legal entity.&lt;/li&gt;
&lt;li&gt;How the entity's &lt;code&gt;PrimaryCompanyContext&lt;/code&gt; is set, and whether that entity supports cross-company reads at all.&lt;/li&gt;
&lt;li&gt;Whether the option sits on the entity URL, not the &lt;code&gt;/data/&lt;/code&gt; root, as shown above.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;For reporting, keep &lt;code&gt;dataAreaId&lt;/code&gt; in every key you build. The &lt;code&gt;CompanyItemKey&lt;/code&gt; column above does this, because the same item number can appear in more than one company.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata" rel="noopener noreferrer"&gt;Microsoft Learn: Open Data Protocol (OData), finance and operations&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/cross-company-behavior" rel="noopener noreferrer"&gt;Microsoft Learn: Cross-company behavior of data entities&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/services-home-page" rel="noopener noreferrer"&gt;Microsoft Learn: Service endpoints overview&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/service-protection-api-limits" rel="noopener noreferrer"&gt;Microsoft Learn: Service protection API limits&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://learn.microsoft.com/en-us/powerquery-m/odata-feed" rel="noopener noreferrer"&gt;Microsoft Learn: OData.Feed (Power Query M)&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;From its base in Lincoln, NE, Aimpex Resources Group LLC (founded in 2025) delivers ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. Its ERP work spans SAP S/4HANA, Oracle Cloud ERP and Microsoft Dynamics, which helps supply chain reports cover every legal entity, not just the default one. To see how Aimpex supports Dynamics 365 data and reporting work, visit &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>dynamics365</category>
      <category>odata</category>
      <category>python</category>
      <category>powerbi</category>
    </item>
    <item>
      <title>Never Saw Your H-1B LCA? How to Get a Copy and Check the Wage</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Thu, 12 Nov 2026 04:27:05 +0000</pubDate>
      <link>https://dev.to/aimpexresources/never-saw-your-h-1b-lca-how-to-get-a-copy-and-check-the-wage-2p08</link>
      <guid>https://dev.to/aimpexresources/never-saw-your-h-1b-lca-how-to-get-a-copy-and-check-the-wage-2p08</guid>
      <description>&lt;p&gt;You would not ship code against a spec you have never read. Yet many H-1B workers never see the document that sets their minimum pay. It is called the Labor Condition Application (LCA).&lt;/p&gt;

&lt;p&gt;The H-1B program lets U.S. employers hire foreign workers for roles that require a bachelor's degree or higher in a specific field, or its equivalent. The Department of Labor (DOL) must certify an LCA before the employer can file the H-1B petition. In it, the employer promises a wage and other job terms.&lt;/p&gt;

&lt;p&gt;This post is from Aimpex Resources Group LLC, an ERP and IT staffing firm in Lincoln, NE. Our careers page says H-1B roles are weighed against "wage and worksite requirements," among other factors. So wage rules are part of our daily reading.&lt;/p&gt;

&lt;h2&gt;
  
  
  What went wrong in the Reddit post?
&lt;/h2&gt;

&lt;p&gt;In July 2025, someone shared this story in Reddit's r/h1b community. Their H-1B job had started in October 2024. They wrote that their employer had not paid the prevailing wage since then.&lt;/p&gt;

&lt;p&gt;The employer had not shared the documents either. The worker had to look up the LCA on their own. Only then did they see that their pay was lower than the LCA stated. They now had a new job offer and wanted to know what to do first.&lt;/p&gt;

&lt;p&gt;One reply pointed to a basic rule: "The employer must give a copy of the LCA to each H-1B worker." Let's start with that rule.&lt;/p&gt;

&lt;h2&gt;
  
  
  Must the employer hand you a copy?
&lt;/h2&gt;

&lt;p&gt;Yes. The rule sits in the Code of Federal Regulations (CFR), at 20 CFR 655.734(a)(3).&lt;/p&gt;

&lt;p&gt;By the date you report to work, the employer must give you a copy of the LCA. It must be certified by DOL's Employment and Training Administration (ETA) and signed by the employer. If you ask, the employer must also give you the cover pages, Form ETA 9035CP.&lt;/p&gt;

&lt;p&gt;That makes the first move simple. Ask HR in writing for your certified LCA. Keep a copy of the request.&lt;/p&gt;

&lt;h2&gt;
  
  
  Where else does the LCA live?
&lt;/h2&gt;

&lt;p&gt;Every H-1B employer keeps a public access file. Under 20 CFR 655.760(a), it must be ready within one working day after the LCA is filed. It is kept at the employer's main U.S. office or at the place of employment.&lt;/p&gt;

&lt;p&gt;DOL Fact Sheet #62F lists what goes in that file. Some of the items are:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;the LCA itself&lt;/li&gt;
&lt;li&gt;the rate of pay for the H-1B worker&lt;/li&gt;
&lt;li&gt;a summary of the employer's actual wage system&lt;/li&gt;
&lt;li&gt;the prevailing wage rate and its source&lt;/li&gt;
&lt;li&gt;a summary of benefits&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Anyone may view the file, not only you. The employer does not have to hand out copies to the public. But DOL says visitors must be allowed to record the details, such as by "transcription, scanning, or taking photographs."&lt;/p&gt;

&lt;h2&gt;
  
  
  Can you search DOL's public data?
&lt;/h2&gt;

&lt;p&gt;Often, yes. DOL's Office of Foreign Labor Certification (OFLC) posts LCA "disclosure data" as Excel files. The files follow the federal fiscal year, which runs from October 1 to September 30. As of this writing, the newest file covers decisions from October 1, 2025 through June 30, 2026.&lt;/p&gt;

&lt;p&gt;Some fields are missing on purpose. DOL removes personal data such as worker names and addresses. It also removes the employer's tax ID, the Federal Employer Identification Number (FEIN). Long text fields like job duties are left out. Cases still in process do not appear yet.&lt;/p&gt;

&lt;p&gt;If you know your LCA case number, a few lines of Python can find the row. This version needs no column names. It is slow on a big file, but it is simple.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="c1"&gt;# pip install pandas openpyxl&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;

&lt;span class="c1"&gt;# Download the LCA disclosure file for the right fiscal year from&lt;/span&gt;
&lt;span class="c1"&gt;# https://www.dol.gov/agencies/eta/foreign-labor/performance&lt;/span&gt;
&lt;span class="n"&gt;df&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;read_excel&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"lca_disclosure.xlsx"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;dtype&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="kt"&gt;str&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="n"&gt;case_no&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s2"&gt;"PASTE-YOUR-CASE-NUMBER"&lt;/span&gt;
&lt;span class="k"&gt;match&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;apply&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="k"&gt;lambda&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="kt"&gt;str&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;contains&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;case_no&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;regex&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="kc"&gt;False&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;na&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="kc"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nb"&gt;any&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;axis&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="k"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="k"&gt;match&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="no"&gt;T&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;  &lt;span class="c1"&gt;# one field per line, easy to read&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  How do you read the wage on an LCA?
&lt;/h2&gt;

&lt;p&gt;Look at 20 CFR 655.731(a). You must be paid at least the higher of two numbers:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;The actual wage.&lt;/strong&gt; This is what the employer pays others with similar experience and qualifications in the same job.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;The prevailing wage.&lt;/strong&gt; This is the wage for the occupation in the area of intended employment, set when the LCA is filed.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Now compare the LCA with your pay stubs. Check the pay unit too. A yearly figure and an hourly figure are easy to mix up.&lt;/p&gt;

&lt;p&gt;The same rule covers more than salary. It also includes the duty to offer benefits to H-1B workers, under the terms the rule sets.&lt;/p&gt;

&lt;h2&gt;
  
  
  What if your pay is lower than the LCA?
&lt;/h2&gt;

&lt;p&gt;Get advice from an immigration attorney first. A complaint and a job change can affect each other, so plan them together.&lt;/p&gt;

&lt;p&gt;LCA complaints go to DOL's Wage and Hour Division (WHD). Under 20 CFR 655.806:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;No special form is needed. A complaint must be in writing, or WHD staff will write it down for you.&lt;/li&gt;
&lt;li&gt;It must be filed within 12 months after the latest date of the violation.&lt;/li&gt;
&lt;li&gt;Back wages can still reach further back than that year, if the complaint is on time.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The WHD helpline is 1-866-487-9243.&lt;/p&gt;

&lt;p&gt;There is also a shield against payback. Under 20 CFR 655.801, an employer may not threaten, fire or blacklist a worker for reporting a likely violation. That covers former workers too. An H-1B worker who files a complaint about such retaliation "may be allowed to seek other appropriate employment" in the U.S., if they are otherwise eligible.&lt;/p&gt;

&lt;h2&gt;
  
  
  Where does Aimpex fit in?
&lt;/h2&gt;

&lt;p&gt;Our careers page says: "Aimpex Resources H1B opportunities are evaluated against the position, candidate qualifications, wage and worksite requirements, and applicable filing rules." It adds a limit: "Corporate sponsorship does not guarantee registration selection, petition approval or a particular start date."&lt;/p&gt;

&lt;p&gt;The banner "Verified Employer — STEM OPT &amp;amp; H1B Visa Pathways Supported" runs across our site. (STEM OPT is a work extension of up to 24 months for some F-1 graduates with science, technology, engineering or math degrees.) The same careers page notes: "Our E-Verify employer participation supports consideration of qualified graduates." Our pages also name us a "Direct Vendor for Bank of America." Our legal page is clear that this client link does not cover every role we fill, and it is not an endorsement of our site by the bank.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sponsorship is never a promise of visa selection or approval.&lt;/strong&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What should you do this week?
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Ask HR in writing for your certified LCA and its cover pages.&lt;/li&gt;
&lt;li&gt;Find the wage, the pay unit and the work location on it.&lt;/li&gt;
&lt;li&gt;Compare that wage with your last few pay stubs.&lt;/li&gt;
&lt;li&gt;If they do not match, book time with an immigration attorney.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;An LCA is the spec for your pay. Read it once, then store a copy next to your I-797 approval notice.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-H/section-655.734" rel="noopener noreferrer"&gt;20 CFR 655.734, eCFR (copy of the LCA for the worker)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-H/section-655.760" rel="noopener noreferrer"&gt;20 CFR 655.760, eCFR (public access file)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-H/section-655.731" rel="noopener noreferrer"&gt;20 CFR 655.731, eCFR (required wage)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-I/section-655.806" rel="noopener noreferrer"&gt;20 CFR 655.806, eCFR (complaints)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-I/section-655.801" rel="noopener noreferrer"&gt;20 CFR 655.801, eCFR (protection from retaliation)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.dol.gov/agencies/whd/fact-sheets/62f-h1b-recordkeeping-public-view" rel="noopener noreferrer"&gt;DOL Fact Sheet #62F: public access records&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.dol.gov/agencies/eta/foreign-labor/performance" rel="noopener noreferrer"&gt;DOL OFLC: Performance and disclosure data&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.aimpexresources.com/" rel="noopener noreferrer"&gt;Aimpex home&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/careers" rel="noopener noreferrer"&gt;Careers&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/legal" rel="noopener noreferrer"&gt;Legal&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;Aimpex Resources Group LLC does not give legal advice, and this post is not legal advice. As a staffing firm, we cannot judge a wage dispute. An immigration attorney should review your LCA, pay stubs and offer letter together. If you are on F-1 status or STEM OPT, your school's Designated School Official (DSO) is also a key contact.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Aimpex Resources Group LLC, based in Lincoln, NE since 2025, works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. For H-1B professionals who want to check their wage terms, &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt; describes how we support qualified technical resources through active corporate sponsorship and STEM OPT pathways.&lt;/p&gt;

</description>
      <category>h1b</category>
      <category>immigration</category>
      <category>career</category>
      <category>python</category>
    </item>
    <item>
      <title>H-4 Kids Turning 21: Moving to F-1 Before the Birthday</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Tue, 10 Nov 2026 04:34:27 +0000</pubDate>
      <link>https://dev.to/aimpexresources/h-4-kids-turning-21-moving-to-f-1-before-the-birthday-3e81</link>
      <guid>https://dev.to/aimpexresources/h-4-kids-turning-21-moving-to-f-1-before-the-birthday-3e81</guid>
      <description>&lt;p&gt;Many H-1B families plan for the green card and forget one date that arrives first: the day an H-4 child turns 21. At Aimpex Resources Group LLC, this post looks at that date through one real question from a student.&lt;/p&gt;

&lt;h2&gt;
  
  
  What did the student ask?
&lt;/h2&gt;

&lt;p&gt;A college student asked a common question online. They were 19 and in H-4 status through their parents. Their parents' H-1B and H-4 dates ended in late summer, and their 21st birthday came the next spring.&lt;/p&gt;

&lt;p&gt;They had three questions:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Should they file an H-4 extension and an F-1 change of status at the same time, or just file for F-1 before the H-4 end date?&lt;/li&gt;
&lt;li&gt;Could they keep studying while an application was pending?&lt;/li&gt;
&lt;li&gt;Could they file an H-4 extension, withdraw it later, and then file for F-1?&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;They also wanted to stay in H-4 as long as possible to keep in-state tuition. Many families face the same pattern each year.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why does 21 matter so much?
&lt;/h2&gt;

&lt;p&gt;The Immigration and Nationality Act defines a "child" as "an unmarried person under twenty-one years of age" (&lt;a href="https://www.law.cornell.edu/uscode/text/8/1101" rel="noopener noreferrer"&gt;INA 101(b)(1), 8 U.S.C. 1101(b)(1)&lt;/a&gt;). H-4 status for children is built on that word. The H rules at &lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2(h)(9)(iv)&lt;/a&gt; say the spouse and children of an H worker may be admitted as H-4 "for the same period of admission or extension as the principal spouse or parent."&lt;/p&gt;

&lt;p&gt;So two dates control an H-4 child:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;The parent's H-1B end date, because H-4 cannot run past it.&lt;/li&gt;
&lt;li&gt;The 21st birthday, because after it the person is no longer a "child."&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;SEVP's chart, &lt;a href="https://www.ice.gov/doclib/sevis/pdf/Nonimmigrant%20Class%20Who%20Can%20Study.pdf" rel="noopener noreferrer"&gt;Nonimmigrants: Who Can Study?&lt;/a&gt;, says it directly: "In most cases, children lose their derivative status at the age of 21 and must apply for a change of status to F-1 or M-1 if they wish to remain in the United States to continue their course of study."&lt;/p&gt;

&lt;p&gt;A pending H-4 extension does not change the birthday rule. An extension can only keep someone in H-4 as a child while they still meet the definition of a child.&lt;/p&gt;

&lt;h2&gt;
  
  
  Can an H-4 child study before the switch?
&lt;/h2&gt;

&lt;p&gt;Yes, in general. The same SEVP chart explains that people who attend school "incidental to their primary purpose for being in the United States may attend the school of their choice either part-time or full-time." The H row on that chart does not carry the "X" that marks a class as barred from study. B visitors, by contrast, are barred from a course of study by &lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2(b)(7)&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;There are two limits. H-4 status does not allow work just because of the status, as 8 CFR 214.2(h)(9)(iv) says. And the SEVP chart notes that family members "may not remain in the United States beyond the period approved for the principal in order to continue schooling."&lt;/p&gt;

&lt;p&gt;The &lt;a href="https://www.uscis.gov/policy-manual/volume-2-part-f-chapter-8" rel="noopener noreferrer"&gt;USCIS Policy Manual, Volume 2, Part F, Chapter 8&lt;/a&gt; adds a helpful point for this exact case. People in a class that allows study, and who enroll in a full course of study, "may continue their studies, even if their COS to F-1 is approved more than 30 days before their program start date."&lt;/p&gt;

&lt;h2&gt;
  
  
  When should the F-1 change be filed?
&lt;/h2&gt;

&lt;p&gt;The firm rule is that the current status must still be valid on the day USCIS receives the Form I-539. &lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-248/section-248.1" rel="noopener noreferrer"&gt;8 CFR 248.1(b)&lt;/a&gt; says a change of status may not be approved for someone "whose status expired before the application or petition was filed," with only narrow exceptions for extraordinary circumstances.&lt;/p&gt;

&lt;p&gt;The good news is that USCIS dropped the old "bridge the gap" rule for F-1 in July 2021. The &lt;a href="https://www.uscis.gov/working-in-the-united-states/students-and-exchange-visitors/students-and-employment/changing-to-a-nonimmigrant-f-or-m-student-status" rel="noopener noreferrer"&gt;USCIS page on changing to F or M student status&lt;/a&gt; now says you do not need to keep status all the way up to 30 days before the program start date, "provided that your nonimmigrant status is unexpired at the time of filing the change of status to F-1 application, and you otherwise remain eligible for a change of status." If approved, F-1 starts on the approval date.&lt;/p&gt;

&lt;p&gt;For a student like this one, this means:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;An F-1 change filed before the date on the student's own I-94 would meet the "unexpired at filing" test, even if the spring term started later.&lt;/li&gt;
&lt;li&gt;They would not need a second I-539 just to fill the time before the term, which was the old rule.&lt;/li&gt;
&lt;li&gt;An H-4 extension filed with the parents could be a backup, but it could not go past the 21st birthday.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The third idea, filing an extension and then withdrawing it, is the riskiest. A pending extension is not the same as an approved one. If the original I-94 date has passed and the extension is withdrawn, the person may have nothing "unexpired" left to file from. The cleaner plan, based on the USCIS pages above, is to file the F-1 change while the current I-94 is still valid. Anyone who wants to lean on a pending extension should talk to their school's Designated School Official (DSO) and an immigration attorney first.&lt;/p&gt;

&lt;p&gt;In-state tuition is a state and school rule, not a USCIS rule. The school's residency office is the right place to ask about it.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the filing need?
&lt;/h2&gt;

&lt;p&gt;The USCIS and &lt;a href="https://studyinthestates.dhs.gov/students/complete/change-of-status" rel="noopener noreferrer"&gt;Study in the States&lt;/a&gt; pages list the same items:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Acceptance from an SEVP-certified school.&lt;/li&gt;
&lt;li&gt;An initial Form I-20 where the DSO marks "change of status" as the issue reason.&lt;/li&gt;
&lt;li&gt;Payment of the I-901 SEVIS fee.&lt;/li&gt;
&lt;li&gt;A &lt;a href="https://www.uscis.gov/i-539" rel="noopener noreferrer"&gt;Form I-539&lt;/a&gt; filed with USCIS.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Read the alerts on the I-539 page before filing. USCIS changed the mail filing location on October 7, 2026, and the grace period for the old addresses ended on November 9, 2026. A court also postponed a new rule on fixed admission periods for students, so USCIS still accepts the 08/28/24 edition of Form I-539, not the 09/15/26 edition. Look at that page once more right before you send the form.&lt;/p&gt;

&lt;h2&gt;
  
  
  Can the wait be shortened?
&lt;/h2&gt;

&lt;p&gt;Yes. Since June 2023, USCIS has offered &lt;a href="https://www.uscis.gov/forms/all-forms/how-do-i-request-premium-processing" rel="noopener noreferrer"&gt;premium processing&lt;/a&gt; for I-539 requests to change to F-1, F-2, M-1, M-2, J-1 or J-2. The clock for these cases is "30 business days … once all prerequisites have been met." Premium processing buys speed. It does not change the outcome.&lt;/p&gt;

&lt;p&gt;If USCIS has not decided at least 15 days before the program start date on the I-20, the USCIS page says to contact the DSO. The start date may need to move to the next term.&lt;/p&gt;

&lt;h2&gt;
  
  
  What about travel while it is pending?
&lt;/h2&gt;

&lt;p&gt;Plan to remain in the country until USCIS decides. The USCIS Policy Manual chapter above says: "If a nonimmigrant travels abroad while their COS application is pending, USCIS considers that COS application abandoned." The other route is to leave, get an F-1 visa at a U.S. consulate, and come back as a student, which the USCIS page also describes.&lt;/p&gt;

&lt;h2&gt;
  
  
  Does CSPA keep a child in H-4?
&lt;/h2&gt;

&lt;p&gt;No. The &lt;a href="https://www.uscis.gov/green-card/green-card-processes-and-procedures/child-status-protection-act-cspa" rel="noopener noreferrer"&gt;Child Status Protection Act&lt;/a&gt; is a green card rule. USCIS says it "does not change the definition of a child" and instead gives a way to calculate a "CSPA age" for certain people applying for permanent residence, including employment-based derivatives. It can matter a lot when the parents' green card case moves forward, but it does not extend H-4 status. Families often need both plans at once: F-1 for the near term and a CSPA check for the green card case.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.law.cornell.edu/uscode/text/8/1101" rel="noopener noreferrer"&gt;8 U.S.C. 1101(b)(1), definition of "child"&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2, eCFR (paragraphs (b)(7) and (h)(9)(iv))&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-248/section-248.1" rel="noopener noreferrer"&gt;8 CFR 248.1, eCFR (change of status eligibility)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/working-in-the-united-states/students-and-exchange-visitors/students-and-employment/changing-to-a-nonimmigrant-f-or-m-student-status" rel="noopener noreferrer"&gt;USCIS: Changing to a Nonimmigrant F or M Student Status&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/policy-manual/volume-2-part-f-chapter-8" rel="noopener noreferrer"&gt;USCIS Policy Manual, Volume 2, Part F, Chapter 8&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/i-539" rel="noopener noreferrer"&gt;USCIS: Form I-539&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/forms/all-forms/how-do-i-request-premium-processing" rel="noopener noreferrer"&gt;USCIS: How Do I Request Premium Processing?&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/green-card/green-card-processes-and-procedures/child-status-protection-act-cspa" rel="noopener noreferrer"&gt;USCIS: Child Status Protection Act (CSPA)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://studyinthestates.dhs.gov/students/complete/change-of-status" rel="noopener noreferrer"&gt;SEVP, Study in the States: Change of Status&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ice.gov/doclib/sevis/pdf/Nonimmigrant%20Class%20Who%20Can%20Study.pdf" rel="noopener noreferrer"&gt;SEVP: Nonimmigrants: Who Can Study? (PDF)&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;This post is not legal advice from Aimpex Resources Group LLC. We are a staffing and consulting company, so we cannot review a family's I-94 records or choose a filing date for them. Before filing, ask the school's DSO and an immigration attorney to look at the child's I-94, the parents' H-1B dates and the birthday together.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Aimpex Resources Group LLC is a Lincoln, NE company, founded in 2025, that works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. We are a Verified Employer with active corporate sponsorship pathways for qualified STEM OPT and H-1B professionals, which can matter for a student who moves to F-1 and later looks for STEM work. Sponsorship is never a promise of visa selection or approval. Families planning that path can read more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>immigration</category>
      <category>h1b</category>
      <category>students</category>
      <category>uscis</category>
    </item>
    <item>
      <title>ABAP FOR ALL ENTRIES: Why an Empty Table Reads Every Row, and How to Guard It</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Sun, 08 Nov 2026 04:33:59 +0000</pubDate>
      <link>https://dev.to/aimpexresources/abap-for-all-entries-why-an-empty-table-reads-every-row-and-how-to-guard-it-459e</link>
      <guid>https://dev.to/aimpexresources/abap-for-all-entries-why-an-empty-table-reads-every-row-and-how-to-guard-it-459e</guid>
      <description>&lt;p&gt;A SELECT meant to return a handful of rows can return a whole table. In ABAP, one missing IF statement is enough to cause it.&lt;/p&gt;

&lt;p&gt;A few terms first. ABAP is the programming language of SAP systems. An internal table is a table that lives in your program's memory, not in the database. FOR ALL ENTRIES is an addition to the SELECT statement. It lets the rows of an internal table act as filter values, a bit like a long IN list. People often call that internal table the "driver table."&lt;/p&gt;

&lt;p&gt;This write-up is from Aimpex Resources Group LLC. Our Lincoln, NE team works on ERP Architecture across SAP S/4HANA, Oracle Cloud ERP and Microsoft Dynamics, and we place SAP specialists with enterprise teams. An unguarded FOR ALL ENTRIES is one of the first things worth looking for in any ABAP code review.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the problem look like?
&lt;/h2&gt;

&lt;p&gt;Here is a common version of the problem. A program reads BSID, a finance table of open customer items. At run time, its driver table &lt;code&gt;lt_customer&lt;/code&gt; has no rows:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight abap"&gt;&lt;code&gt;&lt;span class="c1"&gt;" No guard: if lt_customer is empty, this reads every BSID row of the client&lt;/span&gt;
&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;bukrs&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;kunnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;gjahr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;belnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;buzei&lt;/span&gt;
  &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;bsid&lt;/span&gt;
  &lt;span class="k"&gt;FOR&lt;/span&gt; &lt;span class="k"&gt;ALL&lt;/span&gt; &lt;span class="k"&gt;ENTRIES&lt;/span&gt; &lt;span class="k"&gt;IN&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_customer&lt;/span&gt;
  &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;bukrs&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;p_bukrs&lt;/span&gt;
    &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;belnr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_customer&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="n"&gt;belnr&lt;/span&gt;
    &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;gjahr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_customer&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="n"&gt;gjahr&lt;/span&gt;
  &lt;span class="k"&gt;INTO&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_open_items&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;You might expect a short dump (an ABAP runtime error). Instead, the query copies every BSID record of the current client into the result table.&lt;/p&gt;

&lt;p&gt;This is a real risk. On a big table, one unguarded FOR ALL ENTRIES can slow down a whole production system.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why does an empty table drop the whole WHERE?
&lt;/h2&gt;

&lt;p&gt;SAP's ABAP Keyword Documentation says it in one line: "If the internal table itab is empty, the entire WHERE condition is ignored."&lt;/p&gt;

&lt;p&gt;Note the word "entire." The conditions that use the driver table go away, and so does every other condition in the same WHERE. In the query above, &lt;code&gt;bukrs = @p_bukrs&lt;/code&gt; filters by company code. It has nothing to do with &lt;code&gt;lt_customer&lt;/code&gt;, but it was dropped too.&lt;/p&gt;

&lt;p&gt;One filter does stay. In SAP, a client is a separate block of data inside one system. When implicit client handling is on, which is the normal setup, the documentation says "all data is only read from the current client." So you get every row of the current client. On a large table, that is still far too much.&lt;/p&gt;

&lt;p&gt;SAP has a runtime check for this exact case. Its documentation says the check helps find "issues that lead to poor performance or high memory consumption."&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you guard the SELECT?
&lt;/h2&gt;

&lt;p&gt;Check the driver table right before the SELECT. SAP's documentation says "It is strongly recommended that the internal table itab is not initial before using it after FOR ALL ENTRIES." In ABAP, "initial" means empty for a table.&lt;/p&gt;

&lt;p&gt;Here is the same query with a guard. (The &lt;code&gt;@&lt;/code&gt; sign marks a variable that comes from the ABAP program.)&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight abap"&gt;&lt;code&gt;&lt;span class="c1"&gt;" lt_open_items is declared earlier with the five columns below&lt;/span&gt;
&lt;span class="k"&gt;CLEAR&lt;/span&gt; &lt;span class="n"&gt;lt_open_items&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;

&lt;span class="k"&gt;IF&lt;/span&gt; &lt;span class="n"&gt;lt_customer&lt;/span&gt; &lt;span class="k"&gt;IS&lt;/span&gt; &lt;span class="k"&gt;NOT&lt;/span&gt; &lt;span class="k"&gt;INITIAL&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;
  &lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;bukrs&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;kunnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;gjahr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;belnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;buzei&lt;/span&gt;
    &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;bsid&lt;/span&gt;
    &lt;span class="k"&gt;FOR&lt;/span&gt; &lt;span class="k"&gt;ALL&lt;/span&gt; &lt;span class="k"&gt;ENTRIES&lt;/span&gt; &lt;span class="k"&gt;IN&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_customer&lt;/span&gt;
    &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;bukrs&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;p_bukrs&lt;/span&gt;
      &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;belnr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_customer&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="n"&gt;belnr&lt;/span&gt;
      &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;gjahr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_customer&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="n"&gt;gjahr&lt;/span&gt;
    &lt;span class="k"&gt;INTO&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_open_items&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;
&lt;span class="k"&gt;ENDIF&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Three details matter here.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Place the guard last.&lt;/strong&gt; If code between the guard and the SELECT can remove rows, for example a &lt;code&gt;DELETE lt_customer WHERE ...&lt;/code&gt;, the table can become empty after the check passed. Keep the IF directly above the SELECT.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Decide what an empty result means.&lt;/strong&gt; The &lt;code&gt;CLEAR&lt;/code&gt; makes sure the result table is empty when the SELECT does not run. Without it, a table reused in a loop can still hold rows from the last pass.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Name the columns you need.&lt;/strong&gt; &lt;code&gt;SELECT *&lt;/code&gt; reads every column. Listing columns keeps the read small, and it also matters for the next trap.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Can FOR ALL ENTRIES lose rows, too?
&lt;/h2&gt;

&lt;p&gt;Yes. This second trap is quieter than the first.&lt;/p&gt;

&lt;p&gt;The documentation says: "Rows that occur more than once are removed from the result set automatically. The entire content of a row is considered here." In other words, FOR ALL ENTRIES acts as if you wrote DISTINCT.&lt;/p&gt;

&lt;p&gt;So if your column list does not include the table key, two different database rows can look the same and be merged into one. Take sales order items in table VBAP. Two items in one order can have the same material and the same quantity:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight abap"&gt;&lt;code&gt;&lt;span class="c1"&gt;" Risky: two items with the same material and quantity become one row&lt;/span&gt;
&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;matnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;kwmeng&lt;/span&gt;
  &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;vbap&lt;/span&gt;
  &lt;span class="k"&gt;FOR&lt;/span&gt; &lt;span class="k"&gt;ALL&lt;/span&gt; &lt;span class="k"&gt;ENTRIES&lt;/span&gt; &lt;span class="k"&gt;IN&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_orders&lt;/span&gt;
  &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;vbeln&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_orders&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="n"&gt;vbeln&lt;/span&gt;
  &lt;span class="k"&gt;INTO&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="k"&gt;DATA&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;lt_qty_risky&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;

&lt;span class="c1"&gt;" Safer: the key columns VBELN and POSNR keep every item row&lt;/span&gt;
&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;vbeln&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;posnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;matnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;kwmeng&lt;/span&gt;
  &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;vbap&lt;/span&gt;
  &lt;span class="k"&gt;FOR&lt;/span&gt; &lt;span class="k"&gt;ALL&lt;/span&gt; &lt;span class="k"&gt;ENTRIES&lt;/span&gt; &lt;span class="k"&gt;IN&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_orders&lt;/span&gt;
  &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;vbeln&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;lt_orders&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="n"&gt;vbeln&lt;/span&gt;
  &lt;span class="k"&gt;INTO&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="k"&gt;DATA&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;lt_qty&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;If you add up &lt;code&gt;kwmeng&lt;/code&gt; from the first result, the total can come out too low. SAP's own example shows the same effect: a SELECT of one column from SPFLI usually returns fewer rows than a SELECT of the full key.&lt;/p&gt;

&lt;p&gt;You also cannot fix this with &lt;code&gt;SUM( kwmeng )&lt;/code&gt; in the same statement. With FOR ALL ENTRIES, the only aggregate function allowed in the SELECT list is &lt;code&gt;COUNT( * )&lt;/code&gt;, and GROUP BY "has no effect."&lt;/p&gt;

&lt;h2&gt;
  
  
  When is a JOIN the better choice?
&lt;/h2&gt;

&lt;p&gt;Often the driver table comes straight from an earlier SELECT, with no changes in between. In that case, one SELECT with a JOIN can do both reads. There is no driver table, so there is no empty-table case. SAP's own FOR ALL ENTRIES example notes that its selection "could also be carried out in a single SELECT statement by using a join."&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight abap"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;i&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;vbeln&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;i&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;posnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;i&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;matnr&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;i&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;kwmeng&lt;/span&gt;
  &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;vbak&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;h&lt;/span&gt;
  &lt;span class="k"&gt;INNER&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;vbap&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="k"&gt;i&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="k"&gt;i&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;vbeln&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;h&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;vbeln&lt;/span&gt;
  &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;h&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;vkorg&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;p_vkorg&lt;/span&gt;
    &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;h&lt;/span&gt;&lt;span class="o"&gt;~&lt;/span&gt;&lt;span class="n"&gt;erdat&lt;/span&gt; &lt;span class="k"&gt;IN&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="n"&gt;s_erdat&lt;/span&gt;
  &lt;span class="k"&gt;INTO&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="o"&gt;@&lt;/span&gt;&lt;span class="k"&gt;DATA&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;lt_items&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Here VBAK holds the sales order headers and VBAP holds the items. &lt;code&gt;p_vkorg&lt;/code&gt; is a sales organization parameter, and &lt;code&gt;s_erdat&lt;/code&gt; is a date range from the selection screen.&lt;/p&gt;

&lt;p&gt;A JOIN is not always the answer, though. The documentation adds that "For buffered tables, the addition FOR ALL ENTRIES can be a more efficient alternative to join expressions." And when the program changes the driver table between the two reads, FOR ALL ENTRIES is still the natural fit. Then the guard is a must.&lt;/p&gt;

&lt;h2&gt;
  
  
  What should a code review check?
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Search the program for &lt;code&gt;FOR ALL ENTRIES&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;For each hit, find the IS NOT INITIAL check. Confirm that nothing between the check and the SELECT can empty the table.&lt;/li&gt;
&lt;li&gt;Confirm the result table is cleared, or is meant to keep its old rows, when the SELECT is skipped.&lt;/li&gt;
&lt;li&gt;Compare the column list with the table key. If the key is missing, decide whether merged rows are really fine.&lt;/li&gt;
&lt;li&gt;Ask whether a JOIN could replace the two-step read.&lt;/li&gt;
&lt;li&gt;In test systems, SAP's Runtime Check Monitor has a check called "Empty table in FOR_ALL_ENTRIES clause." It records each time the driver table was empty at run time.&lt;/li&gt;
&lt;/ol&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://help.sap.com/doc/abapdocu_758_index_htm/7.58/en-US/abenwhere_all_entries.htm" rel="noopener noreferrer"&gt;SAP Help Portal: ABAP Keyword Documentation, SELECT, FOR ALL ENTRIES (release 7.58)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/abenwhere_all_entries.htm" rel="noopener noreferrer"&gt;SAP Help Portal: ABAP Keyword Documentation, SELECT, FOR ALL ENTRIES (latest release)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://help.sap.com/doc/saphelp_nw74/7.4.16/en-US/ce/30e9746f3241559b8e4bd9d9ee0996/content.htm" rel="noopener noreferrer"&gt;SAP Help Portal: Runtime Checks (SAP NetWeaver 7.4), "Empty table in FOR_ALL_ENTRIES clause"&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.aimpexresources.com/" rel="noopener noreferrer"&gt;Aimpex home&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/services" rel="noopener noreferrer"&gt;Services&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/careers" rel="noopener noreferrer"&gt;Careers&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;Aimpex Resources Group LLC is a Lincoln, NE firm founded in 2025 that works in ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. Its ERP architects work across SAP S/4HANA, Oracle Cloud ERP and Microsoft Dynamics, and its staffing practice aligns SAP specialists, Java and .NET engineers, cloud practitioners, data professionals and quality engineers with clearly defined roles. Teams that want cleaner ABAP on their S/4HANA programs can learn more at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>sap</category>
      <category>abap</category>
      <category>sql</category>
      <category>performance</category>
    </item>
    <item>
      <title>Leaving Before Day 180 of Your I-140 Approval: What You Keep</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Tue, 03 Nov 2026 04:35:26 +0000</pubDate>
      <link>https://dev.to/aimpexresources/leaving-before-day-180-of-your-i-140-approval-what-you-keep-45b1</link>
      <guid>https://dev.to/aimpexresources/leaving-before-day-180-of-your-i-140-approval-what-you-keep-45b1</guid>
      <description>&lt;p&gt;Think of an approved I-140 like a merged pull request. Even if the author leaves the team, the commit history stays. The question is which parts of that history still count for you.&lt;/p&gt;

&lt;p&gt;Some quick terms first. An I-140 is the immigrant petition an employer files with U.S. Citizenship and Immigration Services (USCIS) to start an employment-based green card. Your priority date is your place in the green card line. H-1B is the U.S. work visa for jobs that need a specialized degree.&lt;/p&gt;

&lt;p&gt;This article comes from Aimpex Resources Group LLC. Our Lincoln, NE team places ERP and IT talent, and many of the people we speak with hold H-1B status. The 180-day worry shows up almost every time one of them thinks about a new job.&lt;/p&gt;

&lt;h2&gt;
  
  
  What did the Reddit post ask?
&lt;/h2&gt;

&lt;p&gt;In 2025, a user on Reddit's r/h1b asked a simple question. People say you must stay with your employer for 180 days after the I-140 is approved. Their friend had to leave about 100 days after approval, because of office politics. Would the company really withdraw the I-140 and hurt them?&lt;/p&gt;

&lt;p&gt;Nobody outside that company can say what it will do. Some employers withdraw petitions when a worker leaves. Others do not. So the better question is this: what happens to you in each case?&lt;/p&gt;

&lt;h2&gt;
  
  
  Where does the 180-day number come from?
&lt;/h2&gt;

&lt;p&gt;It comes from a rule at 8 CFR 205.1(a)(3)(iii)(C). CFR stands for the Code of Federal Regulations.&lt;/p&gt;

&lt;p&gt;In simple terms, the rule works like this:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;If the employer withdraws the I-140 less than 180 days after approval, the approval is revoked automatically.&lt;/li&gt;
&lt;li&gt;If the employer withdraws it 180 days or more after approval, the I-140 "remains approved unless its approval is revoked on other grounds."&lt;/li&gt;
&lt;li&gt;The same 180-day line also counts from the filing of a green card application (Form I-485), if one has been pending that long.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;DHS added this rule in a final rule published November 18, 2016 (81 FR 82398). It took effect January 17, 2017.&lt;/p&gt;

&lt;p&gt;Note one point. The 180 days count from the date of approval, not from your hire date.&lt;/p&gt;

&lt;h2&gt;
  
  
  Do you lose your priority date if you leave early?
&lt;/h2&gt;

&lt;p&gt;In most cases, no. Many workers assume the opposite.&lt;/p&gt;

&lt;p&gt;Under 8 CFR 204.5(e), an approved I-140 gives you its priority date for later I-140s in the first, second or third employment-based groups (EB-1, EB-2 or EB-3). You can lose that date only if USCIS revokes the approval for one of these reasons:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;fraud, or a willful misrepresentation of a material fact (lying on purpose about an important fact)&lt;/li&gt;
&lt;li&gt;the Department of Labor (DOL) revokes the labor certification&lt;/li&gt;
&lt;li&gt;USCIS or the Department of State invalidates the labor certification&lt;/li&gt;
&lt;li&gt;USCIS finds the approval was based on a material error&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;An employer withdrawal is not on that list. When DHS wrote the 2016 rule, it said so directly: "a priority date may be retained, despite withdrawal or business termination that occurs less than 180 days after the petition's approval" (81 FR 82398). The USCIS Policy Manual adds that a petition withdrawn 180 days or more after approval "remains valid for priority date retention."&lt;/p&gt;

&lt;p&gt;So in the Reddit case, the friend's place in line most likely stays safe. A new employer would still have to file a new I-140. Once that one is approved, it can carry the older priority date.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does the 180-day rule change, then?
&lt;/h2&gt;

&lt;p&gt;It changes whether the old I-140 still counts as approved for other uses. That matters in three areas.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;H-1B time past six years.&lt;/strong&gt; H-1B status normally ends after six years. Under 8 CFR 214.2(h)(13)(iii)(E), a worker with an approved I-140 who is stuck in a visa backlog can extend H-1B in steps of up to three years. The new H-1B employer does not need to be the one that filed the I-140. If the I-140 was withdrawn after day 180, it stays approved and can still support this. If it was revoked before day 180, it no longer counts as approved, so you would need another basis to extend past six years, such as a new approved I-140 from a new employer.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;A spouse's work card.&lt;/strong&gt; An H-4 spouse can apply for work permission when the H-1B worker is the beneficiary of an approved I-140. The USCIS page on H-4 employment authorization lists this as one basis. An I-140 revoked before day 180 no longer counts for it.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The green card filing itself.&lt;/strong&gt; Withdrawal ends the employer's job offer either way. Under 8 CFR 205.1(a)(3)(iii)(C), you then need a new petition to move forward with a green card. The exception is a worker whose I-485 has been pending 180 days or more. That worker may be able to move the case to a "same or similar" new job using Form I-485 Supplement J.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do you check your own status?
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Find your I-140 approval notice. Note the approval date and the priority date.&lt;/li&gt;
&lt;li&gt;Count 180 days from the approval date. Save that date somewhere you will see it.&lt;/li&gt;
&lt;li&gt;Look up your category and country in the State Department's Visa Bulletin. This shows how long the wait may be.&lt;/li&gt;
&lt;li&gt;Ask an immigration attorney how many H-1B years you have used, and whether any time spent outside the U.S. can be added back.&lt;/li&gt;
&lt;li&gt;If you are married and your spouse holds an H-4 work card, ask how a withdrawal could affect it.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Keep these notes together in a single file. When a new employer asks, you will have clear answers.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does Aimpex publish about H-1B roles?
&lt;/h2&gt;

&lt;p&gt;Our home page states: "For professionals exploring Aimpex Resources H1B opportunities, we support qualified technical resources through active corporate sponsorship and STEM OPT pathways." STEM OPT lets eligible F-1 graduates in STEM fields (science, technology, engineering, math) keep working for 24 more months.&lt;/p&gt;

&lt;p&gt;Across the site, a banner reads "Verified Employer — STEM OPT &amp;amp; H1B Visa Pathways Supported." Our careers page also says: "Our E-Verify employer participation supports consideration of qualified graduates." We list ourselves as a "Direct Vendor for Bank of America." Our legal page notes that this does not mean every candidate role goes to that client, or that the client endorses our site.&lt;/p&gt;

&lt;p&gt;Our careers page puts the limit plainly: "Corporate sponsorship does not guarantee registration selection, petition approval or a particular start date."&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sponsorship is never a promise of visa selection or approval.&lt;/strong&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-205/section-205.1" rel="noopener noreferrer"&gt;8 CFR 205.1, eCFR (automatic revocation and the 180-day rule)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-204/subpart-A/section-204.5" rel="noopener noreferrer"&gt;8 CFR 204.5, eCFR (priority date retention, paragraph (e))&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2, eCFR (H-1B past six years, paragraphs (h)(13)(iii)(D) and (E))&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.federalregister.gov/documents/2016/11/18/2016-27540/retention-of-eb-1-eb-2-and-eb-3-immigrant-workers-and-program-improvements-affecting-high-skilled" rel="noopener noreferrer"&gt;Federal Register, 81 FR 82398 (Nov. 18, 2016 final rule)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/policy-manual/volume-7-part-e-chapter-5" rel="noopener noreferrer"&gt;USCIS Policy Manual, Volume 7, Part E, Chapter 5 (withdrawal of a petition)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/working-in-the-united-states/temporary-workers/h-1b-specialty-occupations/employment-authorization-for-certain-h-4-dependent-spouses" rel="noopener noreferrer"&gt;USCIS: Employment Authorization for Certain H-4 Dependent Spouses&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://travel.state.gov/content/travel/en/legal/visa-law0/visa-bulletin.html" rel="noopener noreferrer"&gt;U.S. Department of State: Visa Bulletin&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.aimpexresources.com/" rel="noopener noreferrer"&gt;Aimpex home&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/careers" rel="noopener noreferrer"&gt;Careers&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/legal" rel="noopener noreferrer"&gt;Legal&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;Nothing here is legal advice from Aimpex Resources Group LLC. We are a staffing company, so we cannot review your petition history. Before you resign or accept a new offer, ask an immigration attorney to read your I-140 approval notice and your H-1B dates.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Started in 2025 in Lincoln, NE, Aimpex Resources Group LLC provides ERP Architecture, Supply Chain Analytics and IT Staffing Solutions. H-1B professionals weighing a job change can visit &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt; to see how we support qualified technical resources through active corporate sponsorship and STEM OPT pathways.&lt;/p&gt;

</description>
      <category>h1b</category>
      <category>greencard</category>
      <category>immigration</category>
      <category>career</category>
    </item>
    <item>
      <title>Promoted on H-1B? Read the Petition Diff Before You Accept</title>
      <dc:creator>Aimpex Resources Group LLC</dc:creator>
      <pubDate>Thu, 29 Oct 2026 04:51:18 +0000</pubDate>
      <link>https://dev.to/aimpexresources/promoted-on-h-1b-read-the-petition-diff-before-you-accept-4f9k</link>
      <guid>https://dev.to/aimpexresources/promoted-on-h-1b-read-the-petition-diff-before-you-accept-4f9k</guid>
      <description>&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight diff"&gt;&lt;code&gt;  employer:   same company
&lt;span class="gd"&gt;- title:      Senior Java Developer
&lt;/span&gt;&lt;span class="gi"&gt;+ title:      Engineering Lead
&lt;/span&gt;&lt;span class="gd"&gt;- duties:     build and test services
&lt;/span&gt;&lt;span class="gi"&gt;+ duties:     design services, review code, lead four engineers
&lt;/span&gt;  worksite:   same office
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Developers read diffs all day. A promotion on H-1B is a diff too. The question is simple. Is it a safe patch, or a breaking change?&lt;/p&gt;

&lt;p&gt;With H-1B, a U.S. company can employ a foreign degree holder in a specialty occupation. Your petition and its wage filing describe one job. When the job changes, the papers may need to change as well.&lt;/p&gt;

&lt;p&gt;Aimpex Resources Group LLC wrote this piece. We place Java and .NET engineers, cloud and data people, and quality assurance (QA) engineers. Promotions are good news in our world. This post covers the paperwork side.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why did HR say "wait for the extension"?
&lt;/h2&gt;

&lt;p&gt;A worker posted on Reddit's r/h1b in April 2026. They had joined their firm about a year earlier as an architectural designer on H-1B. They were up for promotion to "Job Captain" in the May cycle. The duties would be fairly similar, with more ownership and coordination. Human resources (HR) then said the new role needed an H-1B amendment. HR's advice was to wait until the next extension filing. To the worker, it felt like a denied promotion.&lt;/p&gt;

&lt;p&gt;Their field is building design, not software. But the rules below are the same for a .NET developer. They are the same for a SAP consultant or a QA lead.&lt;/p&gt;

&lt;h2&gt;
  
  
  What makes a change "material"?
&lt;/h2&gt;

&lt;p&gt;The key rule is 8 CFR 214.2(h)(2)(i)(E), in the Code of Federal Regulations (CFR). Under it, "any material changes" to your job need an amended or new petition.&lt;/p&gt;

&lt;p&gt;For H-1B, that filing includes "a current or new certified labor condition application." That is the Labor Condition Application (LCA). The Department of Labor (DOL) certifies it before the petition is filed.&lt;/p&gt;

&lt;p&gt;The rule gives no full list of material changes. So employers and their attorneys compare the old job with the new one. These are the fields they usually check:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;the duties and how much time each takes&lt;/li&gt;
&lt;li&gt;the occupational classification on the LCA&lt;/li&gt;
&lt;li&gt;the worksite and area of work&lt;/li&gt;
&lt;li&gt;the wage&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Which LCA fields matter for a promotion?
&lt;/h2&gt;

&lt;p&gt;DOL rule 20 CFR 655.730(c)(4) says each LCA "shall identify the occupational classification." So one LCA covers one type of job.&lt;/p&gt;

&lt;p&gt;Think about two moves. A senior developer becomes a lead developer and still writes code. The occupation may stay the same. A developer becomes a people manager who rarely codes. That could fall under a different occupation. An attorney makes that call from the real duties.&lt;/p&gt;

&lt;p&gt;The wage rule is 20 CFR 655.731(a). The wage must be "the greater of the actual wage rate" or "the prevailing wage." In plain words, the LCA sets a floor. A promotion with a raise keeps you above that floor. It does not break the wage promise by itself.&lt;/p&gt;

&lt;p&gt;Note one limit here. A raise alone does not answer the duties question. Check both.&lt;/p&gt;

&lt;h2&gt;
  
  
  On what date may the new duties begin?
&lt;/h2&gt;

&lt;p&gt;The rule also sets the timing. An amended petition "must be properly filed before the material change(s) takes place."&lt;/p&gt;

&lt;p&gt;After that, H-1B portability can apply. United States Citizenship and Immigration Services (USCIS) explains this on its H-1B page. That page says Form I-129 also covers "a change of employment" inside your current company. You may then work under the new terms "once that petition is filed." A petition can ask for a later start. In that case, the later date wins.&lt;/p&gt;

&lt;p&gt;This only works if the filing goes in before your current stay ends and you have not worked without permission. If portability does not apply, the new duties must wait for approval.&lt;/p&gt;

&lt;p&gt;So the safe order looks like this:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;The employer reviews the new duties with its attorney.&lt;/li&gt;
&lt;li&gt;The employer gets a new LCA if the job needs one.&lt;/li&gt;
&lt;li&gt;The amended petition goes to USCIS.&lt;/li&gt;
&lt;li&gt;You start the new duties after the filing, or on the requested start date.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Working in the new role before step 3 is the risky part. Do not let a team reorg skip it.&lt;/p&gt;

&lt;h2&gt;
  
  
  Can the extension carry the change?
&lt;/h2&gt;

&lt;p&gt;This is likely what HR meant. Look at the portability rule in 8 CFR 214.2(h)(2)(i)(H). It covers a petition "with a request to amend or extend."&lt;/p&gt;

&lt;p&gt;So one filing can request an amendment and an extension together. Some employers time the promotion to match the extension. That saves one filing. It can also delay a raise or a title, as the Reddit worker found.&lt;/p&gt;

&lt;p&gt;The rule does not say an employer must wait for the extension. Waiting is a timing choice. Ask HR which path they picked, and why.&lt;/p&gt;

&lt;h2&gt;
  
  
  How does this look on a typical tech team?
&lt;/h2&gt;

&lt;p&gt;Here are three common promotions. Treat them as prompts for your HR team, not answers.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Developer to senior developer.&lt;/strong&gt; Same stack, same office, bigger scope. Often the occupation and worksite do not change.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;QA engineer to QA lead.&lt;/strong&gt; More planning and some people leading. The share of time on each duty is worth a careful look.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Developer to engineering manager.&lt;/strong&gt; Mostly people work. This is the move most likely to need a fresh look at the occupation.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;A move to a new city is a separate trigger. Worksite rules have their own details, so raise it on its own.&lt;/p&gt;

&lt;h2&gt;
  
  
  What should you ask before you say yes?
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Do the new duties fit the occupation on my current LCA?&lt;/li&gt;
&lt;li&gt;Will my worksite or area of work change?&lt;/li&gt;
&lt;li&gt;Will you file an amended petition, and on what date?&lt;/li&gt;
&lt;li&gt;When may I start the new duties?&lt;/li&gt;
&lt;li&gt;Will the next extension also request the amendment?&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Get the answers in writing. Then match the dates against your offer letter.&lt;/p&gt;

&lt;h2&gt;
  
  
  How does Aimpex handle sponsorship?
&lt;/h2&gt;

&lt;p&gt;Our site lists the people we align. They are "SAP specialists, Java and .NET engineers, cloud practitioners, data professionals and quality engineers." We match them "with clearly defined technical responsibilities." Clear duties are also what a petition needs.&lt;/p&gt;

&lt;p&gt;The line "Verified Employer — STEM OPT &amp;amp; H1B Visa Pathways Supported" sits on every page of our site. Decoded, the banner's STEM OPT is Science, Technology, Engineering and Math Optional Practical Training: added student work time. On the careers page you will find: "Our E-Verify employer participation supports consideration of qualified graduates." Our pages name Aimpex a "Direct Vendor for Bank of America." The legal page clarifies this. Candidates are not all placed with that bank. The listing implies no endorsement either.&lt;/p&gt;

&lt;p&gt;Limits appear on the careers page as well. "Corporate sponsorship does not guarantee registration selection, petition approval or a particular start date." &lt;strong&gt;Sponsorship is never a promise of visa selection or approval.&lt;/strong&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What is the takeaway?
&lt;/h2&gt;

&lt;p&gt;A title change is metadata. A duties change can be a schema change. Review the diff before you merge it.&lt;/p&gt;

&lt;h3&gt;
  
  
  Sources
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-8/chapter-I/subchapter-B/part-214/section-214.2" rel="noopener noreferrer"&gt;8 CFR 214.2, eCFR&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-H/section-655.730" rel="noopener noreferrer"&gt;20 CFR 655.730, eCFR&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.ecfr.gov/current/title-20/chapter-V/part-655/subpart-H/section-655.731" rel="noopener noreferrer"&gt;20 CFR 655.731, eCFR&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.uscis.gov/working-in-the-united-states/h-1b-specialty-occupations" rel="noopener noreferrer"&gt;USCIS: H-1B Specialty Occupations&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.aimpexresources.com/" rel="noopener noreferrer"&gt;Aimpex home&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/careers" rel="noopener noreferrer"&gt;Careers&lt;/a&gt;, &lt;a href="https://www.aimpexresources.com/legal" rel="noopener noreferrer"&gt;Legal&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;em&gt;Not legal advice from Aimpex Resources Group LLC. Our team staffs engineering roles; we do not judge petitions. Before you accept a new title, have an immigration attorney compare it with your filed petition and LCA. Students on F-1 or STEM OPT have one more contact: the school's Designated School Official (DSO).&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Aimpex Resources Group LLC was established in 2025 in Lincoln, NE. We offer Enterprise Resource Planning (ERP) Architecture, Supply Chain Analytics and information technology (IT) Staffing Solutions, described at &lt;a href="https://aimpexresources.com" rel="noopener noreferrer"&gt;aimpexresources.com&lt;/a&gt;. For engineers weighing a promotion, we support qualified technical resources through active corporate H-1B sponsorship and STEM OPT pathways.&lt;/p&gt;

</description>
      <category>h1b</category>
      <category>career</category>
      <category>immigration</category>
      <category>softwareengineering</category>
    </item>
  </channel>
</rss>
