DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how can i incorpurate multiple operating unit feature in rdf(Custome AP Report)

User_UD5PLSep 13 2013 — edited Sep 18 2013

Hi, Team,

i have a requirment is..will select 1 Operating unit need to get data for only that OU, if will provide Null value need to get data for ALL OU's.

i am trying below script using in Report level 'AfterPForm'

if :P_ORG_ID IS NULL THEN MO_GLOBAL.SET_POLICY_CONTEXT('M',null);

ELSE MO_GLOBAL.SET_POLICY_CONTEXT('S',:P_ORG_ID);

END IF;

getting below error.

Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing APPLLCSP Environment Variable set to : Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are : AMERICAN_AMERICA.AL32UTF8 '.,' Enter Password: MSG-00000: And so it begins ... MSG-00001: After SRWINIT REP-1419: 'beforereport': PL/SQL program aborted. REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00000: And so it begins ... MSG-00001: After SRWINIT REP-1419: 'beforereport': PL/SQL program aborted.

but this report running fine for Single OU, that is the parameter value is provided.

appriciate your assistence on this. need to clos this ASAP, please do the needfull.

Thanks,

Venkat.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2013

Added on Sep 13 2013

#error, #oracle, #reports

3 comments

903 views