Entries by Oracle ERP Apps Guide

, ,

Release 12.0, the “Import Standard Purchase Orders” concurrent program fails with the following error: ERROR ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure init_sys_parameters.0

On Release 12.0, the “Import Standard Purchase Orders” concurrent program fails with the following error: ERROR ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure init_sys_parameters.0 ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure init_startup_values.10 ORA-01422: exact fetch returns more than requested number of […]

/by
, , ,

On-hand inventory information

The following select statement would extracts all on-hand inventory information from OracleApplications base tables. Note:- You may need to modify the query to match with your instance conditions and your requirements. SELECTNVL(substr(org.organization_code, 1,3), ‘ ‘) orgcode,NVL(substr(msi.segment1, 1, 8), ‘ ‘) seg11,NVL(substr(msi.segment1, 9, 8), ‘ ‘) seg12,NVL(substr(msi.segment1, 17, 4), ‘ ‘) seg13,NVL(moq.subinventory_code, ‘ ‘) sub_inv_code,NVL(to_char(round(sum(moq.transaction_quantity))), ‘ […]

/by
, ,

Know license applications

Know license applications:-——————————-Lot many times we would not be known if the client has the specific application license or not. We can ask the client is one way. If you have access to the back-end for the production Instance. Then you could know with following query. This is the Other way.  All the applications which […]

/by
, ,

FlexFields

Flexfields stores main Information of the Organizations. We have many flexfields in different modules. Note:- The following Flexfields are avilable in the 11.5.8 Oracle Application Version.—– You may find more flexfield in the new Oracle apps versions. To check all the Flexfield avilable for your Oracle Apps version, use the Flexfield Query Application Name Flex-field Name […]

/by