PO Accrual Account Generator does not work while autocreating PO from PR
Our PO Account generator works well from PO form, but does not work while autocreating PO from PR. I check the fnd log message and below is the root cause, and I am so confused. While autocreate from pr to po, the po account generator is not called in po_interface_s.generate_shared_proc_accounts because the cursor l_SPS_lines_csr does not return records. The root cause of it is below cursor sql condition: AND hoi.org_information3<>TO_CHAR(g_purchasing_ou_id) -- DOU<>POU our operating unit id is 1512 and inventory organization id is 1513 in above condition the g_purchasing_ou_id=1512, and hoi.org_information3 is also 1512. Below is the cursor: CURSOR l_SPS_lines_csr