Topics started by Kyle

2 Topics

K
Do Gooder (Customer)
KyleDo Gooder (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)

Procurement - Automatic Order Processing - Offset from Normal Time Span

Hi,What exactly does Offset from Normal Time Span do in the Automatic Order Processing process?If we set up a Order Process type to only release Req’s and set an offset to 10, does this mean it will only release Req’s where the Latest Order Date is within 10 days?Not sure what date the offset uses and could not find in the help.Thanks!

2
Vimukthi Mahakumbura
Superhero (Employee)
1 year ago
K
Do Gooder (Customer)
KyleDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

SQL Quick Reports - Custom Function

Hi,I created a custom oracle function in app owner schema.I granted EXECUTE to IFSAPP, IFSINFO, IFSPRINT and IFSSYS on the function.The SQL Quick report that uses this function is throwing a ORA-00904 error which I know means it can’t find it.I am calling the function within a SQL statement as <appowner>.<myfunction>.Are we able to use custom functions in a  quick report?And if so, what user needs access to it?  I thought it was IFSPRINT but apparently I am wrong.Thanks!

2
K
Do Gooder (Customer)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings