txt - Free download as Text File (. This information will be interfaced to Oracle General Ledger from Oracle Projects. NUMBER. SELECT EXP. Who column: indicates the user who created the row. organization_id = ppat. event_id. tm_rep_atrb_id Pjc_Exp_Time_Repos_Atrb_id, PjcExpAtrbs. expenditure_item_id = pec. system_linkage_function /* 30623237 (SELECT exp. 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. Title and Copyright Information; Get Help; 1 Overview. project_id, ppa. AND TSRC. Fusion HCM - Query for Personal Payment Method Details. Project Name 2. document_id = ei. TRANSACTION_SOURCE = 'OSCM'. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. 0 and later Information in this document applies to any platform. PJC_TXN_UPGRADE_TEMP: pjc_exp_items_all: PK1_ID: Indexes. The number of line items AP_INVOICE_LINES_ALL and Distribution AP_INVIOCE_DISTRIBUTIONS_ALL do not. GL Account analysis for PA Expenditure */. 18. cmr_rcv_transaction_id = crt. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. full_name AS employee_name,. /*2. expenditure_item_id = pec. Now it is showing Project Cost transaction reference for all expense types except "Itemized Expense". PJC_CINT_EXP_TYP_ECL_ALL; PJC_CINT_EXP_TYP_ECL_ALL. name; event_id. Tables and Views for Project Management. All, Can anyone provide me a table level link to the Oracle iExpenses tables, AP_EXP*REPORT* tables and the AP_INVOICES/AP_INV. invoice_num as "Invoice Number" , replace ( replace ( aida . Simply search with the table name in google, you’ll get complete details about the table and columns in it. Source Line Description 7. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. E means Encumbrance entry. Oracle Projects provides all system linkages upon installation. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). 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 . 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. AR Transactions and Tax Query - India Localization. (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. Tables for the Sales Contracts in Oracle fusion. . project_id = ptv. PJC_ACCT_SWEEPER_LOGS: pjc_exp_items_all: EXPENDITURE_ITEM_ID: Indexes. AS (SELECT DISTINCT GL. ct. 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. INVENTORY_ITEM_ID. Who column: indicates the date and time of the creation of the row. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. 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. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. This table is used to store the errors that could ocurr in various processes in project billing. NUMBER. project_id AND pei. TRANSFERRED_FROM_EXP_ITEM_ID. Comment - Asset Source Line I need above fields will be in the fixed asset module 1. 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. 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:. org_id employee_cost_org_id, pcdl. 11. 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. pjc_capital_events Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. project_id. WHERE(invoiceheadereo. They would like to replicate this for custom reporting. Unique. expenditure_item_id. AND doc. pjc_exp_items_all pei. This report will display all project unbilled details. Our support team constitutes of highly skilled & trained technicians who have years of experience in handling technical defects. name AS Ledger_name, GJS. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. 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. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil,. project_id = prb. Schema: FUSION. 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. Tablespace: APPS_TS_TX_DATA. project_id AND pei. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. Tables for the AP Invoice in Oracle fusion. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. pjc_task_id task_id, crt. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields. Task Description 5. AP_Invoices_All has the unique key on invoice_id. . Version (include the version you are using, if applicable):PA_TRANSACTION_CONTROLS stores the transaction controls defined for projects or tasks. On : 11. TRANSACTION_SOURCE_ID. task_id = pei. source_pa_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. 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. ---------------. AND ppa. 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. full_name AS employee_name, v55152034. Previous Next JavaScript must be enabled to correctly display this content . 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:. project_id = prl. For third party integrations, the customer may interface the name or the identifier. Cost associated with each expenditure type is excluded from the capitalized interest calculation. API Create a valid category set. source_attribute2Goal. description , chr (. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. r_company, x. source_project_id. 10. SQL_Statement; SELECT. pjc_exp_items_all pei, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp,. The relationships between Expenditure Types and System Linkages. contract_type_id. 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 . ei_project_numbe. This causes some records to exist with NULL values in the DOCUMENT_DISTRIBUTION_ID in the PA_EXPENDITURE_ITEMS_ALL table. AND POL. NAME AS expenditure_org, v55152034. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). Oracle Projects creates expenditure groups for supplier invoices transferred from Oracle Payables. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. 90; ADJUSTED_EXPENDITURE_ITEM_ID: 1993042; Project: 4056; For Item ID 1993042: Created: 14/02/2020 14:04:46; Quantity: 110. 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. 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. PJC_PROJECT_ID = ppat. 1. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. STEP 2: Populate the data both PJC_TXN_XFACE_STAGE_ALL sheet of template as shown below. 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. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. PJC_CC_DIST_LINES_ALL. system_linkage_function /* 30623237 (SELECT exp. Details. Object owner: PJC. Title and Copyright Information; Get Help; 1 Overview. project_id AND pei. Purpose of this report is to derive all projects expenditure and event details with cost information. 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,. period_name PERIOD_NAME. Object type: TABLE. Next Page. 1. ← Configurator Concurrent Programs. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. PJF_TASKS_V. Object type: TABLETO_CHAR (acct_period_date, 'DD-MON-YYYY') expenditur_item_date FROM (SELECT v36738276. PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. pei. Views are logical representations of a single or combination of tables. This guide contains information about tables within. Also PO_DISTRIBUTIONS_ALL is the table which in my experience connects Purchase. CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. Who column: indicates the date and time of the creation of the row. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. system_linkage_function /* 30623237 (SELECT exp. operating_unit_name, a. Query to Find Projects Not Accruing Revenue in Oracle Fusion --*-- SELECT PE. Object owner: PJC. User-defined number that uniquely identifies the element within a project or structure. 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,. cmr_rcv_transaction_id. override_. Oracle ERP/ FSCM. Value will be RCV. task_id. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. invoice_id = ail. BATCH_STATUS: VARCHAR2: 1: Status of the batch. ei_revenue_distributed_flag, x. Examples of when your Oracle Payables application automatically creates rows in this table include. AND imp. pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. Applies to: Oracle Project Costing - Version 11. denom_currency_code. 50. I want to get the. Tablespace: FUSION_TS_TX_DATA. The inventory item associated with the incurred cost. It can be B (burdened) or R (raw) Offset method. pjc_expenditure_type_id = pet. 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. WHERE ei. task_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. This web page provides a list of tables and views for Oracle Fusion Cloud Project Management, a cloud-based application for project portfolio management. Simply search with the table name in google, you’ll get complete details about the table and columns in it. AND imp. It also includes some PO data and project data as well. cdl_line_number. project_id AND pei. AND crt. Project Portfolio. project_id, expenditureitempeo. PO Number I need above. 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. 2. If the task is a top task, the top_task_id is set to its own task_id. 1. DENORM_TOP_ELEMENT_ID. Object owner: PJS. task_id = ptv. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. 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. expenditure_item_id AS expenditure_item_id,. project_id = pei. project_id AND hou. transaction. person_type person_type, expenditureitempeo. 18. 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:. Contents. TRANSACTION_IDIt is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. 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. line_number AND ail. . A distribution must be associated with an invoice. contract_line_id. project_currency_code ei_project_currency_code, hr. event_id = cdl. Asset Cost 6. project_id = pei. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. 0 version, Manage Project Costs. creation_date5 AS acct_period_date, v103611946. PJC_TRANSACTION_CONTROLS. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. ei_project_name, x. Value will be RCV. Object type: TABLE. 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. task_id(+) AND pei. 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:. Check if the inventory item is valid. Goal. cost_book_id, ct. Object type: TABLE. task_id = ptv. line_number. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. . original_dist_id FROM pjc_exp_items_all expenditureitempeo) v457612106, pjc_cost_dist_lines_all pcdl,. It doesn’t matter how complex the issues would be. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. , revdist. invoice_date. These expenditure groups have a status of 'RECEIVED'. attribute_number7 Pjc_Work_Type,. SELECT pcdl. 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. NUMBER. Extract for Payments - Check and EFT. Please help. prvdr_pa_period_name, NVL (pei. Cost distribution. carrying_out_organization_id AND hou1. Object owner: PJC. . CATEGORY_ID ITEM_CATEGORY. Value will be RCV. 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. NAME project_owning_org, CASE WHEN. distribution_line_number. 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. A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. This table is used to store the errors that could ocurr in various processes in project billing. 1. vendor_name. expenditure_item_id. AND ppald. pjc_organization_id. Simply search with the table name in google, you’ll get complete details about the table and columns in it. TRANSACTION_NUMBER. We would like to show you a description here but the site won’t allow us. NAME ei_expenditure_org_name, op. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. ERROR_ID. quantity. Unit Number 4. pjc_project_id project_id, crt. pdf) or read online for free. 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_EXP_ITEMS_ALL ei, GET_PERIOD_AVG_RATE gpavg WHERE aia. Joining these tables, there are rows with opposite capitalizable_flag in two tables. There is one row for each invoice distribution. organization_id = aid. WHERE ei. PJB_ERRORS_U1. For any update on columns other than the system populated columns, two records are created in this table. 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. 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. rev_distribution_id. Version (include the version you are using, if applicable):This table contains non-persistent data and is used to expose summary data to Essbase. This number is incremented every time that the row is updated. line_num_reversed. Goal. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. 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 **. NAME AS expenditure_org, v55152034. 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 Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 50. SELECT ppa. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. 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. /* 1. It covers various topics such as grants, billing, collaboration, control, costing, foundation, performance, resource and reporting. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. ProjectsAtrbs. inventory_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. PJC_PRJ_PO_DIST_V. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. project. project_id(+) AND pei. 11. 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. AND imp. Stores expenditure type exclusions by interest rate code for each operating unit. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. expenditure_item_id, expenditureitempeo. To get the. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. R11i: PA: PAXTRAPE Incorrect Proj And Projfunc Burdened Cost (Doc ID 1543566. person_number AS employee_number,. entered_currency_codeIt can be R (raw) or B (burdened) Cost type of offset transactions. Change the transaction source or original system reference of the expenditure item to be imported. PJC_ORGANIZATION_ID 1. Project Management. Contents. line_number. 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. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. posted_flag. organization_id =ACTUAL BEHAVIOR. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. Required fields are marked. TRANSFERRED_FROM_EXP_ITEM_ID: NUMBER (15) The identifier of the expenditure item from which this expenditure item originated. Projects Self Service Reporting Duty. project_id AND ptv. Schema: FUSION. usages_source_version. gl_date. WHERE pcdl. agreement_type, a. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. usages_source_id, PjcExpAtrbsUsg. I can see on PJC_EXP_ITEMS_ALL that there is: Item ID 1993045 Created: 14/02/2020 14:06:31; Quantity: -110. INVENTORY_ITEM_ID. NUMBER. linked_project_id. Details. 23B. This query will show all the distributions that post from project invoices to GL. project_type_id = ppt. (EMP_MAND_FOR_. There can be only one record for the combination of Supplier and the invoice number. They use stored queries that derive data from the tables on which the views are based. source_org_id. 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. Regards, Zahid Rahim. 50. 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. sql file in patch 13833481. source_id_int_1 = cdl. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). In my recent project, I have asked to write an outbound interface from Oracle Apps Fixed Assets R12 module to external legacy systems. TRANSACTION_SOURCE_ID = TSRC. (SELECT expenditureitempeo. expenditure_item_id. WHERE pcdl. Project Foundation, Project Costing, Project Billing, Project Control. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice. Select aia . attribute_category Pjc_Expenditure_Type, PjcExpAtrbsUsg. § Ensure that all issues, receipts, and adjustments have been entered and verify that no hard copy records exist or are awaiting data entry. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. Applies to: Oracle Fusion Project Costing Cloud Service - Version 11.