PA. DENORM_WBS_LEVEL. Distribution identifier of the burden cost. source_line_id_2. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. An Equal Opportunity Institution. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. Report Description: Packing Slip report prints all the shipment information, usually packing slip. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. 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. ae_header_id. source_header_id_1. Feature Description Additional subject areas These subject areas have been added: • Project Budget provides the ability to report on cost, revenue, margin, and the changes to. source_header_id_2. in pjc_exp_items_all are the columns original_header_id, original_line_number, original_dist_id. Name of the pay element. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. description. Raw cost = (quantity * cost rate) This value should alwa. Hello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. COMMITMENT_TYPE. inventory_item_id,i. Column NameFlag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is supposed to have INVOICE_DISTRIBUTION_ID for Oracle Payables transactions. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. expenditure_type_id = pet. Index. AND ROWNUM<=1. Keyword Analysis & Research: pjc_cost_dist_lines_all in oracle fusionMetrics added for data validation. 1 Overview Project Portfolio Management Tables and Views 2 Grants Management Tables Views 3 Project Billing Tables Views 4 Project Collaboration Tables 5 Project Control. OKE_DEBUG_FILE_DIR. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. line_type in ('R', 'B') AND pcdl. 5. User-defined number that uniquely identifies the element within a project or structure. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. The borrowed and lent revenue distribution lines are. 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. VARCHAR2. pjc_organization_id. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. AND imp. Previous Next JavaScript must be enabled to correctly display this content . Object owner: CST. reserved_attribute1 reserved_attribute1, ei. From my research, it seems that the OTL. source_id_int_1 = cdl. Content (required): I am trying to write a query to find the project number that was used in a reclassification journal. See Reference for Oracle Fusion CX Analytics. The Transaction Costing process picks up inventory transactions from the TRANSACTION_INV record and calculates the costs of each transaction, including, material, conversion, conversion overhead, landed, inbound, outbound, and other costs. WHERE pcdl. ind_rate_sch_revision_id = irsr. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields 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. attribute6. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. this contains the line number of the corresponding cost distribution line: TP_JOB_ID:. 2400 Clarksville Street. project_id = ppa. The query uses the. event_id = ccdl. ae_line_num AND xda1. The Paris Junior College District. We want to derive the Accounting Code Combination based on Expenditure Types. Summary: Generate Burden Costs Query. ,d. tag. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. VARCHAR2. 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,. 2. denom_burdened_cost AS amount. Default. . source_line_id_4. GL_LEDGERS g, ap_invoices_all i, POZ_SUPPLIERS_V v, HR_ORGANIZATION_V o, PJF_EXPEND_TYP_SYS_LINKS es, PJF_EXP_TYPES_B et , PJF_TASKS_V t,. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. line_type in ('R', 'B') AND. On the course search page, select the term, select 'Undergraduate' for division, and then click the 'Search' button. expenditure_type_id = pet. NUMBER. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. **. 2. pjc_expenditure_type_id. 2. expenditure_item_id AND expenditureitempeo. 1. Oracle Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. I can see that the Categories in the project show the NGN exchange rate. Paris Junior College 2400 Clarksville St. 9. PA_PROJECT_ASSET_LINE_DETAILS stores information necessary to drill down from an asset line to the cost distribution lines that are summarized in the asset line. This table stores exceptions encountered during burden cost generation, planning resource breakdown structure element mapping for raw cost and burden cost, or burden cost account generation. To override the cost center in the account, enter a value. SELECT pcdl. An invoice can have multiple distributions. . AP_INVOICE_DISTRIBUTIONS. Oracle Apps R12 Sub ledger Accounting Tables and joins XLA Table joins GL_JE. AND imp. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. Currently I am using pjc_cost_dist_lines_all table in my quer… Accepted answer Ankit_Bhadja 11 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Aug 28, 2023 9:44AM Project ManagementTable to store Catalog of Federal Domestic Assistance values. 8. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. BALANCING_SEGMENT. Report: Packing Slip Report Report Short Code: WSHRDPAK Module: Oracle Shipping Report Navigation: Shipping super user responsibility -> Shipping -> Reports and Documents -> Select the report name as ‘Packing Slip Report’ -> Enter parameters. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil, pjb_invoice_headers pih, per_all_people_f ppf, per_person_names_f ppn, pjf_tasks_v pt, pjf_exp_types_vl pet, pjc_exp_comments pec WHERE 1 = 1 AND pei. September 25 / READ. For external third party import, this flag should be populated while interfacing the data into PATI. 9. Project Contracts Profile Options →. replace the project_id. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines. expenditure_item_id = pei. Advising and Counseling. . Office & Switchboard Hours (all locations) Monday - Friday: 8AM - 5PM Greenville Center Tel: (903) 454-9333 Sulphur Springs Center Tel: (903) 885-1232 Help & Support. meaning. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is. 3452 Spur 399 McKinney, TX 75069 (972) 881-5790. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. Solution The ACCT_EVENT_ID field in the PA_COST_DISTRIBUTION_LINES_ALL table is the simplest and most direct link between cost distribution lines in Projects (and thereby the source data in the SLA (XLA) tables. You can define a cost distribution override to redirect the costs and revenues generated by a specific employee or by all employees assigned to a specified organization. Paris, Texas 75460. acct_event_id. ref_ae_line_num = xda2. This column contains the identifier of. requestor_nameEnd date of the payroll period. Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. per_roles_dn 4. PA_MC_COST_DIST_LINES_ALL. prvdr_gl_period_name gl_period, trx_org. Please guide how to get the mentioned details with the current setup?There's nothing to suggest (in the question or in accounting principles) that negative amounts are forbidden. 0 and later Information in this document applies to any platform. 6. Content (required): The values in this field are RPBNN. LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. PROJECT_ID =P. 1. Goal. r_company, x. S. If the task is a top task, the top_task_id is set to its own task_id. PROFILE OPTION NAME. PJC_CONTRACT_LINE_ID: NUMBER: 18: DFF Column used by Standardized Project Cost Collection Widget: Active: PJC_FUNDING_ALLOCATION_ID:All: Closed: Capital data (asset line details) Capital: Closed: Actuals: - Cost distribution lines - Expenditure items and related tables - Cross charge transactions - Staffing transactions: All: Closed: Actuals: - Customer invoices - Revenue distribution lines: Contract: Closed: Actuals: - Cost distribution lines - Expenditure items and. Title and Copyright Information; Get Help; 1 Overview. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. Previous Page. This number is incremented every time that the row is updated. NUMBER. These subject areas with base metrics are added to the automated validations for base metrics between the Oracle Applications Cloud source and Oracle Fusion Analytics Warehouse : Sales Orders subject area with 6 base metrics. Oracle Fusion Project Costing - Version 11. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. Dec 23, 2021 12:06PM edited Dec 23, 2021 12:08PM 1 comment. source_line_id_1. Indicates if the application should derive the raw cost for the project cost transaction. expenditure_item_date expenditure_item_date2. Approve the PO 3. 7661 • Admissions: 903. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. ORDER BY D. Oracle Fusion ERP Analytics. project_unit, main. name AS Ledger_name, GJS. Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost. 0 and later: How does one purge the data from the Project Costing Interface table:. 4 miles. expenditure_item_id. For capital projects this flag is used as capitalizable_flag. pjc_capitalizable. Qn2:On : Customer is requesting a way to restrict specific expenditure types to. 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, gl_period_statuses gps, pjf_bu_impl_v imp. expenditure_type_id AND. The ACCT_EVENT_ID field in the PA_COST_DISTRIBUTION_LINES_ALL table is the simplest and most direct link between cost distribution lines in Projects (and thereby the source expenditure. 2021-2022 Catalog. User-defined number that uniquely identifies the element within a project or structure. Describes tables and views for Oracle Fusion Cloud Project Management. 0. pjc_expenditure_item_date. inventory_item_id,i. AMOUNT_VARIANCE:. lookup_code. Cost organization of the transaction for which the distribution is created. 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_ALL. 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,. 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_errors pe, xla_distribution_links xda, xla_ae_lines xal,. 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. 1) All accounting performed before transfer to the GL. ACCOUNTING_STATUS_CODE . This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. April 17 edited April 17. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 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. RAW_COST: NUMBER (22) ORG_ID: NUMBER (15) OUTPUT_VAT_TAX_ID: NUMBER: Default output tax code identifier for invoice line: OUTPUT_TAX_EXEMPT_FLAG: VARCHAR2 (1). COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. 1. For indirect projects this flag is set. approved_flag. project_id AND pbt. The ACCT_EVENT_ID field in the PA_COST_DISTRIBUTION_LINES_ALL table is the simplest and most direct link between cost distribution lines in Projects (and. release_revision. Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost = raw cost. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start 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. inventory_item_id,i. We have a requirement to derive only accounted project cost transactions by creating custom BIP report. ← Configurator Concurrent Programs. An invoice / invoice line can have. HTH. OKE_K_FIFO_LOG. AND imp. cc_dist_line_id(+) = ccdl. The parameters for the Transaction Costing process are defined on the Cost Accounting. 0 and later: PJC: Oracle Fusion Project Cost Account Reconciliation Report. Add to Compare. AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. The cost distrulibution table for the ccid fields are null. 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. When an asset line is initially created, this table contains one record for each cost distribution line summarized into the asset line. 2. Required fields are marked. 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. OLD_DIST_LINE_NUMBER: NUMBER: 18: Old invoice distribution line number. if you are looking to connect the AP invoice to any entity like PO/ Project etc, most probably this is your table like you can use PO_DISTRIBUTION_ID to. GL_LEDGERS g, ap_invoices_all i, POZ_SUPPLIERS_V v, HR_ORGANIZATION_V o, PJF_EXPEND_TYP_SYS_LINKS es, PJF_EXP_TYPES_B et , PJF_TASKS_V t,. The level of summarization in this table is controlled by the CIP Grouping Method for the project type, as well as by the level (task or. AP_DISTRIBUTION_SET_LINES_ALL contains detailed information about individual distribution lines you define for a Distribution Set. For multi–org schedules, we purge the schedule line that meets the purge criteria. meaning. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. 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. XLA_DISTRIBUTION_LINKS XDA, xla_ae_lines xal, hr_all_organization_units_tl trx_org, per_all_people_f_v papf, per_person_names_f ppn WHERE pcdl. DENORM_TOP_ELEMENT_ID. But i cant find any type join. Hi Please find the Columns and tables that we are using below SQL. PROJECT_ID. , rd. source_project_id. AND PRD. March 5, 2010 in Oracle Projects Contracts. ae_header_id = ael1. 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 pbt. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. This table stores exceptions encountered during burden cost generation, planning resource breakdown structure element mapping for raw cost and burden cost, or burden cost account generation. WHERE ei. 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,. calc_burden_status extn_calc_burden_status, cdl. and PROJECT_ID=. pjc_task_id. enabled_flag. But I am unable to find a column which will specify whether a cost transaction is accounted or not from the table pjc_cost_dist_lines_all. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. ind_rate_sch_revision_id = irsr. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. name; po_number. source_id_int_1 = ccdl. 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. R2. FROM. Founded In 1924. Previous Page. AND imp. How does the raw_cost_ccid on the pjc_cost_dist_lines_all table get populated? I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the GL, i get no resultsLedger, corresponding to the cost organization book, where the distribution should be recorded. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. If the task is a top task, the top_task_id is set to its own task_id. WHERE ics. There are more that 200 records in the table "PJC_COST_DIST_LINES_ALL" Content. EBS Tables —————————————– FUSION Tables PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. 10. je_source_name AS JE_SOURCE_NAME,It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. acct_event_id. PA_CUST_REV_DIST_LINES_ALL. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. Review the cost in the Project UI, it is not getting transferred to the Project. COST_BOOK_ID: NUMBER: 18: Cost book within the cost organization for which the distribution is created. 8. Then XLA_AE_LINES link to XLA_AE_HEADER where we can see. We link PJC_COST_DIST_LINES_ALL table to XLA_AE_LINES table through XLA_DISTRIBUTION_LINKS table. cc_dist_line_id(+) = ccdl. PJC: Oracle Fusion Project Cost Account Reconciliation Report (Doc ID 2121913. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. FROM pjc_exp_items_all pei, pjf_exp_types_tl pet, pjf_projects_all_b ppa, pjf_projects_all_tl ppt, pjf_project_statuses_tl pps, pjf_proj_elements_b ppeb, pjf_proj_elements_tl ppet, pjb_bill_trxs pbt, pjb_invoice_headers pih, pjb_invoice_lines pil, pjb_inv_line_dists pild, pjb_rev_distributions prd, pjc_xla_ccdl_lines_adj_v ccdl, hr_all. We would like to show you a description here but the site won’t allow us. source_task_id. A Junior College Owned & Operated By. 1. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. expenditure_item_id = expenditureitempeo. 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_task_id. tag. AND imp. 1. acct_event_id. 1) Last updated on MAY 27, 2022 Applies. ei_project_name, x. The table has no primary key. I then take the. event_id = ccdl. WHERE ( projectcostdistributionpeo. PA_DRAFT_REVENUES_ALL. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. LAST_UPDATE_DATE) EXP_CDL_LAST_UPDATED_DATE, cdl. Title and Copyright Information; Get Help; 1 Overview. PA_BILL_RATES_ALL: Information about bill rates and markups of standard bill rate schedules PA_BILLING_ASSIGNMENTS_ALL: Assignments of billing extensions to a project type, project, or task PA_COST_DISTRIBUTION_LINES_ALL: Information about expenditure item cost distribution PA_CUST_REV_DIST_LINES_ALL: Information. source_id_int_1 = ccdl. Re: Needs PA, CM, FA base tables [ message #189829 is a reply to message #189618] Mon, 28 August 2006 00:54. PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. This information will be interfaced to Oracle General Ledger from Oracle Projects. As every AP invoice Line can be made of multiple PO. dist_line_id_reversed. 1. sql_statement; select cre. It stores currency related information about project asset lines for each reporting set of books associated with the parent record on PJC_PRJ_ASSET_LNS_ALL. name AS Ledger_name, GJS. r. pjf_bu_impl_all: ORG_ID: pjc_cost_dist_lines_all: pjf_periods_all: PRVDR_PA_PERIOD_NAME, ORG_ID: pjc_cost_dist_lines_all: pjf_periods_all: RECVR_PA_PERIOD_NAME, ORG_ID: Indexes. 1) Last updated on FEBRUARY 21, 2021. We originally had our PRBS by Expenditure Category and Type. Applies to: Oracle Fusion Project Costing - Version 11. Applies to: Oracle Fusion Project. pa_cost_distribution_lines_all. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. 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_org_id. I used csv file as data source in Data Model. OKE: Debug File Directory. Symptoms. transaction_number. Tables and Views for Project Management. cc_dist_line_id(+) = ccdl. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. ref_ae_line_num IS NULL AND xda2. pjc_capitalizable. Yes. ind_rate_sch_revision_id = irsr. attribute3. 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,. req_line. 1) Last updated on NOVEMBER 08, 2022. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. ind_rate_sch_revision_idFROM pjc_cost_dist_lines_all cdl, pjc_exp_items_all ei, pjf_ind_compiled_sets ics, pjf_irs_revisions irsr, pjf_cost_base_exp_types cbet, pjf_compiled_multipliers cm, pjf_ind_cost_codes icc, pjf_txn_document_b td, pjf_p_periods_all_v p, pjf_ind_rate_sch_b irs. 0 version, Manage Project Costs. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. dist_line_id_reversed. Solution The ACCT_EVENT_ID field in the PA_COST_DISTRIBUTION_LINES_ALL table is the simplest and most direct link between cost distribution lines in Projects (and thereby. Active: TRANSFER_COST_DIST_ACCOUNT: NUMBER: 18: Transaction transfer cost distribution account: Active: WAYBILL_AIRBILL: VARCHAR2: 20:. VARCHAR2. xla_ae_lines xal, pjc_exp_items_all peiThis table contains non-persistent data and is used to expose summary data to Essbase. Posts about Project Cost written by Pulkit jain. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. 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. name; award_distribution_line_id. vendor_id. 12. project_type,SUM(nvl(main. 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. xla_ae_lines ael1, xla_distribution_links lnk1, gl_code_combinations gcc1 , pjc_cost_dist_lines_all pcd where lnk1. SOURCE_LINE_ID_2:. PJC_CONTRACT_LINE_ID: NUMBER: 18:. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. Create. ind_rate_sch_revision_id bre. Supply Chain Management. expenditure_item_id = expenditureitempeo. Used when Oracle Contract Billing or Oracle Grants Accounting is installed. AND imp. We would like to show you a description here but the site won’t allow us. Provision with single sign-on. pjc_expenditure_type_id. Solution The ACCT_EVENT_ID field in the PA_COST_DISTRIBUTION_LINES_ALL table is the simplest and most direct link between cost distribution lines in Projects (and thereby the source data in the SLA (XLA) tables. Used to implement optimistic locking.