EPC: On Third Party Rvw Transactions Page, the Transaction Type Field Is Getting a Default Value of “PC_journal” When Underlying Field INTFC_PROJ_RES.KK_SOURCE_TRAN Value Is Blank. Is It Expected Behavior? (Doc ID 2974364.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Goal

The INTFC_PROJ_RES.KK_SOURCE_TRAN field is automatically defaulted to "PC_JOURNAL" in the interface staging table when opened online for review. If the review page is saved this value is saved to the table. Is it expected behavior?

Scenario:

1. Enable Commitment Control for Project Costing. (Set Up Financials/Supply Chain > Install > Installation Options - Products)
2. When inserting data into INTFC_PROJ_RES, populate the ledger group value that is enabled for commitment control. The navigation can be used to check whether commitment control is enabled or not for the ledger group. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Ledger for a Unit)
3. Make sure that the field Commitment Control Amount Type is populated for the analysis type used for the transaction. In the Demo, for the 'ACT' analysis type, the Commitment Control Amount Type value is populated as "Actuals and Recognized" and the Source Transaction Type is defaulted as "PC_JOURNAL". (Set Up Financials/Supply Chain > Product Related > Project Costing > Transaction Options > Setup PC Analysis Types)
4. Make sure the data is inserted with a blank value for  INTFC_PROJ_RES.KK_SOURCE_TRAN.
5. Now open this transaction online using Project Costing > Third Party Integration > Third Party Rvw Transactions page. Notice that the Transaction Type field has a value of "PC_JOURNAL" and when saved this value is updated in the table field INTFC_PROJ_RES.KK_SOURCE_TRAN for the transaction.

Solution

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