Shulou(Shulou.com)06/02 Report--

Transferred from: http://blog.csdn.net/yy5512/article/details/4404772

Unable to create accounting entry

Patching: 6826219 and 6901404

The principle of treatment:

If you fail to create an accounting entry, just change both xla_events.event_status_code and xla_events.process_status_code to'U'.

Then submit the request or create an accounting entry directly in the * * interface.

Create an accounting entry program regardless of whether xla_ae_headers and xla_ae_lines have records corresponding to xla_events

Both xla_ae_headers and xla_ae_lines records are recreated

Dealing with accounts payable * * cannot create an accounting entry example 1:

Create table xla_events_bkp

As select * from xla_events

Where event_id in (select event_id from xla_events e

Where e.application_id = 200

And e.event_status_code ='P'

And not exists (select 1 from xla_ae_headers h

Where e.event_id = h.event_id))

UPDATE xla_events

SET event_status_code ='U'

Process_status_code ='U'

WHERE event_id IN (select event_id from xla_events e

Where e.application_id = 200

And e.event_status_code ='P'

And not exists (select 1 from xla_ae_headers h

Where e.event_id = h.event_id))

Run the request

Dealing with accounts payable * * cannot create an accounting entry example 2:

* * part of No. 200803005 (cancelled) creates an accounting entry. Payment number 1102000006 cannot create an accounting entry.

Because there is sex first and then payment, so the train of thought

1. First try to create an accounting entry for *.

SELECT invoice_num,invoice_id,doc_sequence_id,doc_sequence_value FROM ap_invoices_all

WHERE invoice_num = '200803005'

Select event_id,ae_header_id,a.* from xla_ae_headers a

WHERE doc_sequence_id = 130

AND doc_sequence_value = '210401983'

SELECT event_id,a.* FROM xla_ae_headers a

WHERE event_id IN (70300,80395)

Find the event_id=70300,ae_header_id=57016 where the xla_ae_headers record did not create an accounting entry

DELETE FROM xla_ae_lines

WHERE ae_header_id = 57016

DELETE FROM xla_ae_headers

WHERE ae_header_id = 57016

UPDATE xla_events

SET event_status_code ='U'

Process_status_code ='U'

WHERE event_id = 70300

Run the request

two。 Then try to create an accounting entry for payment

SELECT * FROM xla_ae_headers

WHERE DESCRIPTION LIKE '02000006%'

AND je_category_name = 'Payments'

DELETE xla_ae_lines

WHERE ae_header_id IN (101270 and 101271)

DELETE xla_ae_headers

WHERE ae_header_id IN (101270 and 101271)

UPDATE xla_events

SET event_status_code ='U'

Process_status_code ='U'

WHERE event_id IN (70302 and 80394)

Run the request

Deal with accounts payable * * cannot create an accounting entry example 3

The reason for not creating an accounting entry is that ET1104 payable * * No. 8000480849 * * 859 * * did not create an accounting entry:

The * * lines 1 and 2 have been discarded.

The account in the profit and loss bank is invalid. If you have defined a profit and loss journal line type, check the account derivation rules attached to that type in the journal line definition. Otherwise, check the exchange gain account and exchange loss account that are mapped to the accounting attributes

The source value of the

The account cannot be created because all the conditions for the & OWNER-owned account derivation rule & COMPONENT_NAME are not met. Please update the conditions of & COMPONENT_NAME, or assign other accounts to derive rules to & PAD_OWNER owned

Apply product accounting definition & PAD_NAME.

Sub-ledger accounting cannot use & OWNER-owned account derivation rule & COMPONENT_NAME to export accounting account code combinations. Please review the account derivation rule and make sure that this rule can be exported for the source values passed for this transaction

Effective combination of flexible domains of accounting accounts.

According to the above error message, please check the account derivation rules related to exchange gains and losses when the bank is abandoned, which is mapped to the source values of the accounting attributes "exchange gain account" and "exchange loss account".

But the consultant did not check to see if there was a problem with the setting. This may be a bug of oracle.

Temporary treatment:

* * allocation rows and * * rows of abandoned rows are deleted directly in the table

CREATE TABLE AP_INVOICE_DISTRIBUTIONS_0427

AS SELECT * FROM AP_INVOICE_DISTRIBUTIONS_all

WHERE invoice_id = 15761 and invoice_line_number IN (1Jue 2)

SELECT * FROM AP_INVOICE_DISTRIBUTIONS_0427

CREATE TABLE AP_INVOICE_LINES_0427 as

SELECT * FROM AP_INVOICE_LINES_all

WHERE invoice_id = 15761

AND line_number IN (1 dint 2)

SELECT * FROM AP_INVOICE_LINES_0427

DELETE FROM AP_INVOICE_DISTRIBUTIONS_all

WHERE invoice_id = 15761 and invoice_line_number IN (1Jue 2)

DELETE FROM AP_INVOICE_LINES_all

WHERE invoice_id = 15761

AND line_number IN (1 dint 2)

Create an accounting entry directly in the * * interface

Final solution: users are advised to mention that tar should be officially solved by oracle

Dealing with accounts payable * * cannot create an accounting entry example 4:

This one * * 2008030888. The reason why the accounting entry cannot be created is that the allocation information of * * is not entered.

Dealing with accounts payable * * cannot create an accounting entry example 5:

After the standard * * write-off advance payment * *, some accounting entries cannot be created. Booked display: partial

Measures:

First verify the relevant * * on the * * interface, and then create an accounting entry on the * * interface.

Dealing with accounts payable * * cannot create an accounting entry example 6:

Luo Yongping employees due to EBS bug, and then import the expense report, produce two Luo Yongping suppliers, after deleting one of the suppliers and supplier location

The generated accounting entry information actually has the ID of the deleted supplier and the supplier location ID.

Measures:

Found xla_ae_lines.party_id (found here that some entries were created based on previous entries, such as ref_event_id,ref_ae_header_id)

So all the xla_ae_lines.party_id,xla_ae_lines.party_site_id has been changed to the current Luo Yongping supplier ID and supplier location ID.

Run the cux_fix_invoice_accounting_pkg.fix_invoices program to correct the data

Run the request

Package cux_fix_invoice_accounting_pkg for correcting the data:

CREATE OR REPLACE PACKAGE cux_fix_invoice_accounting_pkg IS

PROCEDURE fix_invoices (p_invoice_id IN NUMBER)

PROCEDURE fix_payments (p_payment_num IN VARCHAR2)

END

/

CREATE OR REPLACE PACKAGE BODY cux_fix_invoice_accounting_pkg IS

PROCEDURE fix_invoices (p_invoice_id IN NUMBER) IS

CURSOR cur_invoice (i_cur_invoice_id IN NUMBER) IS

SELECT doc_sequence_id,doc_sequence_value FROM ap_invoices_all

WHERE invoice_id = i_cur_invoice_id

CURSOR cur_xla_ae_headers (i_cur_doc_sequence_id IN NUMBER,i_cur_doc_sequence_value IN NUMBER) IS

SELECT event_id,ae_header_id from xla_ae_headers

WHERE doc_sequence_id = i_cur_doc_sequence_id

AND doc_sequence_value = i_cur_doc_sequence_value

BEGIN

FOR rec_invoice IN cur_invoice (p_invoice_id) LOOP

FOR rec_xla_ae_headers IN cur_xla_ae_headers (rec_invoice.doc_sequence_id,rec_invoice.doc_sequence_value) LOOP

INSERT INTO xla_ae_lines080421

SELECT * FROM xla_ae_lines

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

INSERT INTO xla_ae_headers080421

SELECT * FROM xla_ae_headers

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

DELETE xla_ae_lines

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

DELETE xla_ae_headers

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

END LOOP

END LOOP

UPDATE xla_events

SET event_status_code = 'Upright pageanal processprocessing statusThe code =' U'

WHERE event_id IN (SELECT event_id FROM xla_events e

WHERE e.application_id = 200

AND e.event_status_code ='P'

AND NOT EXISTS (SELECT 1 FROM xla_ae_headers h

WHERE e.event_id = h.event_id))

COMMIT

END

PROCEDURE fix_payments (p_payment_num IN VARCHAR2) IS

CURSOR cur_xla_ae_headers (i_cur_payment_num IN NUMBER) IS

SELECT event_id,ae_header_id from xla_ae_headers

WHERE description LIKE'%'| | i_cur_payment_num | |'%'

AND je_category_name = 'Payments'

BEGIN

FOR rec_xla_ae_headers IN cur_xla_ae_headers (p_payment_num) LOOP

INSERT INTO xla_ae_lines080421

SELECT * FROM xla_ae_lines

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

INSERT INTO xla_ae_headers080421

SELECT * FROM xla_ae_headers

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

DELETE xla_ae_lines

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

DELETE xla_ae_headers

WHERE ae_header_id = rec_xla_ae_headers.ae_header_id

END LOOP

UPDATE xla_events

SET event_status_code = 'Upright pageanal processprocessing statusThe code =' U'

WHERE event_id IN (SELECT event_id FROM xla_events e

WHERE e.application_id = 200

AND e.event_status_code ='P'

AND NOT EXISTS (SELECT 1 FROM xla_ae_headers h

WHERE e.event_id = h.event_id))

COMMIT

END

END

/

-- =

Processing transactions receivable cannot create an example of an accounting entry:

Credit memo 11040000002921 cannot create an accounting entry

Find the original * * 11040000002801 corresponding to the credit memo 11040000002921 through the interface

It was found that 11040000002801 did not create an accounting entry. 11040000002801 created an accounting entry successfully on the interface.

Credit memo 11040000002921 after pressing the finish button, it is found that it cannot be saved and do the tracking constraint value.

Find the last few sentences of the trace file

*

SELECT AE.EVENT_ID, AE.EVENT_DATE, AE.EVENT_STATUS_CODE, AE.EVENT_TYPE_CODE

FROM

XLA_EVENTS AE, XLA_TRANSACTION_ENTITIES_UPG XT, RA_CUSTOMER_TRX_ALL TRX

WHERE TRX.CUSTOMER_TRX_ID =: B3 AND NVL (XT.SOURCE_ID_INT_1,-99) =

TRX.CUSTOMER_TRX_ID AND XT.ENTITY_CODE = 'TRANSACTIONS' AND XT.LEDGER_ID =

TRX.SET_OF_BOOKS_ID AND XT.ENTITY_ID = AE.ENTITY_ID AND XT.APPLICATION_ID =

222 AND AE.APPLICATION_ID = 222 AND NVL (AE.EVENT_DATE, TO_DATE ('01-01-1900')

'DD-MM-YYYY')) =: B2 AND AE.EVENT_STATUS_CODE' P' AND: B1 =

AE.EVENT_TYPE_CODE

Call count cpu elapsed disk query current rows

--

Parse 1 0.00 0.00 00 00

Execute 1 0.00 0.00 00 00

Fetch 1 0.00 0.00 0 11 2 1

--

Total 3 0.00 0.00 0 11 2 1

Misses in library cache during parse: 0

Optimizer mode: ALL_ROWS

Parsing user id: 44 (recursive depth: 1)

*

SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY

SEVERITY

FROM

FND_NEW_MESSAGES M, FND_APPLICATION A WHERE: B3 = M.MESSAGE_NAME AND: B2 =

M.LANGUAGE_CODE AND: B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID =

A.APPLICATION_ID

Call count cpu elapsed disk query current rows

--

Parse 0 0.00 0.00 00 00

Execute 1 0.00 0.00 00 00

Fetch 1 0.00 0.00 00 00

--

Total 2 0.00 0.00 00 00

Misses in library cache during parse: 0

Optimizer mode: ALL_ROWS

Parsing user id: 44 (recursive depth: 1)

*

ROLLBACK TO AR_PAYMENT_SCHEDULE

SELECT AE.EVENT_ID, AE.EVENT_DATE, AE.EVENT_STATUS_CODE, AE.EVENT_TYPE_CODE FROM XLA_EVENTS AE, XLA_TRANSACTION_ENTITIES_UPG XT, RA_CUSTOMER_TRX_ALL TRX WHERE TRX.CUSTOMER_TRX_ID =: B3 AND NVL (XT.SOURCE_ID_INT_1 -99) = TRX.CUSTOMER_TRX_ID AND XT.ENTITY_CODE = 'TRANSACTIONS' AND XT.LEDGER_ID = TRX.SET_OF_BOOKS_ID AND XT.ENTITY_ID = AE.ENTITY_ID AND XT.APPLICATION_ID = 222AND NVL (AE.EVENT_DATE, TO_DATE (' 01-01-1900)) =: B2 AND AE.EVENT_STATUS_CODE 'P'AND: B1 = AE.EVENT_TYPE_CODE

END OF STMT

PARSE # 358 Vulcan Centro Magistracy 53Different Pige0Entropy 4237611529714 Ecologium 53Different0pyrrhen0memorialCutz0memorio Mishing0rewriting0memorial0leglegleglegleglegleglegleg1cobliclerecommerce

BINDS # 358:

Kkscoacd

Bind#0

Oacdty=02 mxl=22 (21) mxlc=00 mal=00 scl=00 pre=00

Oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0

Kxsbbbfp=110ad52a0 bln=22 avl=04 flg=09

Value=22716

Bind#1

Oacdty=12 mxl=07 (07) mxlc=00 mal=00 scl=00 pre=00

Oacflg=13 fl2=206001 frm=00 csi=00 siz=8 off=0

Kxsbbbfp=110ad52d0 bln=07 avl=07 flg=09

Value= "5Action23Compact 0:0:0"

Bind#2

Oacdty=01 mxl=32 (09) mxlc=00 mal=00 scl=00 pre=00

Oacflg=13 fl2=206001 frm=01 csi=871 siz=32 off=0

Kxsbbbfp=110ad4a60 bln=32 avl=09 flg=09

Value= "CM_CREATE"

Substitute the specific parameter values into the sql statement to get:

SELECT AE.EVENT_ID, AE.EVENT_DATE, AE.EVENT_STATUS_CODE, AE.EVENT_TYPE_CODE

FROM XLA_EVENTS AE

XLA_TRANSACTION_ENTITIES_UPG XT

RA_CUSTOMER_TRX_ALL TRX

WHERE TRX.CUSTOMER_TRX_ID = 22716

AND NVL (XT.SOURCE_ID_INT_1,-99) = TRX.CUSTOMER_TRX_ID

AND XT.ENTITY_CODE = 'TRANSACTIONS'

AND XT.LEDGER_ID = TRX.SET_OF_BOOKS_ID

AND XT.ENTITY_ID = AE.ENTITY_ID

AND XT.APPLICATION_ID = 222,

AND AE.APPLICATION_ID = 222,

AND NVL (AE.EVENT_DATE, TO_DATE ('01-01-1900, 'DD-MM-YYYY')) = to_date (' 2008-05-23 00 MMMI DD HH24:MI:SS')

AND AE.EVENT_STATUS_CODE'P'

AND 'CM_CREATE'= AE.EVENT_TYPE_CODE

That is to say, the above SQL statement should not have a value when pressing the finish button, that is, the record of XLA_EVENTS.EVENT_STATUS_CODE'P' should not exist.

Measures:

1. AE.EVENTSTATUScodes are temporarily changed to'P'.

Then press the finish button, and this time the save is successful.

two。 Change all AE.EVENT_STATUS_CODE,ae.process_status_code back to'U'.

Check whether xla_ae_headers,xla_ae_lines has data

SELECT * FROM xla_ae_headers--no row

WHERE event_id IN (162517pm 162518)

SELECT * FROM xla_ae_lines--no row

Successfully create an accounting entry for 11040000002801 on the interface

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.