PRC: Interface Supplier Costs Errors With an Invalid Error 'The Expenditure Organization is Not Active' - Reversals Shows PA_ADDITION_FLAG=N While the Original Amounts Shows PA_ADDITION_FLAG=G (Doc ID 3015208.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

The PRC: Interface Supplier Costs was run.  The AUD: Supplier Costs Interface Audit report shows the invoice distributions rejected with,

The expenditure organization is not active.

Further research shows the User cancelled invoice distribution lines, but causes the ap_invoice_distributions_all.pa_addition_flag=N. The original amounts of the invoice distributions line has ap_invoice_distributions_all.pa_addition_flag=G. The ap_invoice_distributions_all.pa_addition_flag=N appears to be incorrect as the original invoice distribution lines were never transferred to PA.

The expenditure organization is active and in the hierarchy.  The pa_all_organizations table shows the organization_id and org_id does not have any inactive dates.

The Generic Datafix patch 22311067:R12.PJC.B was applied, bit coming across with errors when running the s22311067q.sql script.

Replication steps:

1. Navigate to > Projects responsibility > Other > Requests > Run. 

2. Run the PRC: Interface Supplier Costs process. 

3. Review the AUD: Supplier Costs Interface Audit report for errors.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.