Journals
Discussion List
-
Sandbox default value from LOVHi, is there a way to default the Category field on the Create Subledger Journal Entry screen (General Accounting > Journals > Create Subledger Journal Entry) Currently,…Suhailah Raza 33 views 2 comments 0 points Most recent by Suhailah Raza General Ledger & Intercompany -
One Journal category transaction should not flow to Secondary and reporting ledgerSummary: The business case is they wanted one Journal category to be created for which any GL journals created with that category should not flow to Secondary ledger and…chetan bachani 27 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Error in loading Journals/batches attachments using ERPObjectAttachment ServiceSummary: Hi Team, We are trying to load journal attachments using ERPAttachment SOAP service, but getting below errors, any pointers to what roles are needed, seeded Gen…raban 62 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Journal Upload - ADFDI-05559Hello, I have a user that is trying to upload an ADFDI journal that has aprox 20,000 lines on it. During the submit phase they are getting the following error: Row cache…BenSayers 159 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
All the Manual JV created accounting date is getting defaulted to End of MonthSummary: Hi Experts Can you please advise while creating Manual Journals, Accounting date is getting defaulted to End of Month. Why the JV is created with System Date (1… -
Auto transfer of debtors having credit balance and creditors having debit balance to another accountSummary: How can debtors having credit balance and creditors having debit balance be transferred automatically to another account in order to show the same separately fr…Jiten Jataniya 17 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany -
Transfer of amount from Retained Earning account to a separate GL accountCustomer wants to schedule an automatic transfer of 20% of the amount transferred in retained earning account during the year to a separate GL a/c at year end. How this …Jiten Jataniya 4 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany -
Must the revaluation journal reversal be triggered by opening a new GL Period?Summary: Good Afternoon everyone, Could you please assist me with the following two questions (happy to log them separately if required): As I understand it, the journal… -
GL Journal Lines reporting for Mexico's Electronic Invoice UUIDSummary: I have a requirement to store Mexico's electronic invoice number (aka UUID) at the GL Journal Lines level. The UUID is being passed from Oracle Cloud Payables t…NancyR_Bravo 106 views 2 comments 0 points Most recent by NancyR_Bravo General Ledger & Intercompany -
How to update GL Journal category (on Journal Header) for Unposted Batch in bulk or using REST APISummary: We need to update journal category for some of the Journal Entry at header , is there any Rest or SOAP API? Journal Header / Batch is unposted and Approval stat…Gaurav Godbole 19 views 2 comments 0 points Most recent by Gaurav Godbole General Ledger & Intercompany -
Has anyone ever come across this particular error when uploading CVRs via Spreadsheet?I am updating a Production environment with the latest batch of CVRs and there are quite a lot of condition filter values(less than 500). When I go to submit, I am getti…Eoin O'Neill 15 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Can we Create General Ledger Account Sequences for Branch wise in Oracle fusionHI We have Branch Segment in Chart of Accounts, So Business Will select the Branch values in Code Combination in while Journal Creation, So based on that Can we create G…Gujjari Raju 15 views 5 comments 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
journal interfaceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Why does the User currency rate 1 requires a pre defined Exchange Rate?Summary: Why does the User Rate 1 requires a pre defined Exchange Rate Content (please ensure you mask any confidential information): When we do a foreign currency journ…ramesh.sivapalan 9 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Can Journal source LOV be restricted through a specific custom role while spreadsheeupload?Summary: Can Journal source LOV in subledger journal entry be restricted through personalization for a specific custom role while spreadsheet upload? Requirement is to r…Neha_Naringrekar 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub -
What is the maximum number of supporting documents that can be attached to a Journal BatchSummary: What is the maximum number of supporting documents that can be attached to a Journal Batch ? What should be the maximum size of each attachment. (The informatio…Jayendra Sreekar Kurali 26 views 2 comments 0 points Most recent by Jayendra Sreekar Kurali General Ledger & Intercompany -
How do I transfer the values from Payables i.e. Vendor ID and PO No. to GL Journal Lines?Summary: Content (please ensure you mask any confidential information): Yes Version (include the version you are using, if applicable): Fusion 24A Code Snippet (add any …Shankar K R 18 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management -
How to add validation on button and show some message or restrict user some saving journalSummary: Hi Experts I have requirement here when user tries to click on save button i want to restrict user from going ahead based on some date logic or show a error mes…shaikh123 8 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany -
can source name of auto generated allocation journal entries be changed?When we generate allocation rule, journal entry created with allocation as source. can we change that journal source name?Jiten Jataniya 19 views 1 comment 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany -
How can you limit transaction amounts to two decimal placesSummary: Client has a requirement to limit transaction amounts to two decimal places to avoid rounding issues Content (please ensure you mask any confidential informatio…bevwhite 132 views 1 comment 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany -
Reference Date in GL Journal HeaderSummary: Hi do you know, if it's possible to use Reference Date in the Journal Header level to recalculate value from Primary Ledger to Secondary Ledger with exchange ra… -
Need to clarification on Journals amount roundingSummary: When Journals are posted to the GL, we need to know whether the system rounds the amount up or down during calculations Content (please ensure you mask any conf…Kannaki Pugalenthi 32 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany -
Search/filter/report on transactions by company and cost centerSummary: Is there a way to search/filter/report on transactions by company and cost center which are two segments in the chart of accounts structure? Content (please ens…bevwhite 4 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany -
Can some bsv's create journals in a closed period?Summary: The requirement is to allow some BSV's in a ledger to allow journals created in a closed period. Content (please ensure you mask any confidential information): … -
How to modify Journal batch name for all journals and add period and created by objectsSummary: Our client is using EBS R12 as their legacy system and currently they have to automate the journal batch name user need not provide the details automatically sy…Basant Parihar 102 views 2 comments 0 points Most recent by Basant Parihar General Ledger & Intercompany -
FBDI - importBulkData REST API to trigger multiple import jobs with different parametersSummary: We are using importBulkData operation of "/fscmRestApi/resources/11.13.18.05/erpintegrations" REST API (non OIC as middleware) to import journals data into orac…Shail369 354 views 3 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
FX Revaluation - Conversion from Transaction Currency (Non-USD) to Functional Currency (USD)Hi, It is required to achieve conversion from Transaction Currency (Non-USD) to Functional Currency (USD) In a third party tool (Non-Oracle system), for all those transa…SaurabhSinghal26 4 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany -
Report for Unused Natural AccountSummary: We would like to find list of unused natural accounts (if a account was not used for booking/journal entry in any entity for a certain period of time). Is there…Sathish Ravi 19 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
is possible to bring the DFF value to the auto-reversed journal from the source Journal in fusion GLIt is feasible to transfer the Descriptive Flexfield (DFF) value to the auto-reversed journal from the originating Journal in Fusion General Ledger. -
Natural Account DescriptionSummary: Hi, We have a requirement to display only Natural account description under GL-->Journal -->Lines--> Account Description. Please suggest solution, Uploaded scre…