oracle应付匹配发票,【AP】应付发票在进行匹配时无法选择接收单号

不知是否对楼主有帮助:

Subject:  APXRMTCH Click the Match to Receipts Button and Receive Error FRM-40735: POST-QUERY Trigger Raised Unhandled Exception ORA-1403

Doc ID:  Note:207502.1 Type:  PROBLEM

Last Revision Date:  14-OCT-2003 Status:  PUBLISHED

fact: APXRMTCH - Match to Receipts

fact: Oracle Payables 11.5

symptom: Click the match to receipts button and receive error.

symptom: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-1403

symptom: Details button shows 'ORA-1403 no data found'

symptom: Bottom of screen another error appears FRM-40350: Query caused no

records to

be retrieved.

change: NOTE ROLE:

Here is where the problem is being encountered from the trace file:

SELECT DISPLAYED_FIELD

FROM

PO_LOOKUP_CODES WHERE LOOKUP_CODE = :b1 AND LOOKUP_TYPE ='DOCUMENT STATE'

change: Run the following select:

select substr(match_option,1,5) MATCH,

substr(shipment_type,1,7) SHIP_TYPE,

substr(line_location_id,1,7)  LINE_LOC,

substr(po_line_id,1,7) LINE_ID,

substr(closed_code,1,15)  CLOSE_CODE,

substr(quantity,1,5) QTY,

substr(quantity_received,1,5)  Q_REC,

substr(quantity_accepted,1,5) Q_ACCEPT,

substr(quantity_billed,1,5) Q_BILL,

substr(receive_close_tolerance,1,10)  C_TOL

from po_line_locations_all

where po_header_id = XXXX;

According to Bug 2277946, this problem is occurring because the closed_code

value is NULL, it should read OPEN.

Please back up the po_line_locations_all table prior to running the update.

UPDATE  po_line_locations_all

SET  closed_code = 'OPEN'

WHERE po_header_id=XXXXX

AND closed_code is null;

cause: Bug 2277946

After entering receipt number in Find receipts window,

receive FRM-40735: POST-QUERY trigger raised unhandled

exception ORA-1403.  Details button 'ORA-1403 no data

found'.

fix:

If currently on an older version of apmatchb.pls then 115.31, apply

patch#1765553 to get to this version 115.31.

If the problem persists:

SELECT segment1,po_header_id

FROM po_headers_all

WHERE segment1 = ;

SELECT po _header_id,closed_code

FROM po_line_locations_all

WHERE po_header_id = ;

If the closed_code is null then apply AP Patchset J Patch#2375849 or higher.