Regards, Zahid Rahim. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. distribution_line_number. DENORM_TOP_ELEMENT_ID. attribute_category Pjc_Expenditure_Type, PjcExpAtrbsUsg. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Project Description 3. FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL. Applies to: Oracle Project Costing - Version 11. inventory_item_id}. AND ppald. PA_EXPEND_ITEM_ADJ_ACTIVITIES stores audit records of actions chosen by users in any of the Oracle Projects expenditure adjustment windows that may cause adjustments to the cost, revenue, and/or invoice amounts of an expenditure item. Unit Number 4. To get the. tm_rep_atrb_id Pjc_Exp_Time_Repos_Atrb_id, PjcExpAtrbs. (EMP_MAND_FOR_. pjc_task_id task_id, crt. AND TSRC. 1) Last updated on JULY 25, 2023. project_id, expenditureitempeo. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. E means Encumbrance entry. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. NAME AS expenditure_org, v55152034. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields. pjc_exp_items_all: pjf_proj_elements_b: TASK_ID: pjf_proj_elements_b: pjf_proj_elements_b: PARENT_STRUCTURE_ID:. AP_Invoices_All has the unique key on invoice_id. project_id AND pei. This table is used to store the errors that could ocurr in various processes in project billing. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. expenditure_item_id AND ptv. 0 and later Information in this document applies to any platform. expenditure_item_id. Object type: TABLE. 1. expenditure_item_id = pei. Contents. Skip to Content; Skip to Search; Home; Cloud ApplicationsIf you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. GL Account analysis for PA Events */. ← Configurator Concurrent Programs. FROM hwm_tm_rep_atrbs PjcExpAtrbs, hwm_tm_rep_atrb_usages PjcExpAtrbsUsg, HWM_TM_ATRB_FLDS_B PjcExpAtrbFlds. TRANSFERRED_FROM_EXP_ITEM_ID. 1. TRANSACTION_NUMBER. Details. project_id = pei. Requirement: --------------- 1. Also PO_DISTRIBUTIONS_ALL is the table which in my experience connects Purchase. inventory_item_id}. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and corresponding id). On : 11. ei_project_name, x. Cloud Applications. name; application_id. Project Portfolio. vendor_name. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. AP_INVOICES_ALL is the parent table of AP_INVOICE_LINES_ALL table which is used to store the Invoice Line Details. Asset Cost 6. Joining these tables, there are rows with opposite capitalizable_fl… Accepted answerI am looking to pull the External Invoice Status of project expense in Oracle Fusion for a BIP Report. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. (SELECT expenditureitempeo. source_project_id. AND ct. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Details. project_id AND pei. Value will be RCV. Possible values are S for Submitted,P for Processed and E for Error: ADJUSTMENT_FLAG: VARCHAR2: 1: Indicates whether the batch that will be impoted is for expenditure item adjustments: CREATION_DATE:. project_id AND pei. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). FROM pjc_exp_items_all ei , pjc_cost_dist_lines_all cdl, xla_events_gt imp, GL_ENCUMBRANCE_TYPES_VL GLET, pjf_txn_document_b doc. Dear All, About Oracle Fusion Applications Cloud (Oracle's SaaS ERP) . FROM pjc_exp_items_all expenditureitempeo) v457612106, pjc_cost_dist_lines_all pcdl, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp, hr_all_organization_units haou,. All Revenue Management. 1) Last updated on NOVEMBER 17, 2022. quantity. Tables and Views for Project Management; PJC_LOOKUPSGL Account analysis for PA Expenditure & Event query. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. event_id = cdl. event_id = cdl. FROM pjc_exp_items_all ei , pjc_cost_dist_lines_all cdl, xla_events_gt imp, GL_ENCUMBRANCE_TYPES_VL GLET, pjf_txn_document_b doc. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. cdl_line_number. denom_currency_code. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. Tags: PA. 1. PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. project_id = prb. NAME ei_expenditure_org_name, op. Examples of system linkages (Expenditure Type Classes) are: Expense Report, Usages, and Straight Time. line_number AND ail. STEP 2: Populate the data both PJC_TXN_XFACE_STAGE_ALL sheet of template as shown below. Object owner: PJS. r_company, x. Schema: FUSION. project_organization_name, a. 0 version, Manage Project Costs-Allocate Project Costs. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. This guide contains information about tables within. BATCH_STATUS: VARCHAR2: 1: Status of the batch. usages_source_version. Tables for the AP Invoice in Oracle fusion. 2 and laterHi team, We have a scenario for which we need to fetch all the eligible expenditures for a project without using PJC tables like pjc_Exp_items_all, PJC_COST_DIST_LINES_A… Accepted answer Mayank_Khatri 22 views 3 comments 0 points Most recent by Pradeep Balakrishnan Sep 28, 2023 7:04AM Project ManagementPrevious Next JavaScript must be enabled to correctly display this content . cmr_rcv_transaction_id. The inventory item associated with the incurred cost. Hi, I have a report with expenses using tables like (EXM_EXPENSES, exm_expense_reports, exm_expense_types, EXM_EXPENSE_DISTS, pjc_exp_items_all, ap_invoices_all and ap_invoice_distributions_all). NUMBER. Purpose of this report is to derive all projects expenditure and event details with cost information. expenditure_item_id. rev_distribution_id. acct_event_id. Comment - Asset Source Line I need above fields will be in the fixed asset module 1. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. PJC_PROJECT_ID = ppat. How can I Link what exists in the Project Costing Table (PJC_EXP_ITEMS_ALL) with what is Accounted for, through the SubLedgerAccounting (SLA), for a Receipt Accounting origin?Greetings and thanks in advance. transaction_id, 'CST_TRANSACTIONS' source_table, ct. SELECT PjcExpAtrbs. txt), PDF File (. attribute_category Pjc_Attribute_Category, ProjectsAtrbs. ---------------. crt. SELECT pcdl. Details. This is the hash key of the attributes which make up the composite key--- OrgId and ExpressionId ---for the Incentive Compensation Expressions resource and used to uniquely identify an instance of Incentive Compensation Expressions. FROM pjc_cost_dist_lines_all pcdl, pjf_projects_b_v pp, pjf_project_types_b_v ppt, pjf_proj_elements_b_v pt, pjc_exp_items_all pei, pjf_exp_types_b_v pet, pjf_exp_categories_b_v pec, pjc_cint_rate_names pcrn, pjc_cint_rate_info_all pcri PJC_CC_DIST_LINES_ALL. Previous Page. There is one row for each invoice distribution. linked_project_id. invoice_date. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Project Portfolio. EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL. task_id. User-defined number that uniquely identifies the element within a project or structure. Simply search with the table name in google, you’ll get complete details about the table and columns in it. NUMBER. VARCHAR2. PARENT_LINE_NUMBER. WHERE(invoiceheadereo. , revdist. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. AND crt. task_id = ptv. SELECT x. Fusion Inventory Queries2. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. The reason why the distribution is created by linking to the invoice line and the line and the distribution are not limited to one to one. TRANSACTION_SOURCE_ID. PJC_CINT_EXP_TYP_ECL_ALL; PJC_CINT_EXP_TYP_ECL_ALL. project_id(+) AND pei. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Relationship between AP invoice line items and Distributions. Oracle Projects Tables: PA_ACCUM_COLUMNS PA_ACCUM_COLUMN_VALUES PA_ACCUM_TXN_TIME PA_ACTION_SETS PA_ACTION_SETS_AR PA_ACTION_SET_LINES PA_ACTION_SET_LINES_AR PA. description. . prvdr_gl_period_name gl_period, pcdl. Project Foundation, Project Costing, Project Billing, Project Control. 18. AND imp. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. Use it if possible to enhance the performance. Previous Next JavaScript must be enabled to correctly display this content . je_source_name AS JE_SOURCE_NAME,PO_DISTRIBUTIONS_ALL is the table used by Oracle to store the distribution information of Purchase Order Line and by distribution I mean GL account information i. pjc_expenditure_type_id = pet. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. attribute_varchar1 Pjc_Billable_Flag, ProjectsAtrbs. AND imp. This web page provides a list of tables and views for Oracle Fusion Cloud Project Management, a cloud-based application for project portfolio management. agreement_type, a. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Simply search with the table name in google, you’ll get complete details about the table and columns in it. name AS Ledger_name, GJS. 50. WHERE ei. The labor cost multiplier is populated for all overtime expenditure items charged to the task upon manual entry of the items or in the Overtime Calculation program **. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. PJB_ERRORS. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. project_id = prb. The PJC_PRJ_REQ_DIST_V view displays attributes such as requisition number, item description, and vendor name. project_id = ptv. pjc_project_id project_id, crt. It also includes some PO data and project data as well. Please help. expenditure_item_id = pec. Value will be RCV. Query to Find Projects Not Accruing Revenue in Oracle Fusion --*-- SELECT PE. linked_task_id. Previous Next JavaScript must be enabled to correctly display this content . sql file in patch 13833481. approved_flag. Simply search with the table name in google, you’ll get complete details about the table and columns in it. Oracle Projects creates expenditure groups for supplier invoices transferred from Oracle Payables. Goal. Oracle Projects provides all system linkages upon installation. 1. It covers various topics such as grants, billing, collaboration, control, costing, foundation, performance, resource and reporting. which GL accounts will be hit by the system. pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. Title and Copyright Information; Get Help; 1 Overview. In the process of understanding the fixed assets tables, I have prepared few queries to fetch the different asset data from FA. Change the transaction source or original system reference of the expenditure item to be imported. ProjectsAtrbs. Cloud. reversing_line_flag. person_type person_type, expenditureitempeo. expenditure_item_id = RevDist. period_name PERIOD_NAME. NAME ei_prvdr_org_name, hr1. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. INVENTORY_ITEM_ID. AR Transactions and Tax Query - India Localization. TRANSACTION_NUMBER. carrying_out_organization_id AND hou1. acct_event_id. source_prvdr_gl_date. ERROR_ID. line_num_reversed. /* 1. Value will be RCV. An invoice can have multiple distributions. AR Transactions and Tax Query - India Localization. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. PA_EXPENDITURE_GROUPS_ALL stores groups or batches of pre-approved expenditures entered by a user. There can be only one record for the combination of Supplier and the invoice number. override_. It can be B (burdened) or R (raw) Offset method. LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. Cost distribution. source_id_int_1 = cdl. Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. line_number. Now we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table. 23B. 0 version, Manage Project Costs. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. FROM PJC_EXP_ITEMS_ALL PEI WHERE PEI. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. WHERE EXP. attribute_number7 Pjc_Work_Type,. expenditure_item_id. . Index Uniqueness Tablespace Columns; PJC_ACCT_SWEEPER_LOGS_N2: Non Unique: Default: PJS_SUMMARY_ID: PJC_ACCT_SWEEPER_LOGS_N3: Non Unique: Default: PROJECT_ID: PJC_ACCT_SWEEPER_LOGS_U1:The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. Index Uniqueness Tablespace Columns; PJC_TXN_UPGRADE_TEMP_U1: Unique: Default: PK1_ID: This table is used in work type upgrade process as temporary table . Transaction controls are used to control what expenditure items can be charged to a particular project or task, and whether the items are non-billable. TO_CHAR (acct_period_date, 'DD-MON-YYYY') expenditur_item_date FROM (SELECT v36738276. Cost associated with each expenditure type is excluded from the capitalized interest calculation. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. expenditure_item_id. expenditure_item_date) ei_expenditure_item_date, peia. 11. TRANSACTION_NUMBER. task_id(+) AND pei. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. pei. CATEGORY_ID ITEM_CATEGORY. For any update on columns other than the system populated columns, two records are created in this table. 23B. . Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. project_id AND pei. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Tablespace: APPS_TS_TX_DATA. AND TSRC. In my recent project, I have asked to write an outbound interface from Oracle Apps Fixed Assets R12 module to external legacy systems. A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter. State 2. Tables and Views for Project Management. PJC_ALLOC_RULES_ALL: pjf_exp_types_b: OFFSET_EXP_TYPE_ID: PJC_ALLOC_RULES_ALL: pjf_projects_all_b: OFFSET_PROJECT_ID: PJC_ALLOC_RULES_ALL: pjf_proj_elements_b:. PJC: Complete Flow Loading Data Using Import Project Miscellaneous Costs FBDI (Doc ID 2224954. line_type. NAME AS expenditure_bu, v515220161. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. Asset Number 5. This query will show all the distributions that post from project invoices to GL. Project Contracts Profile Options →. cost_book_id, ct. PJC_ORGANIZATION_ID 1. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. source_pa_period_name. INVENTORY_ITEM_ID. cdl. expenditure_item_id = pei. expenditure_item_id(+)name; source_bu_id. All, Can anyone provide me a table level link to the Oracle iExpenses tables, AP_EXP*REPORT* tables and the AP_INVOICES/AP_INV. Cloud Applications. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. We would like to show you a description here but the site won’t allow us. Who column: indicates the date and time of the creation of the row. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Object type: TABLE. R11i: PA: PAXTRAPE Incorrect Proj And Projfunc Burdened Cost (Doc ID 1543566. expenditure_item_id = pei. Schema: FUSION. AND imp. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. cmr_rcv_transaction_id = crt. They use stored queries that derive data from the tables on which the views are based. Tables for the Sales Contracts in Oracle fusion. Task Number 4. Schema: FUSION. expenditure_type_id. original_dist_id FROM pjc_exp_items_all expenditureitempeo) v457612106, pjc_cost_dist_lines_all pcdl,. task_id = ptv. SELECT. Version (include the version you are using, if applicable):PA_TRANSACTION_CONTROLS stores the transaction controls defined for projects or tasks. The attributes columns in PJC_EXP_ITEMS_ALL for my new transactions are also nullPJC_EXP_GROUPS_ALL. expenditure_item_id = cdl. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Project Name 2. AND POL. ** COST_IND_RATE_SCH_ID:. There is a invoiced_flag and ic_invoiced_flag(Invoiced flag for Inter company project) in the PJC_EXP_ITEMS_ALL table but I need the External Invoice Status. project_currency_code ei_project_currency_code, hr. Object owner: PJC. Tables for the Items in Oracle fusion. invoice_id AND aid. VARCHAR2. The relationships between Expenditure Types and System Linkages. Base Table: PJC_EXP_ITEMS_ALL Import Process: Import Costs STEP 1: Download FBDI template from oracle website. Next Page. expenditure_item_id), 'OPEN') CINT_CDL_STATUS, gps. 18. PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. . I want to get the. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). NUMBER. NAME AS expenditure_org, v55152034. ei_revenue_distributed_flag, x. source_attribute2Goal. organization_id =ACTUAL BEHAVIOR. PJF_TASKS_V. pjc_exp_items_all pei,. ,pjc_exp_items_all PEI ,pjf_projects_all_vl PPA ,pjf_tasks_v PT ,okc_k_headers_all_b OKH ,okc_k_lines_b OKL ,pjf_txn_sources_vl PTS ,hr_operating_units HOU ,pjf_exp_types_vl PET ,pjf_exp_categories_vl PEC ,per_person_names_f PPN ,per_all_people_f PPF ,poz_suppliers_v PS. pjc_expenditure_item_date expenditure_item_date, crt. Tablespace: FUSION_TS_TX_DATA. task_id = pei. NAME project_owning_org, CASE WHEN. 18. TRANSACTION_SOURCE = 'OSCM'. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. invoice_id = aid. Who column: indicates the date and time of the creation of the row. FROM pjc_exp_items_all EXP , pjf_proj_elements_b pt , pjf_projects_all_b pp , pjf_exp_types_vl et , pjf_system_linkages_vl syslink, pjf_exp_categories_vl exp_cat, PJF_NON_LABOR_RES_VL non_lab_res, PJF_TXN_SOURCES_VL TXN_SRC, pjf_txn_document_vl TXN_DOC, PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY, HR_ALL_ORGANIZATION_UNITS_VL HR_ORG. You can configure transaction controls by employee, expenditure category, expenditure type, and non-labor. PJC_TXN_UPGRADE_TEMP: pjc_exp_items_all: PK1_ID: Indexes. 10. task_id(+) AND pei. project_id AND ptv. Joining these tables, there are rows with opposite capitalizable_fl… Accepted answerlooking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. org_id employee_cost_org_id, pcdl. | Data Managementexpenditure_item_id source_exp_item_id, line_num source_line_num, expenditure_item_date source_exp_item_date, burden_cost source_burden_cost, denom_burdened_cost source_denom_burdened_cost, acct_burdened_cost source_acct_burdened_cost, project_burdened_cost source_project_burdened_cost,. 1. FROM pjc_cost_dist_lines_all pcdl, pjc_exp_items_all pei, pjf_tasks_v ptv, pjf_projects_all_b prb, pjf_projects_all_tl prl, pjc_exp_comments pec1, pjf_exp_types_vl pet,. pjc_exp_items_all expeo, pjf_projects_all_vl prj, pjf_proj_elements_vl trn_tsk, RA_CUSTOMER_TRX_all RCTA, RA_CUST_TRX_TYPES_ALL RACTL, PER_PERSON_NAMES_F_V PersonNameDPEO, PER_ALL_ASSIGNMENTS_M PAAM, PER_PERSON_TYPES_vl PPTL. project_id AND ptv. WHERE EXP. segment1 project_number, NVL ((SELECT pt. entered_currency_codeIt can be R (raw) or B (burdened) Cost type of offset transactions. transaction. TRANSFERRED_FROM_EXP_ITEM_ID: NUMBER (15) The identifier of the expenditure item from which this expenditure item originated. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Tables and Views for Project Management. If the task is a top task, the top_task_id is set to its own task_id. Fusion HCM - Query for Personal Payment Method Details. 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. PJC_ACCT_SWEEPER_LOGS: pjc_exp_items_all: EXPENDITURE_ITEM_ID: Indexes. name; event_id. , revdist. person_number AS employee_number,. PO_LINE_ID = EXP. 5. accounting_period AS GL_PERIODNow we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table. TARGET_EXP_TYPE_ID: PJC_ALLOC_RULES_ALL: pjf_rbs_headers_b: ALLOC_RBS_HEADER_ID: PJC_ALLOC_RULES_ALL: pjf_system_linkages: OFFSET_EXP_TYPE_CLASS:. Views are logical representations of a single or combination of tables. AS (SELECT DISTINCT GL. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. 2. (Includes access to deeplinks for viewing project cost transaction, project overview, project plan pages) When you create a custom job role to provide self-service reporting access, make sure you add the correct. expenditure_item_id.