cdl_line_number. 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. task_id = ptv. 23B. Title and Copyright Information; Get Help; 1 Overview. line_number. It can be B (burdened) or R (raw) Offset method. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and corresponding id). SQL_Statement. pdf) or read online for free. 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). Object owner: PJC. This web page provides a list of tables and views for Oracle Fusion Cloud Project Management, a cloud-based application for project portfolio management. AND ct. source_pa_date. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. name AS Ledger_name, GJS. NUMBER. project_id. AND TSRC. hr_all_organization_units_tl trx_org, pjb_rev_distributions prd, per_person_names_f ppn, per_all_people_f papf WHERE 1 = 1 AND pei. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. 23B. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. linked_task_id. An invoice can have multiple distributions. Cloud Applications. inventory_item_id}. INVENTORY_ITEM_ID. 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. NAME AS expenditure_bu, v515220161. 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. Source Line Description 7. crt. source_id_int_1 = cdl. 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:. CATEGORY_ID ITEM_CATEGORY. 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 . project_id = prl. This query will show all the distributions that post from project invoices to GL. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. contract_line_id. Result: So if you pass ExpenditureItemId, ExternalBillRateSourceName values to REST service, it’ll update the attribute ‘EXT_OVRD_BILL_RATE_SOURCE_NAME’ with the value coming from ‘ExternalBillRateSourceName’ for the already exist record with given ExpenditureItemId. Previous Next JavaScript must be enabled to correctly display this content . ---------------. There is one row for each invoice distribution. How can we derive the segments in Payables, Purchasing and Expense using the Project Costing? Qn2:Please confirm that the distribution set be defaulted when I setup SLA even for Project Costing?-- Core processing tbale PJC_TXN_XFACE_ALL will be populated with all required ID columns after performing mapping of name to ID -- This control file can accept six different types of trasactions (Labor, Non Labor, Misc, Inventory, Supplier Invoices, Expenses) -- For each of above type, sequence of columns in CSV is defined as per following order. inventory_item_id, NULL resource_id,I have configured the following DFF: 'Project Expenditure Item' It did not import any data to the IE's: I have then tried to configure these DFF's: 'Project Unprocessed Expenditure Item' Imported new transactions, but still no DFF values. PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. project_name,Possible values A - successfully interfaced to projects, P-interfaced to projects and waiting for projects' cost processing, R- rejected, F- failed to interface. full_name AS employee_name, v55152034. Any idea in which table this can be found or any query to achieve this. Oracle Projects creates expenditure groups for supplier invoices transferred from Oracle Payables. project_id, expenditureitempeo. We want to derive the Accounting Code Combination based on Expenditure Types. 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,. pjc_organization_id. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. § Ensure that all issues, receipts, and adjustments have been entered and verify that no hard copy records exist or are awaiting data entry. After upgrading from 11i to 12. PJF_EXP_TYPES_VL. approved_flag. Stores expenditure type exclusions by interest rate code for each operating unit. line_number AND ail. Flag that indicates whether the work type is billable or capitalizable. 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. source_id_int_1 = cdl. source_task_id. They use stored queries that derive data from the tables on which the views are based. pjc_exp_items_all pei, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp,. 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. Version 21BSo let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). AND hou. However, the IDs in PJC_EXP_ITEMS_ALL columns don't match any IDs in the HXT tables. invoice_date. FROM PJC_EXP_ITEMS_ALL PEI WHERE PEI. Project Management. It covers various topics such as grants, billing, collaboration, control, costing, foundation, performance, resource and reporting. API Create a valid category set. zip file in local system using “Generate CSV File” option. Title and Copyright Information; Get Help; 1 Overview. Required fields are marked. carrying_out_organization_id AND hou1. task_id = pei. AND imp. 5. It can be N (none) , A (source project and task), B (source project, use client extension for task), C (specific project and task) or D (use client extension for project and task) Allocation run status. NAME project_owning_org, CASE WHEN. expenditure_item_id = RevDist. Who column: indicates the date and time of the creation of the row. Value will be RCV. project_id, ppa. pjc_task_id task_id, crt. expenditure_item_id = pei. These expenditure groups have a status of 'RECEIVED'. invoice_id AND aid. All Revenue Management. Cost associated with each expenditure type is excluded from the capitalized interest calculation. Query. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. Applies to: Oracle Project Costing - Version 11. which GL accounts will be hit by the system. val_unit_id, ct. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. NUMBER. /*2. AP_INVOICES_ALL is the parent table of AP_INVOICE_LINES_ALL table which is used to store the Invoice Line Details. It also includes some PO data and project data as well. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. ,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. It doesn’t matter how complex the issues would be. task_id(+) AND pei. 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 **. PJC_TRANSACTION_CONTROLS. 18. This report will display all project unbilled details. event_id. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Base Table: PJC_EXP_ITEMS_ALL Import Process: Import Costs STEP 1: Download FBDI template from oracle website. Details. Tables and Views for Project Management. Simply search with the table name in google, you’ll get complete details about the table and columns in it. User-defined number that uniquely identifies the element within a project or structure. 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. select a. AND imp. Date Placed in Service 8. Goal. ProjectsAtrbs. expenditure_item_id(+)PA_SYSTEM_LINKAGES stores system-defined categories used to determine how items should be processed. Project Portfolio. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. inventory_item_id}. contract_id =. document_id = ei. Tables for the AP Invoice in Oracle fusion. system_linkage_function /* 30623237 (SELECT exp. 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:. GL Account analysis for PA Expenditure */. WHERE ei. Who column: indicates the user who created the row. revenue_category. project_id AND pei. cmr_rcv_transaction_id. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. AND imp. system_linkage_function /* 30623237 (SELECT exp. Examples of when your Oracle Payables application automatically creates rows in this table include. AND ppald. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Here is a table that lists the foreign keys of the ORIGINAL_HEADER_ID, ORIGINAL_DIST_ID, and ORIGINAL_LINE_NUMBER fields in the PJC_EXPENDITURE_ITEMS_ALL table in some of the most commonly-used transaction sources and documents. NAME ei_prvdr_org_name, hr1. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. INVENTORY_ITEM_ID. Version (include the version you are using, if applicable):PA_TRANSACTION_CONTROLS stores the transaction controls defined for projects or tasks. 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:. cost_org_id, ct. organization_id = aid. TRANSACTION_SOURCE_ID. WHERE ei. pjc_expenditure_item_date expenditure_item_date, crt. DENORM_TOP_ELEMENT_ID. Project Name 2. TRANSFERRED_FROM_EXP_ITEM_ID. This number is incremented every time that the row is updated. project_type_id. Who column: indicates the user who created the row. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. project_id AND ptv. Details. This table is used to store the errors that could ocurr in various processes in project billing. ei_latest_gl_period_name, x. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. 18. project_id = pei. AND ppa. creation_date5 AS acct_period_date, v103611946. To get the. ct. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Relationship between AP invoice line items and Distributions. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. expenditure_item_id = cdl. Cloud. project_id AND hou. name; event_id. Schema: FUSION. 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. 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. There can be only one record for the combination of Supplier and the invoice number. attribute_number4 Pjc_Project_Unit, ProjectsAtrbs. 1) Last updated on JULY 25, 2023. transaction_id, 'CST_TRANSACTIONS' source_table, ct. The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. PJC_CC_DIST_LINES_ALL. invoice_id AND aid. expenditure_item_id(+)name; source_bu_id. org_id employee_cost_org_id, pcdl. name; invoice_number. Previous Page. line_type. usages_source_version. TRANSACTION_IDIt is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Goal. 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. 2. STEP 3: Generate PjcTxnXfaceStageAll_misc. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. project_id = ptv. expenditure_type_id. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. TRUNC (peia. distribution_line_number. invoice_id = ail. expenditure_item_id. expenditure_item_id), 'OPEN') CINT_CDL_STATUS, gps. rev_distribution_id. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 50. expenditure_item_id AS expenditure_item_id,. PJC_ACCT_SWEEPER_LOGS: pjc_exp_items_all: EXPENDITURE_ITEM_ID: Indexes. line_num_reversed. Please help. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. project_id = prb. expenditure_item_id = pec. E means Encumbrance entry. PJC_TXN_UPGRADE_TEMP: pjc_exp_items_all: PK1_ID: Indexes. (EMP_MAND_FOR_. Extract for Payments - Check and EFT. 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. person_type person_type, expenditureitempeo. NAME AS expenditure_org, v55152034. ** COST_IND_RATE_SCH_ID:. transaction. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. AND doc. UNION ALL. Legal Entity 3. Details. Views are logical representations of a single or combination of tables. . NAME ei_expenditure_org_name, op. PJF_TASKS_V. Tables for the Items in Oracle fusion. project_id AND pei. r_company, x. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil,. original_dist_id FROM pjc_exp_items_all expenditureitempeo) v457612106, pjc_cost_dist_lines_all pcdl,. 3 there are some records with data corruption as reported in the r13833481. Joining these tables, there are rows with opposite capitalizable_flag in two tables. NAME AS expenditure_org, v55152034. 50. 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. pjc_exp_items_all: pjf_proj_elements_b: TASK_ID: pjf_proj_elements_b: pjf_proj_elements_b: PARENT_STRUCTURE_ID:. 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. Details. project_organization_name, a. 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. Unit Number 4. (SELECT expenditureitempeo. 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. TRANSACTION_SOURCE_ID = TSRC. PJC_PRJ_PO_DIST_V. pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. Purpose of this report is to derive all projects expenditure and event details with cost information. Next Page. PREDEFINED_FLAG = 'Y'. BATCH_STATUS: VARCHAR2: 1: Status of the batch. 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 . Oracle Projects provides all system linkages upon installation. The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. pjc_exp_items_all pei,. The before_after_flag will specify whether the record has pre-update or post-update values. gl_date. expenditure_item_id = pec. AND crt. This guide contains information about tables within. acct_event_id. This table is used to store the errors that could ocurr in various processes in project billing. Fusion HCM - Query for Personal Payment Method Details. /* 1. AR Transactions and Tax Query - India Localization. Tablespace: FUSION_TS_TX_DATA. FROM hwm_tm_rep_atrbs PjcExpAtrbs, hwm_tm_rep_atrb_usages PjcExpAtrbsUsg, HWM_TM_ATRB_FLDS_B PjcExpAtrbFlds. 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. transaction_source_id, expenditureitempeo. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. 1. PJB_ERRORS. CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 0 and later Information in this document applies to any platform. TRANSACTION_IDFROM pjc_exp_items_all peia, pjf_exp_types_vl pet, pjf_tasks_v ptv, pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, per_person_names_f ppn, pjb_rev_distributions prd, pjb. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. 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,. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. expenditure_item_id. 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. attribute_category Pjc_Expenditure_Type, PjcExpAtrbsUsg. 15. SQL_Statement; SELECT. VARCHAR2. SELECT. Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. We would like to show you a description here but the site won’t allow us. source_project_id. event_id = cdl. 0 version, Manage Project Costs. denom_amountPurpose of Report: For the Work Order Execution of the MP battery, the production operator prints the Name Plate Label which contains the description of the product, logo, Designation, Type of MP Battery, Battery Number, Tray Number, Serial Number, Date, Nominal Voltage, Capacity, Number of cells, Weight, Volume of Acid,. Next Page. PARENT_LINE_NUMBER. PJC_PROJECT_ID = ppat. Project Portfolio. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. 1. NAME AS expenditure_bu, v515220161. EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL. pjc_capital_events Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. 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. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. TRANSACTION_NUMBER. WHERE pcdl. Dear All, About Oracle Fusion Applications Cloud (Oracle's SaaS ERP) . In my recent project, I have asked to write an outbound interface from Oracle Apps Fixed Assets R12 module to external legacy systems. TRANSFERRED_FROM_EXP_ITEM_ID: NUMBER (15) The identifier of the expenditure item from which this expenditure item originated. Use it if possible to enhance the performance. invoice_id = aid. 14. SELECT x. quantity. Posts about Project Cost written by Pulkit jainhr_all_organization_units_tl trx_org, pjb_rev_distributions prd, per_person_names_f ppn, per_all_people_f papf WHERE 1 = 1 AND pei. inventory_item_id}. contract_id. period_name PERIOD_NAME. Tablespace: APPS_TS_TX_DATA. 0 version, Manage Project Costs-Allocate Project Costs. , revdist. SELECT ppa. ERROR_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. acct_event_id. 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. expenditure_item_id AND ptv. expenditure_item_id = cdl. description , chr (. Fusion Inventory Queries2. STEP 2: Populate the data both PJC_TXN_XFACE_STAGE_ALL sheet of template as shown below. system_linkage_function /* 30623237 (SELECT exp. project_id = ptv. PJC: Complete Flow Loading Data Using Import Project Miscellaneous Costs FBDI (Doc ID 2224954. txt - Free download as Text File (. Regards, Zahid Rahim. SELECT pcdl. State 2. 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. Oracle Applications P2P,O2C R2R, BI, Oracle Fusion Application, Oracle E Busines Suite, Oracle Financials, SLA, MPA, Functional, Technical,The system generated number that uniquely identifies the work type. Task Number 4. TRANSACTION_IDTable Foreign Table Foreign Key Column; PJC_PATI_ADJ_QUEUE: pjc_exp_items_all: EXPENDITURE_ITEM_IDIf 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. entered_currency_codeIt can be R (raw) or B (burdened) Cost type of offset transactions. override_. ← Configurator Concurrent Programs. Tables and Views for Project Management; PJC_LOOKUPSGL Account analysis for PA Expenditure & Event query. 1. attribute_category Pjc_Attribute_Category, ProjectsAtrbs. 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 has the unique key on invoice_id. Task Description 5.