Field Service / Service to Projects Integration: Interface Service Cost to Projects Program does not Feed Raw Cost (DR_CODE_COMBINATION and CR_CODE_COMBINATION) (Doc ID 1988499.1)

Last updated on DECEMBER 08, 2021

Applies to:

Symptoms

On 12.2.4 -

For Material Service Activity Codes tagged to Custom Transaction Sources where the “GL Costed and Accounted” flag is checked the Interface Service Cost to Projects program does not feed the raw cost.
It does not populate the DR_CODE_COMBINATION and CR_CODE_COMBINATION columns.

EXPECTED BEHAVIOR
-----------------------

Expect that the DR_CODE_COMBINATION and CR_CODE_COMBINATION need to be populated as per setup.
Expect the Material standard cost as defined against the Debrief organization’s Cost schedule in Cost Management.


STEPS
-----------------------

1) Custom Transaction Source is created in PA

2) The Service Activity codes are setup in Services
 
3) The Transaction Source which is created in PA is tagged to the Billing Types for the below Service Activity Code

Followed process:

1) A Service Request is created in Field Service. Tasks are created and assigned to a Field Service Technician.
2) Field Technician updates the Debrief against the Task using the Service Activity Codes.
3) Once Debrief is completed, the charges are created in Service.
4) Now a standard concurrent Program "Interface Service Cost to Projects" is executed.
5) This brings in the cost lines into the PA_TRANSACTION_INTERFACE_ALL table for every Debrief line cost_id.
=> The cost lines in the interface for the Material Debrief, columns like DR_CODE_COMBINATION/CR_CODE_COMBINATION etc., are NOT populated.

Changes

Cause

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