My Oracle Support Banner

Retrieve Timecard Data From OTL To EAM Not Marking That The Transaction Has Transferred (Doc ID 2423646.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

After upgrading from R12.1.1 to R12.2.6 , the regular transactions flow from OTL to EAM, for a few employees,
the employee records are not transferred. OTL transactions and approvals setups are correct.

ERROR

Start of EAM_OTL_TIMECARD_PUB.perform_res_txn
EAM_OTL_TIMECARD_PUB.perform_res_txn : Work Order is : xx and Operation is : xx and Resource is : xxxx and Employee is :xx
Resource Sequence Number is : xx
Employee Name is : xxxx
Organization Id is : xx
Resource Code is : xx
Charge Department is :
OTL ENTRY is made for the date: xx
Retreiving the Period Id for the OTL Entry
Period Id for the OTL Entry is: xx
checking if the above period_id is an open period
Start of Resource Validation in WIP_EAM_RESOURCE_TRANSACTION.resource_validate
No charges allowed for this workorder.
After Resource Txn - (N,N)-> (Delete,Change)
FAILURE -- Building Block Processing Failed
Processing Building Blocks : 2


STEPS

The issue can be reproduced at will with the following steps:
1. Run "Retrieve Timecard Data from OTL to EAM" for Person Id :3048
(Organization Id :101)
2. The program errors with the completion text as 'FAILURE -- Resource
Transaction encountered errors; Please look into hxc_transactions table for
details'.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.