Payables and Cash Management - EBS (MOSC)

MOSC Banner

Query for business days

Hello,

I am developing a query for a Accounts Payable report that will inform me if an employee did not submit their report within 25 business days. Something like show me if attribute2 is greater than 25 business days

I think I am making this too complicated. Any help is greatly appreciated.



select distinct

erp.invoice_num,

erp.total,

erp.attribute1,

erp.attribute2,

erp.report_submitted_date,

ppf1.email_address,

ppf.first_name,

ppf.last_name,

TO_DATE(TO_DATE(erp.ATTRIBUTE2,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-RRRR')+25


from 

ap_expense_report_headers_all erp, 

per_ALL_people_F ppf,

PER_ALL_ASSIGNMENTS_F PAA,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center