Payment Can't Be Accounted

Post date: Nov 22, 2010 9:18:4 AM

Document Number is 10000203 and supplier is exim. Condition in Oracle E-Business R 12.0.4 PRODUCTION

Check using these scripts:

select rowid,xe.* from xla_events xe where event_id in ( '744089','735832') --untuk doc number 10000203 EXIM

select rowid,aipa.* from AP_invoice_payments_all aipa where check_id = 119424

select rowid,apha.* from ap_payment_history_all apha where check_id=119424

You can check file attached below. And be sure to check table xla_ae_header for field GL_TRANSFER_STATUS_CODE must be 'Y' and ACCOUNTING_ENTRY_STATUS_CODE can be 'F'

These query can be useful:

select *

from AP_INVOICES_ALL

--where GL_DATE between ('1-DEC-2009') and ('31-DEC-2009')

--and payment_status_flag <>'Y'

--and org_id=47

where invoice_num ='PNBP 0710'

select rowid,aipa.*

from AP_INVOICE_PAYMENTS_ALL aipa

where invoice_id = 215242

and check_id =119424

select *

from AP_PAYMENT_SCHEDULES_ALL

where invoice_id=215242

---------------------------

select *

from AP_PAYMENT_HISTORY_ALL

where check_id = 119424 --event_id = 744089 dan 735832

select *

from AP_CHECKS_ALL

where check_id= 119424 --check_number 10000203

select *

from XLA_TRANSACTION_ENTITIES_UPG

where transaction_number = '10000203'

and entity_id=762173

select *

from xla_events

where event_id in ( '744089','735832') --entity_id = 762173

select rowid,xah.*

from xla_ae_headers xah

where event_id in ('744089','735832')

select *

from xla_ae_lines

where ae_header_id in ('1199560','1199616')

---

select rowid,xe.*

from xla_events xe

where event_id in ( '744089','735832') --untuk doc number 10000203 EXIM

select rowid,aipa.*

from AP_invoice_payments_all aipa

where check_id = 119424

select rowid,apha.*

from ap_payment_history_all apha

where check_id=119424

--

--doc 10000203

create table xla_events_22112010 as

(select *

from xla_events

where event_id in ( '744089','735832'))

create table aipa_22112010 as (select *

from AP_invoice_payments_all

where check_id = 119424)

create table apha_22112010 as (select *

from ap_payment_history_all

where check_id=119424)