How to Rollback SSHR Transaction in Oracle Self Service

How to Rollback SSHR Transaction in oracle apps.begin
hr_transaction_api.rollback_transaction(p_transaction_id);
end;

commit;

Note:

p_transaction_id is the transaction_id that you will find in hr_api_transaction table.

After executing the above statement you will not find any record in hr_api_transaction

OTL API to delete whole time card for the week

DECLARE
   -- Constant declarations
   l_otl_appl_id CONSTANT NUMBER (3) := 809; --OTL application id
   l_resp_appl_id NUMBER (10) := 51102; --OTL Responsibility id
l_user_id VARCHAR2 (20) := 120345; -- id from fnd_user table
BEGIN
-- First initialize your session, this needs to be done for internal reasons so
-- the TimeStore knows who is trying to deposit the information. When you log
-- into SS, the same is done for you by the framework, here however we have to do
-- it manually.
FND_GLOBAL.
APPS_INITIALIZE (user_id => l_user_id,
resp_id => l_resp_appl_id,
resp_appl_id => l_otl_appl_id); -- This is the appl_id for OTL, do not change

--
--Delte time card API calling
--
hxc_timestore_deposit.DELETE_TIMECARD (p_building_block_id => 3423423); --p_building_block_id is the timecard id with scope 'Timecard' and endate should be ''12/31/4712

COMMIT;
END;

Graphs are not appearing in XML/BI Publisher reports - How to debug it?

1. Make sure that graphs are appearing in XML Publisher Desktop
2. Deploy the report in Oracle Apps
3. Run the report. Graphs are not appearing.
4. Use http://oraclesanpra.blogspot.ae/2013/06/how-to-find-opp-log-file.html to generate OPP log and provide that to DBA. Check if OPP log has below error message

“Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Error invoking 'chart_svg':'java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment'”

How to find OPP log File?

To investigate on XML issues or other publishing problems, often the OPP logfile is needed.
OPP stands for Output Post Processor. Below are the steps to find log file

1. Login to the application as SYSADMIN

2. Responsibility: System Administrator

3. Function: Concurrent --> Manager --> Administration

4. Select the Output Post Processor

5. Click on the Processes button

6. Select the Concurrent Process which was active during the time that the request ran

7. Click on the Manager Log button to open the Output Post Processor log file


Cheersss...

How to Identify Layout ldt file name in Oracle Time and Labor(OTL)

Check Page 13 of hxcconfiguiwp.pdf document

Clear Cache Shortcut in Functional Administrator

Function Name - Cache Component Global Configuration Page

Updating Layout in Oracle Time and Labor (OTL)

Steps:
1. Download the correct ldt file from $HXC_TOP/patch/115/import/US
2. Update the LDT file to removed the unnecessary part. Remove the whole "Begin End" part.
3. Go to dir: $HXC_TOP/patch/115/import/US and Upload the updated file to the directory
4. Issue the following Cmd:
FNDLOAD username/password@dbname 0 Y UPLOAD $HXC_ TOP/patch/115/import/hxclaytlayoutsld.lct hxczzhxclayt0030.ldt
5. Check the log file
6. Bounce apache
7. Login and check.


Done!!!