Get APP-PO-14142: Error Trying To View Accounting Events From Receiving Transaction Form (Doc ID 2236919.1)

Last updated on OCTOBER 01, 2021

Applies to:

Symptoms

Customer uses PMAC for their primary ledger. They have a requirement to not only run Standard Costing as well to compare costs, but to have a Secondary Ledger using Standard Costing, because they need the journal body created by OPM Accounting Pre-Processor for their reporting. They absolutely do not want to run Create Accounting for the Secondary Ledger, however.

They have a problem when using Tools > View Accounting Events on Receiving Transaction Form. Error message below popped up.

"APP-PO-14142: rcv_transactions_stuff0.view_acct:x_opm_xla_status_code2-000: ORA
Cause: A SQL error has occurred in rcv_transactions_stuff0.view_acct:x_opm_xla_status_code2. The SQL error is ORA-0000: normal, successful completion."

This problem can be reproduced by going to the Purchasing responsibility, then:

1. Receiving > Receiving Transactions
2. Select a Process Manufacturing Organization
3. Query a receipt transaction
4. Click Transaction button
5. Select one transaction type line, either Receive / Deliver
6. Tools > View Accounting Events
7. Error message shown.

This appears to be because Create Accounting has not been run on the Secondary Ledger. Note 1562015.1 states that both OPP and Create Accounting must have been run. It seems Patch 13618593 made a change in this area which apparently introduced the requirement to run Create Accounting for the Secondary Ledger in order for View Accounting Events on Receiving Transaction form to work.

So customer seems to be stuck. They need to have the secondary ledger with Std Costing for their reporting, but they do not want Create Accounting run for the secondary ledger, and this seems to prevent View Accounting Events on Receiving Transactions to not work.

Cause

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