Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

question about Deposit Advice (XML)

edited Nov 3, 2017 5:01AM in Payroll and OTL - EBS (MOSC) 1 commentAnswered

Our environment is EBS R12.1.3 on RHEL7 with a database node and a app tier node.

I'm a DBA working with a Payroll Analyst who is complaining about how long the Deposit Advice (XML) job takes to run so I'm trying to understand what it does.

If I investigate Top Activity via OEM I can see under SQL Tuning the action is 'Tune the entry point PL/SQL "APPS.PAY_CORE_FILES.WRITE_TO_FILE_RAW" of type "PACKAGE".

So this write_file_to_raw suggests we are creating some file external to the database correct?  Is this normal for this job and would it be on the db or app tier?

Tagged:

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

EBS Payroll Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center