R12: AP: Cannot Close Period, no Exceptions, no Stuck MANUAL Events
(Doc ID 1325169.1)
Last updated on OCTOBER 13, 2020
Applies to:
Oracle Payables - Version 12.1.2 and laterInformation in this document applies to any platform.
Symptoms
Cannot close Payables period, but Period Close Exception report does not list any exception, the Check Close report is clean, and the following query does return rows (i.e. no MANUAL events "stuck" in SLA):
SELECT
xte.security_id_int_1 org_id,
xte.entity_id,
xte.entity_code,
xte.transaction_number,
xte.source_id_int_1 transaction_id,
xe.event_id,
xe.event_type_code,
xe.event_date,
xe.upg_batch_id
FROM
xla_events xe,
xla.xla_transaction_entities xte
WHERE
1 = 1
AND xe.entity_id = xte.entity_id
AND xe.application_id = 200
AND xte.application_id = 200
AND xe.event_type_code = 'MANUAL'
AND (
xe.event_status_code != 'P'
OR xe.process_status_code != 'P'
)
AND EXISTS (
SELECT
1
FROM
xla_ae_headers xah
WHERE
xah.event_id = xe.event_id
AND xah.application_id = xe.application_id
AND xah.accounting_entry_status_code = 'F'
AND xah.event_type_code = 'MANUAL'
);
xte.security_id_int_1 org_id,
xte.entity_id,
xte.entity_code,
xte.transaction_number,
xte.source_id_int_1 transaction_id,
xe.event_id,
xe.event_type_code,
xe.event_date,
xe.upg_batch_id
FROM
xla_events xe,
xla.xla_transaction_entities xte
WHERE
1 = 1
AND xe.entity_id = xte.entity_id
AND xe.application_id = 200
AND xte.application_id = 200
AND xe.event_type_code = 'MANUAL'
AND (
xe.event_status_code != 'P'
OR xe.process_status_code != 'P'
)
AND EXISTS (
SELECT
1
FROM
xla_ae_headers xah
WHERE
xah.event_id = xe.event_id
AND xah.application_id = xe.application_id
AND xah.accounting_entry_status_code = 'F'
AND xah.event_type_code = 'MANUAL'
);
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |