Hi,
I ran a sample from
https://java.net/projects/oraclesoasuite11g/pages/AppsAdapters
to create a sales order, sample runs fine.
The problem that I have is this - sample tells me to create a pl/sql custom package under APPS schema:
"Set up the wrapper package on target DB (The database on which you intend to
run this sample) by executing XX_BPEL_FND_REQUEST_WRAPPER.sql as
APPS/APPS."
I don't want to have custom objects under APPS so I tried to create it under BOLINF, create synonym, grant.
But that didn't work, I am getting this error
ORACLE error -904 in SUBMIT: others Cause: SUBMIT: others failed due to ORA-00904: "FND_CONC_GLOBAL"."OPS_INST_NUM": invalid identifier. The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE
which indicates that the package can not be found.
Did anyone happen to make it work when package is created under schema different from APPS? If yes was that done with data source pointing to APPS or different one?
Thank you,
Anatoliy