You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to call a service logistics PVO from an SQL query from BI Publisher and BI Administration

Question
23
Views
0
Comments

How to call a service logistics PVO from an SQL query from BI Publisher .

We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesPVO from SQL query, but we are getting errors.

From BI Publisher- we are using the following query-

select_physical * from "oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesPVO"

Error- Missing the right Paranthesis.

From BI Administration-

select * from

EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesPVO' as t

FETCH FIRST 100 ROWS ONLY

----------------

Error-State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25003: Object oracle.apps.scm.serviceLogistics.billing.publicView of type ApplicationModule is not found. (HY000)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!