Unable to Void payment. On Querying No Invoices appear.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Unable to Void payment. On Querying No Invoices appear.

Solution:




Payment entries were not updated in ap_accounting_events_all
The following SQL identified the invalid / incorrect data:
select * from ap_accounting_events_all
where source =138784
INSERT entries in to ap_accounting_events_all as below
Step # 1
========
This script should insert one row.

INSERT INTO ap_accounting_events_all
(ACCOUNTING_EVENT_ID,
EVENT_TYPE_CODE,
ACCOUNTING_DATE,
EVENT_NUMBER,
EVENT_STATUS_CODE,
SOURCE_TABLE,
SOURCE_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_UPDATE_DATE,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
ORG_ID,
CANNOT_ACCOUNT_FLAG)
VALUES (
261153
, 'PAYMENT'
,'04-JUL-2010'
,1
,'CREATED'
,'AP_CHECKS'
,138784
,SYSDATE
,-1
,SYSDATE
, -1
, -1
, SYSDATE
, -1
, -1
, -1
, 181/* Org_id */
, NULL);

--- 63 rows should be inserted

COMMIT;
Step # 2
========

1. Perform action plan in TEST instance.

create table sr_21626050_600_apid1 as
select * from AP_INVOICE_PAYMENTS_ALL
where posted_flag='S'
and CHECK_ID =138784
and invoice_id in(216589,216590,216591,216592,216593,216594
,216595,216596,216597,216598,216600,216601
,216602,216624,216625,216626,216627,216821
,216822,216823,217136,217137,217138,217139
,217140,217141,217142,217143,217144,217145
,217146,217147,217148,217149,217150,217151
,217152,217153,217154,217155,217156,217157
,217158,217159,217160,217161,217162,217163
,217164,217165,217167,217168,217169,217170
,217171,217172,217173,217174,217175,217176
,217177,217178,217179)
and org_id=181;

select count(*) from sr_21626050_600_apid1;

-- 63 row should be selected


Update AP_INVOICE_PAYMENTS_ALL
set posted_flag='N'
where posted_flag='S'
and CHECK_ID=138784
and invoice_id in(216589,216590,216591,216592,216593,216594
,216595,216596,216597,216598,216600,216601
,216602,216624,216625,216626,216627,216821
,216822,216823,217136,217137,217138,217139
,217140,217141,217142,217143,217144,217145
,217146,217147,217148,217149,217150,217151
,217152,217153,217154,217155,217156,217157
,217158,217159,217160,217161,217162,217163
,217164,217165,217167,217168,217169,217170
,217171,217172,217173,217174,217175,217176
,217177,217178,217179)
and org_id=181;

-- 63 row should be updated.

If you are satisfied with the results issue commit

commit;




Step # 2
========
1. AP period is in closed state,reopen it first

2. Run the payables accounting process for period JUL-10

Get Oracle Certifications for all Exams
Free Online Exams.com