2. sql_statement; select cre. Once all lines associated with a schedule are purged, the whole schedule is purged. ei_revenue_distributed_flag, x. transaction_id =. project_organization_name, a. 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_expenditure_type_id. PJC_CC_DIST_LINES_N1: Non Unique: Default: PROJECT_ID, TASK_ID: PJC_CC_DIST_LINES_N2:. 6 Most Important Tables Used By pa-sla-gl link query. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines. pjc_organization_id. Flag that indicates whether the work type is billable or capitalizable. COST_CENTER_SEGMENT. OKE: Debug File Directory. OKE: Debug Mode. 1. pjc_billable_flag. Contents. 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. sum of the items raw cost distribution lines. rounding_class_code = ‘RAW_COST_CLEARING’ AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. PA tables in fusionIf 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. In this Document. and PROJECT_ID=. capitalizable_flag = 'Y' 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, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct, xla_distribution. ae_line_num, xda2. 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_id_int_1 = ccdl. ind_rate_sch_revision_id = irsr. . SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. Intern kicks of oracle invoice number tables after a template. When you select a Distribution Set for an invoice, your Oracle Payables application uses this information to create invoice distribution. attribute5. 2. acct_event_id. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. Main: 903. source_header_id_1. ae_line_num AND xda1. pjc_task_id. 0 and later. pjc_capitalizable. WHERE ccdl_orig. 1. COST_BOOK_ID: NUMBER: 18: Yes: Cost book within the cost organization for which the distribution is created. 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. 9. Project Contracts Profile Options →. lookup_code. Approve the PO 3. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. this contains the line number of the corresponding cost distribution line: TP_JOB_ID:. 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. 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. expenditure_item_id. We would like to show you a description here but the site won’t allow us. We have a requirement to derive only accounted project cost transactions by creating custom BIP report. This is the transportation cost for transfer. attribute4. PA_MC_COST_DIST_LINES_ALL. The room and board residence hall cost for academic year 2023-2024 are:. PJC_AWARD_DISTRIBUTIONS interfaces the data with invocation business functions. F81674-01. Contents. 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. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. WHERE ccdl_orig. 03 USD we need to make the cost line non billable. award_distribution_batch_id. An invoice can have multiple distributions. 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. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. validation_status_code validation_status_code,. EBS Tables. Through testing we decided we just need one by expend…Subject: SQL query to get the Project Details, Contract Details, Invoice Details--SQL Query:--SELECT. 8) */CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). T. ind_rate_sch_revision_idbre. VARCHAR2. dist_denom_burdened_cost dist_denom_burdened_cost, l. . ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. Assignment ID related to the assignment record for this labor cost. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. DENORM_TOP_ELEMENT_ID. actual_amount, 0)) - SUM(nvl(main. recalculate the revenue for an expenditure item. BILLABLE_FLAG. WHERE ccdl_orig. 0 and later: How does one purge the data from the Project Costing Interface table:. I do not know how to link the dist line the the xla lines. expenditure_item_idAP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. xla_ae_lines ael1, xla_distribution_links lnk1, gl_code_combinations gcc1 , pjc_cost_dist_lines_all pcd where lnk1. 0 version, Manage Project Costs. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. approved_flag. A quick summary of accounting entries in Order to Cash cycle Sales order creation – No entries Pick release: Inventory St. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. ORDER BY D. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. pa_cost_distribution_lines_all. PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID/*Added for grants uptake*/ FROM. 0 and later Information in this document applies to any platform. t costs are also not populated. 1) Last updated on NOVEMBER 08, 2022. 8. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. I then take the. 8. Yes. 10. PJC_MC_PRJ_AST_LINES_ALL is an MRC sub table of PJC_PRJ_ASSET_LNS_ALL. main. To get the. Use it if possible to enhance the performance. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE ( projectcostdistributionpeo. expenditure_item_id = cdl. PA_CUST_REV_DIST_LINES_ALL does not reference any database object. 1. award_distribution_id. requestor_person_id. Supplier invoice expenditure items do not have a value for column SYSTEM_REFERENCE5 in table PA_COST_DISTRIBUTION_LINES_ALL which is. per_user_roles 3. document_type. Paris Junior College 2400 Clarksville St. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. items. pjc_cost_dist_lines_all Tables to get Project Plan and its Budget Amount. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. This information will be interfaced to Oracle General Ledger from Oracle Projects. 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. prvdr_gl_period_name gl_period, trx_org. xla_distribution_links. ref_ae_header_id =. 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. transaction_number. CANCELLATION_FLAG: VARCHAR2: 1: A value of Y indicates that the distribution line has been created during the Invoice Cancel. Goal FROM 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. For example, to search for online classes only, select 'Online' in. ra_customer_trx_lines_all. ind_rate_sch_revision_id = irsr. Then XLA_AE_LINES link to XLA_AE_HEADER where we can see. 2) adjusting revenue distribution lines are created when you. PJC_COST_DIST_LINES_ALL_N1: Non Unique: Default: PROJECT_ID: PJC_COST_DIST_LINES_ALL_N10: Non. 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. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. 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. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active: PJC_PROJECT_ID: NUMBER: 18:AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. Symptoms. PJC_CONTRACT_LINE_ID: NUMBER: 18:. expenditure_type_idProgram for Return to Vendor in Oracle purchasing (1) Program to create receipts for approved Purchase order (1) Project Accounting (1) Project Contract Table Links in Fusion (1) Project Cost query (1) Project Details query Fusion (1) Project Directory query in Fusion (1) Project invoice query in fusion (1)Yes. March 5, 2010 in Oracle Projects Contracts. dist_base_amount dist_base_amount, l. AND imp. COST_ORGANIZATION_ID: NUMBER: 18: Yes: Cost organization of the transaction for which the distribution is created. 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. Piper Sandler Completes 46th Semi-Annual Generation Z Survey of 9,193 U. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. This flag determines if Cross Charge processing is allowed or not. S. Oracle Fusion Project Costing Cloud Service - Version 11. release_revision. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. project_id AND pbt. line_type in ('R', 'B') AND. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. per_roles_dn 4. PROFILE OPTION NAME. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. expenditure_type_id = pet. The cost distrulibution table for the ccid fields are null. Cloud Applications. • All tables ending with the suffix _EN • All views listed in Tables Without WHO Columns. 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. 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, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct,. 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. I have tried linking xla_distribution_links with PJC_COST_DIST_LINES_ALL but I am not sure what to link to source_distribution_id_num_1 to get the right value. 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. ae_line_num AND xda1. You need one row for each distribution line for a Distribution Set. ind_rate_sch_revision_id = irsr. project_type,SUM(nvl(main. 9. Index Uniqueness Tablespace Columns; PJF_WORK_TYPES_B_N1:Object Details. 3452 Spur 399 McKinney, TX 75069 (972) 881-5790. List price fields, oracle ar tables in an item will not use these columns or process and line to the owner. In this Document. 1) Last updated on MAY 27, 2022 Applies. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. WHERE D. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. Information about the cost distribution of expenditure items for each reporting set of books. Assignment ID related to the assignment record for this labor cost. 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. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. source_line_id_4. Single column FK: Identifies the cost distribution header record. 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. pa_cust_rev_dist_lines_all. denom_burdened_cost AS amount. data_set_id data_set_id, ei. For capital projects this flag is used as capitalizable_flag. To override the cost center in the account, enter a value. Name of the pay element. award_distribution_status. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. Report Description: Packing Slip report prints all the shipment information, usually packing slip. expenditure_item_id = expenditureitempeo. pjc_task_id. FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei,. Transaction identifier of the burden cost. 6. project_unit, main. Schema: FUSION. per_users 2. The primary key on this table is:. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry. 2. source_id_int_1 = cdl. Fusion User Roles SQL Query & Tables. The Paris Junior College District. Ananth. 782. The issue can be reproduced at will with the following steps: 1. PJC_PRJ_ASSET_LNS_ALL. ,d. source_line_id_1. Item Costs CAC Intercompany Relationship Setup CAC Intercompany SO Price List CAC Intercompany SO Price List vs. 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. Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. trunc(cdl. Required fields are marked. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';-- note the project_id; 2. Without value the data in Project Accounting cannot be linked to Accounts Payable transactions. 12. 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. Anyway, if sum (amt) for credits is "10" and sum (amt) for debits is "-10", then -sum (amt) for debits will be "10". FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. 7. FROM. source_line_id_2. Oracle Application Wednesday, 28 December 2022PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. I can see that the Categories in the project show the NGN exchange rate. accounting_event_id) source_header_id_1, ' ' source_header_id_2, decode(cre. 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?Oracle Applications P2P,O2C R2R, BI, Oracle Fusion Application, Oracle E Busines Suite, Oracle Financials, SLA, MPA, Functional, Technical,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; source_bu_id. source_task_id. project_id = ppa. reserved_attribute1 reserved_attribute1, ei. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. ae_header_id = ael1. 1) All accounting performed before transfer to the GL. source_line_id_3. xla_ae_lines. 9. 23C. How much does Paris Junior College cost?. AND imp. 10. Oracle Fusion Cloud Project Management. 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_id_2PJC_PRJ_ASSET_LNS_ALL. AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. Active: TRANSFER_COST_DIST_ACCOUNT: NUMBER: 18: Transaction transfer cost distribution account: Active: WAYBILL_AIRBILL: VARCHAR2: 20:. 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) Run “Create Accounting” to populate accounting events (SLA) tables. Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. PJC_RESERVED_ATTRIBUTE1 FUNDING_SOURCE_ID/*Added for grants uptake*/, POD. SOURCE_LINE_ID_1:. attribute6. SELECT pcdl. 7661 • Admissions: 903. BALANCING_SEGMENT. award_distribution_status. ref_ae_line_num = xda2. CMT_NUMBER. This value for the project is a default for the task fixed date. PA. 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,. expenditure_item_id AND expenditureitempeo. 01. Report message to a moderator. PA_MC_COST_DIST_LINES_ALL is an MRC sub table of PA_COST_DISTRIBUTION_LINES_ALL. pjc_organization_id. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr'; -- note the project_id; 2. AP_INVOICE_LINES_ALL_ is the audit table for AP_INVOICE_LINES_ALL. 2. An. 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. event_type_code, 'retro. C for cost rate override and B for bill rate override. 4. Only While uploading the Accounted Project costing transactions with accounting entries, the CCID columns viz. 23C. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 11. When one transaction associated to 2 lines and the 2 lines associated to 2 different code combination, there are 4 lines return with my script. acct_event_id. Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. Indexes. 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,. We are unable to understand the difference between the contexts PJC: All and PJC: Expenditure Batch in the LOV of contexts in Project Standard Cost Collection Flexfield. Previous Page. WHERE ei. pjc_expenditure_item_date. INVOICE_TYPE_LOOKUP_CODE. 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. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. 1. Teens. CAC ICP PII Material Account Detail CAC ICP PII Material Account Summary CAC ICP PII WIP Material Usage Variance CAC ICP PII WIP Pending Cost Adjustment CAC ICP PII vs. WHERE pcdl. As every AP invoice Line can be made of multiple PO. WHERE ics. 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,. PJC : Cost shows in wrong currency Posted By months ago Hi, I have setup a project for Nigeria currency NGN. This column contains the identifier of. Uniqueness. Project Portfolio. name; po_number. cc_dist_line_id(+) = ccdl. A distribution must be associated with an invoice. Dear , I need to join my external transaction into accounting so i can check period name and account status. Posted by Manjesh's Fusion World at 2:42 AM No comments: Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest. end_date_active. 2021-2022 Catalog. VARCHAR2. The query uses the. The output should be Prepayment. 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). NUMBER. document_type. expenditure_item_id = pei. Oracle Fusion Query For Join Between Project, Project Cost Distribution And Gl Code Combination (Doc ID 2856441. The parameters for the Transaction Costing process are defined on the Cost Accounting. Status becomes Closed for receiving (due to receipt close tolerance = 100% @ PO line type setup) 4. 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. Cost distribution lines amount are implicitly debit amounts. If the task is a top task, the top_task_id is set to its own task_id. 18. The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost:. Oracle Apps R12 Sub ledger Accounting Tables and joins XLA Table joins GL_JE. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. 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. , rd. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. Summary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information.