Category Archives: unposted items

Accounts Payable: To find whether any orphan entry exist (this prevents period close) Select * from apps.ap_ae_lines_all Where ae_header_id in( Select ae_header_id from apps.ap_ae_headers_all Where org_id in (select organization_id from apps.hr_operating_units Where name like ‘XYZ%’) and gl_transfer_flag=’N’ And GL_TRANSFER_RUN_ID=-1 And … Continue reading →

Accounts Payable: To find whether any orphan entry exist (this prevents period close) Select * from apps.ap_ae_lines_all Where ae_header_id in( Select ae_header_id from apps.ap_ae_headers_all Where org_id in (select organization_id from apps.hr_operating_units Where name like ‘XYZ%’) and gl_transfer_flag=’N’ And GL_TRANSFER_RUN_ID=-1 And … Continue reading →