This is a bug in Oracle 12.1. When you have a table in one schema (Schema1) with a sequence on some column and you want to insert in that table from another schema (Schema2), error message “ORA-00942: table or view does not exist” is displayed. This happens although you have privileges to select, insert, update or delete on the table in Schema1. To fix that, you need to grant SELECT on the sequence too. Hope Oracle find a way to display more suitable error message in such cases.
Example:
Table Event in Schema1 :
GRANT SELECT,INSERT,UPDATE,DELETE ON Event TO Schema2;
GRANT SELECT ON Event_Id_SEQ TO Schema2;
APEX App Lab - Blog 
hi,
I want to call https://***********.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/inventoryTransactions which is POST method to create a Miscellaneous Transaction in oracle Fusion Inventory (SaaS)
When I call from POSTMAN it success cerate transaction, I use the following Jason request body :
{
“transactionLines”:
[
{“OrganizationId” : 300000004134859,
“Item” : “SP-10001”,
“Subinventory” : “ADFINV”,
“TransactionType” : “Miscellaneous issue”,
“TransactionUnitOfMeasure” : “ECH”,
“TransactionQuantity” : -20,
“TransactionDate” : “2022-03-26”,
“DistributionAccountId”: 300000003917588
} ]
}
How could I call this API and Pass the previous Request Body from Apex page using Dynamic Action or Process
thanks
LikeLike