Now it is showing Project Cost transaction reference for all expense types except "Itemized Expense". Simply search with the table name in google, you’ll get complete details about the table and columns in it. , revdist. FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. This information will be interfaced to Oracle General Ledger from Oracle Projects. STEP 3: Generate PjcTxnXfaceStageAll_misc. SELECT x. cdl. 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. source_id_int_1 = cdl. PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. rev_distribution_id. pjc_organization_id. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. I want to get the. Task Description 5. Get it resolved, from our Support team. pjc_exp_items_all expeo, pjf_projects_all_vl prj, pjf_proj_elements_vl trn_tsk, RA_CUSTOMER_TRX_all RCTA, RA_CUST_TRX_TYPES_ALL RACTL, PER_PERSON_NAMES_F_V PersonNameDPEO, PER_ALL_ASSIGNMENTS_M PAAM, PER_PERSON_TYPES_vl PPTL. This table is used to store the errors that could ocurr in various processes in project billing. Users are writing an audit report so that they can show the AP invoices that were entered that generated PA Expenditure Items. period_name PERIOD_NAME. AP_INVOICES_ALL is the parent table of AP_INVOICE_LINES_ALL table which is used to store the Invoice Line Details. invoice_id AND aid. TRANSFERRED_FROM_EXP_ITEM_ID: NUMBER (15) The identifier of the expenditure item from which this expenditure item originated. TRANSACTION_SOURCE = 'OSCM'. line_number. organization_id = aid. expenditure_type_id. SQL_Statement; SELECT. AND doc. Tables for the Items in Oracle fusion. TRANSFERRED_FROM_EXP_ITEM_ID. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil,. Who column: indicates the user who created the row. project_id(+) AND pei. NAME AS expenditure_bu, v515220161. contract_id =. expenditure_item_id, expenditureitempeo. source_attribute2Goal. Query to Find Projects Not Accruing Revenue in Oracle Fusion --*-- SELECT PE. PJC_CINT_EXP_TYP_ECL_ALL; PJC_CINT_EXP_TYP_ECL_ALL. Schema: FUSION. carrying_out_organization_id AND hou1. All, Can anyone provide me a table level link to the Oracle iExpenses tables, AP_EXP*REPORT* tables and the AP_INVOICES/AP_INV. Oracle Projects creates expenditure groups for supplier invoices transferred from Oracle Payables. 2. tm_rep_atrb_id Pjc_Exp_Time_Repos_Atrb_id, PjcExpAtrbs. State 2. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. This guide contains information about tables within. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PJF_TASKS_V. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. invoice_id = ail. AND imp. 1. We want to derive the Accounting Code Combination based on Expenditure Types. Tables and Views for Project Management. Any idea in which table this can be found or any query to achieve this. Requirement: --------------- 1. WHERE EXP. system_linkage_function /* 30623237 (SELECT exp. PARENT_LINE_NUMBER. project_id AND pei. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. system_linkage_function /* 30623237 (SELECT exp. r_company, x. . Cost associated with each expenditure type is excluded from the capitalized interest calculation. Next Page. txt), PDF File (. source_id_int_1 = cdl. AP_Invoices_All has the unique key on invoice_id. INVENTORY_ITEM_ID. full_name AS employee_name, v55152034. WHERE pcdl. Regards, Zahid Rahim. ---------------. approved_flag. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. 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. The number of line items AP_INVOICE_LINES_ALL and Distribution AP_INVIOCE_DISTRIBUTIONS_ALL do not. AND imp. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. project_number, a. This number is incremented every time that the row is updated. receipt_currency_code ei_receipt_currency_code, peia. 23B. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. PA_EXPENDITURE_GROUPS_ALL stores groups or batches of pre-approved expenditures entered by a user. Qn1:On : 11. PJC_CC_DIST_LINES_ALL. Object type: TABLE. invoice_line_number = ail. 0 version, Manage Project Costs-Allocate Project Costs. operating_unit_name, a. EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL. Goal. Asset Cost 6. TO_CHAR (acct_period_date, 'DD-MON-YYYY') expenditur_item_date FROM (SELECT v36738276. sql file in patch 13833481. TRANSACTION_NUMBER. This web page provides a list of tables and views for Oracle Fusion Cloud Project Management, a cloud-based application for project portfolio management. PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. val_unit_id, ct. LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. Stores expenditure type exclusions by interest rate code for each operating unit. TRUNC (peia. It doesn’t matter how complex the issues would be. ** COST_IND_RATE_SCH_ID:. Cloud Applications. vendor_name. Version (include the version you are using, if applicable):This table contains non-persistent data and is used to expose summary data to Essbase. Schema: FUSION. Title and Copyright Information; Get Help; 1 Overview. E means Encumbrance entry. ProjectsAtrbs. 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,. source_attribute1. Object type: TABLE. Our support team constitutes of highly skilled & trained technicians who have years of experience in handling technical defects. attribute_varchar1 Pjc_Billable_Flag, ProjectsAtrbs. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. WHERE ei. SELECT pcdl. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. NUMBER. AND TSRC. 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. task_id(+) AND pei. invoice_id = aid. Contents. gl_date. Regards, Zahid Rahim. usages_source_id, PjcExpAtrbsUsg. expenditure_item_id AS expenditure_item_id,. pjc_project_id project_id, crt. 11. The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. The PJC_PRJ_REQ_DIST_V view displays attributes such as requisition number, item description, and vendor name. Also PO_DISTRIBUTIONS_ALL is the table which in my experience connects Purchase. project_id = ptv. 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. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). Value will be RCV. Select aia . 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. They use stored queries that derive data from the tables on which the views are based. project_id(+) AND pei. 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. NAME ei_expenditure_org_name, op. 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. Joining these tables, there are rows with opposite capitalizable_flag in two tables. Previous Next JavaScript must be enabled to correctly display this content . PJB_ERRORS_U1. PJC_PROJECT_ID = ppat. pei. A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter. Simply search with the table name in google, you’ll get complete details about the table and columns in it. 1. NAME AS expenditure_org, v55152034. cost_book_id, ct. 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. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. project_type_id. API Create a valid category set. linked_task_id. transaction_id, 'CST_TRANSACTIONS' source_table, ct. SELECT PjcExpAtrbs. 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:. invoice_id AND aid. Project Portfolio. 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_SOURCE_ID = TSRC. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. 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. Schema: FUSION. Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. Query. WITH gl_cmn_tbls. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. AR Transactions and Tax Query - India Localization. Cloud. , revdist. PJC_ORGANIZATION_ID 1. AND POL. . Fusion Inventory Queries2. 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,. For any update on columns other than the system populated columns, two records are created in this table. line_type. transaction_source_id, expenditureitempeo. document_id, expenditureitempeo. Base Table: PJC_EXP_ITEMS_ALL Import Process: Import Costs STEP 1: Download FBDI template from oracle website. 90; ADJUSTED_EXPENDITURE_ITEM_ID: 1993042; Project: 4056; For Item ID 1993042: Created: 14/02/2020 14:04:46; Quantity: 110. You can configure transaction controls by employee, expenditure category, expenditure type, and non-labor. There can be only one record for the combination of Supplier and the invoice number. WHERE(invoiceheadereo. project_currency_code ei_project_currency_code, hr. event_id. INVENTORY_ITEM_ID. project_id AND ptv. TRANSACTION_NUMBER. project_id AND ptv. Value will be RCV. It also includes some PO data and project data as well. project_id AND pei. Projects Self Service Reporting Duty. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Dear All, About Oracle Fusion Applications Cloud (Oracle's SaaS ERP) . It can be B (burdened) or R (raw) Offset method. Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. source_prvdr_gl_date. Project Management. 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:. This table is used to store the errors that could ocurr in various processes in project billing. attribute_category Pjc_Attribute_Category, ProjectsAtrbs. The inventory item associated with the incurred cost. NUMBER. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. 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,. entered_currency_codeIt can be R (raw) or B (burdened) Cost type of offset transactions. Cloud. Cloud Applications. project_id = prb. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. invoice_date. creation_date5 AS acct_period_date, v103611946. NAME AS expenditure_org, v55152034. pjc_expenditure_type_id = pet. The relationships between Expenditure Types and System Linkages. SELECT EXP. Details. Please help. pjc_exp_items_all: pjf_proj_elements_b: TASK_ID: pjf_proj_elements_b: pjf_proj_elements_b: PARENT_STRUCTURE_ID:. project_id AND hou. . description. inventory_item_id}. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. 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. (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. project_id AND pei. quantity. Details. Applies to: Oracle Project Costing - Version 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. pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. 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; application_id. ei_project_numbe. attribute_number4 Pjc_Project_Unit, 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. Unit Number 4. source_pa_period_name. Extract for Payments - Check and EFT. NUMBER. cdl_line_number. 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 . Who column: indicates the date and time of the creation of the row. Change the transaction source or original system reference of the expenditure item to be imported. PJF_EXP_TYPES_VL. To get the. 18. Project Management. which GL accounts will be hit by the system. This causes some records to exist with NULL values in the DOCUMENT_DISTRIBUTION_ID in the PA_EXPENDITURE_ITEMS_ALL table. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Oracle ERP/ FSCM. 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,. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. INVENTORY_ITEM_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. Schema: FUSION. pjc_exp_items_all pei. Simply search with the table name in google, you’ll get complete details about the table and columns in it. PJC_EXP_ITEMS_ALL ei, GET_PERIOD_AVG_RATE gpavg WHERE aia. 18. Views are logical representations of a single or combination of tables. 50. project_id = prb. expenditure_item_id = RevDist. Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction. 1. expenditure_item_id = pei. 18. After upgrading from 11i to 12. pjc_exp_items_all pei,. . PJC_TRANSACTION_CONTROLS. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. Details. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. org_id employee_cost_org_id, pcdl. 18. An invoice can have multiple distributions. A distribution must be associated with an invoice. | Data Managementexpenditure_item_id source_exp_item_id, line_num source_line_num, expenditure_item_date source_exp_item_date, burden_cost source_burden_cost, denom_burdened_cost source_denom_burdened_cost, acct_burdened_cost source_acct_burdened_cost, project_burdened_cost source_project_burdened_cost,. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. 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. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. We would like to show you a description here but the site won’t allow us. 10. 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. AND ppa. FROM hwm_tm_rep_atrbs PjcExpAtrbs, hwm_tm_rep_atrb_usages PjcExpAtrbsUsg, HWM_TM_ATRB_FLDS_B PjcExpAtrbFlds. . . AS (SELECT DISTINCT GL. NAME project_owning_org, CASE WHEN. prvdr_gl_period_name gl_period, pcdl. project_id = prl. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task: CONVERTED_FLAG: VARCHAR2 (1) Flag set to 'Y' if the item is converted. 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. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. task_id = ptv. 1. 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). Comment - Asset Source Line I need above fields will be in the fixed asset module 1. Project Name 2. 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. They would like to replicate this for custom reporting. crt. SELECT ppa. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. prvdr_pa_period_name, NVL (pei. FROM pjf_projects_all_vl PPA,pjb_cntrct_proj_links PCPL,okc_k_lines_b OKL,okc_k_headers_all_b OKH,okc_contract_types_vl OCTV,pjf_project_types_vl PPT,hr_all_organization_units HOUPA_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. select a. I can see on PJC_EXP_ITEMS_ALL that there is: Item ID 1993045 Created: 14/02/2020 14:06:31; Quantity: -110. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. ,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. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). (SELECT expenditureitempeo. So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). This report will display all project unbilled details. WHERE 1 = 1. denom_currency_code. They can go online to PA Expenditure Item Inquiry and drill back to to the AP Invoice using the 'Item Details' functionality. 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. 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. 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_expenditure_type_id expenditure_type_id, crt. 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. event_id = cdl. Extract for Payments - Check and EFT. expenditure_item_id = RevDist. Who column: indicates the user who created the row. WHERE EXP. Version (include the version you are using, if applicable):PA_TRANSACTION_CONTROLS stores the transaction controls defined for projects or tasks. 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. 0 version, Manage Project Costs. 15. organization_id = ppat. Legal Entity 3. inventory_item_id}. transaction. Tablespace: APPS_TS_TX_DATA. ei_project_name, x. FROM PJC_EXP_ITEMS_ALL PEI WHERE PEI. 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 Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. In my recent project, I have asked to write an outbound interface from Oracle Apps Fixed Assets R12 module to external legacy systems. cmr_rcv_transaction_id.