Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Expenditure Comments from OTL to projects — Cloud Customer Connect
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

Expenditure Comments from OTL to projects

Received Response
48
Views
3
Comments
edited Jun 1, 2018 3:59PM in Project Management 3 comments

Content

Currently in EBS, SQL was written to bring expenditure comment and Project Work comments from timecard into Projects. How does this work in fusion? Do the timecard comments interface to projects form EAM timecard and a projects timecard?

Note: We use the EBS standard process PRC: Transaction Import using parameter Oracle Time and Labor which creates the projects interface table (PA_EXPENDITURE_ITEMS_ALL).  Since the Oracle EBS standard interface does not pull over user comments from OTL, we have used the client extension provided by Oracle and created custom concurrent process to pull comments from OTL (HXC_TIME_ATTRIBUTES.ATTRIBUTE4) to project comments table (PA_EXPENDITURE_COMMENTS) for each corresponding project expenditure item related to payroll.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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