1. Support Desk.
  2. Reports
  3. ERP Armor: Reports for ERP Cloud (OTBI)

What is Query 27: Invoice Holds and Releases?

The table(s) covered in this query are described by Oracle as follows:
Contains information about hold codes and release codes that you or your Oracle Payables application can place on an invoice. There is one row for each hold or release code. When you enter or validate an invoice, you can select a hold code that you defined in this table. Your Oracle Payables application also uses these hold codes when it places matching and tax variance holds during Invoice Validation. Your Oracle Payables application stores translations of HOLD_LOOKUP_CODES in the AP_LOOKUP_CODES table. This table corresponds to the Invoice Hold and Release Names window.

Sensitive Access Risk Rule ID:
PP260

Risk Description: Allows definition of holds to manually hold or release invoices, and release names used to remove holds that are applied on invoices.Q27_Invoice Hold and Release Names